1: <?php
  2: /*****************************************************************************************
  3:  * X2Engine Open Source Edition is a customer relationship management program developed by
  4:  * X2Engine, Inc. Copyright (C) 2011-2016 X2Engine Inc.
  5:  * 
  6:  * This program is free software; you can redistribute it and/or modify it under
  7:  * the terms of the GNU Affero General Public License version 3 as published by the
  8:  * Free Software Foundation with the addition of the following permission added
  9:  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 10:  * IN WHICH THE COPYRIGHT IS OWNED BY X2ENGINE, X2ENGINE DISCLAIMS THE WARRANTY
 11:  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 12:  * 
 13:  * This program is distributed in the hope that it will be useful, but WITHOUT
 14:  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 15:  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 16:  * details.
 17:  * 
 18:  * You should have received a copy of the GNU Affero General Public License along with
 19:  * this program; if not, see http://www.gnu.org/licenses or write to the Free
 20:  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 21:  * 02110-1301 USA.
 22:  * 
 23:  * You can contact X2Engine, Inc. P.O. Box 66752, Scotts Valley,
 24:  * California 95067, USA. or at email address contact@x2engine.com.
 25:  * 
 26:  * The interactive user interfaces in modified source and object code versions
 27:  * of this program must display Appropriate Legal Notices, as required under
 28:  * Section 5 of the GNU Affero General Public License version 3.
 29:  * 
 30:  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 31:  * these Appropriate Legal Notices must retain the display of the "Powered by
 32:  * X2Engine" logo. If the display of the logo is not reasonably feasible for
 33:  * technical reasons, the Appropriate Legal Notices must display the words
 34:  * "Powered by X2Engine".
 35:  *****************************************************************************************/
 36: 
 37: Yii::import('application.components.util.*');
 38: 
 39: /**
 40:  * Repair action/contact data corrupted by user deletion prior to version 4.1
 41:  */
 42: class RepairUserDataCommand extends CConsoleCommand {
 43: 
 44:     public function actionRepair ($username) {
 45:         /**/print ("Repairing user data for ".$username."\n");
 46: 
 47:         $adminUser = User::model()->findByPk(1);
 48:         if (!$adminUser) {
 49:             throw new CException (Yii::t('app', 'admin user could not be found'));
 50:             return 1;
 51:         }
 52: 
 53:         $params = array (
 54:             ':username' => $username,
 55:             ':adminUsername' => $adminUser->username
 56:         );
 57: 
 58:         /**/print ("Reassigning associated actions\n");
 59: 
 60:         // reassign associated actions
 61:         Yii::app()->db->createCommand("
 62:             UPDATE x2_actions 
 63:             SET updatedBy=:adminUsername
 64:             WHERE assignedTo=:username AND updatedBy=:username
 65:         ")->execute ($params);
 66:         Yii::app()->db->createCommand("
 67:             UPDATE x2_actions 
 68:             SET completedBy=:adminUsername
 69:             WHERE assignedTo=:username AND completedBy=:username
 70:         ")->execute ($params);
 71:         Yii::app()->db->createCommand("
 72:             UPDATE x2_actions 
 73:             SET assignedTo='Anyone'
 74:             WHERE assignedTo=:username
 75:         ")->execute (array (
 76:             ':username' => $username
 77:         ));
 78: 
 79:         /**/print ("Reassigning associated contacts\n");
 80: 
 81:         // reassign related contacts to anyone
 82:         Yii::app()->db->createCommand("
 83:             UPDATE x2_contacts 
 84:             SET updatedBy=:adminUsername
 85:             WHERE assignedTo=:username AND updatedBy=:username
 86:         ")->execute ($params);
 87:         Yii::app()->db->createCommand("
 88:             UPDATE x2_contacts 
 89:             SET assignedTo='Anyone'
 90:             WHERE assignedTo=:username
 91:         ")->execute (array (
 92:             ':username' => $username
 93:         ));
 94: 
 95:         return 0;
 96:     }
 97: 
 98: }
 99: 
100: ?>
101: 
102: