public final function signinExecute(MUser $me)
{
$shop = $me->getShop();
$this->pageExecute($me, $shop);
$this->assign('title', $this->title);
$this->displayTemplate($this->page);
}
protected final function signinExecute(MUser $me)
{
$shop = $me->getShop();
$respondJson = $this->ajaxExecute($me, $shop);
DAssert::assert($respondJson instanceof MJsonRespond, 'illegal json respond');
$this->displayJson($respondJson);
}
/** called before any actions **/
public function onBefore()
{
global $MONGO;
//exception handler
set_exception_handler(array($this, "exceptionHandler"));
$this->_admin = MUser::userInSession();
if (!$this->_admin) {
//if user is loged in?
$server = MServer::serverWithIndex(xi("host"));
//filter server plugins
if (class_exists("RFilter")) {
RFilter::apply("SERVER_FILTER", $server);
}
//if auth is disabled
if ($server && !$server->mongoAuth() && !$server->controlAuth()) {
MUser::login("rockmongo_memo", "rockmongo_memo", xi("host"), "admin", 10800);
$this->_admin = MUser::userInSession();
} else {
$this->redirect("login.index", array("host" => xi("host")));
}
}
if (!$this->_admin->validate()) {
$this->redirect("login.index", array("host" => $this->_admin->hostIndex()));
}
$this->_server = MServer::serverWithIndex($this->_admin->hostIndex());
$this->_mongo = $this->_server->mongo();
//log query
if (isset($MONGO["features"]["log_query"]) && $MONGO["features"]["log_query"] == "on") {
$this->_logQuery = true;
}
//render header
if (!$this->isAjax()) {
render_view("header");
}
}
/**
*
* 初始化用户数据, 以便之后存入缓存
* @param array $user 用户对象
* @return mixed $value 返回初始化对象的结果
*/
public static function initUser($user)
{
if ($user === null) {
return null;
}
$userObj = new MUser();
$userObj->assembleUser($user);
return $userObj;
}
/**
* login page and post
*/
public function doIndex()
{
global $MONGO;
$password = trim(xn("password"));
$this->username = trim(xn("username"));
$this->db = trim(xn("db"));
$this->hostIndex = xi("host");
$this->languages = rock_load_languages();
$this->expires = array(3 => "3 " . rock_lang("hours"), 720 => "1 " . rock_lang("month"));
$this->moreOptions = xi("more");
if ($this->isPost()) {
//server exists?
if (!isset($MONGO["servers"][$this->hostIndex])) {
$this->message = "Server does not exist";
return;
}
//authenticate
$server = MServer::serverWithIndex($this->hostIndex);
if (!$server->auth($this->username, $password, $this->db)) {
$this->message = rock_lang("can_not_auth");
$this->display();
return;
}
//remember user
import("models.MUser");
MUser::login($this->username, $password, $this->hostIndex, $this->db, xi("expire") * 3600);
//remember lang
setcookie("ROCK_LANG", x("lang"), time() + 365 * 86400);
//jump to admin page
$this->redirect("admin.index", array("host" => $this->hostIndex));
} else {
$this->display();
}
}
public static function signup($username, $password, $email)
{
$md5password = md5($password);
DalPCUser::addUser($username, $md5password);
$uid = DalPCUser::insertID();
DalPCUser::setUserInfo($uid, $email);
MUser::persistentUserLogin($username, $md5password);
return $uid;
}
public static function me()
{
if (!self::$me) {
$user_login = self::getUserIfLogin();
if (empty($user_login)) {
throw new Exception("not signin", ERR_USER_NOT_SIGNIN);
}
self::$me = new MUser($user_login['uid'], $user_login);
}
return self::$me;
}
public function execute()
{
$username = MRequest::post('username');
$password = MRequest::post('password');
$md5password = md5($password);
$me = MUser::signin($username, $md5password);
if (!$me) {
redirect('/signin');
return;
}
redirect('/');
}
public final function execute()
{
$this->init();
try {
$me = MUser::me();
} catch (Exception $e) {
$me = null;
}
$this->me = $me;
$this->pageExecute();
$this->assign('me', $this->me);
$this->assign('title', $this->title);
$this->assign('page', $this->page);
$this->displayTemplate('framework.tpl.php');
}
public final function execute()
{
$this->init();
try {
$me = MUser::me();
} catch (Exception $e) {
switch ($e->getCode()) {
case ERR_USER_NOT_SIGNIN:
$this->userNotSignin();
break;
default:
$this->checkSigninFail($e);
break;
}
return;
}
$this->signinExecute($me);
}
protected function _logFile($db, $collection)
{
$logDir = dirname(__ROOT__) . DS . "logs";
return $logDir . DS . urlencode($this->_admin->username()) . "-query-" . urlencode($db) . "-" . urlencode($collection) . ".php";
}
/**
* Enter description here ...
*
* @return MUser
*/
public static function userInSession()
{
if (array_key_exists("login", $_SESSION) && array_key_exists("username", $_SESSION["login"]) && array_key_exists("password", $_SESSION["login"]) && array_key_exists("index", $_SESSION["login"]) && array_key_exists("db", $_SESSION["login"])) {
$user = new MUser();
$user->setUsername($_SESSION["login"]["username"]);
$user->setPassword($_SESSION["login"]["password"]);
$user->setHostIndex($_SESSION["login"]["index"]);
$user->setDb($_SESSION["login"]["db"]);
return $user;
}
return null;
}
public static function getUser($id = null)
{
$instance = MUser::getInstance($id);
return $instance;
}
/**
* Construct mongo server connection URI
*
* @return string
*/
public function uri()
{
$host = $this->_mongoHost . ":" . $this->_mongoPort;
if ($this->_mongoAuth) {
$user = MUser::userInSession();
return $user->username() . ":" . $user->password() . "@" . $host;
}
if (empty($this->_mongoUser)) {
return $host;
}
return $this->_mongoUser . ":" . $user->_mongoPass . "@" . $host;
}
public function pageExecute()
{
MUser::signout();
redirect('/');
}
/**
* Test
*
* @test
*
* @return void
*/
public function selectLikeOpenStart()
{
$user = new MUser();
$count = $user->get()->where('firstname', 'like', '%ny')->count();
$this->assertEquals(2, $count);
}
public function getUser()
{
return $this->hasOne(MUser::className(), ['death_id' => 'death_id']);
}
public function save($updateOnly = false)
{
// Allow an exception to be thrown.
try {
// If user is made a Super Admin group and user is NOT a Super Admin
//
// @todo ACL - this needs to be acl checked
//
$my = MFactory::getUser();
//are we creating a new user
$isNew = empty($this->id);
// If we aren't allowed to create new users return
if ($isNew && $updateOnly) {
return true;
}
// Get the old user
$oldUser = new MUser($this->id);
// Fire the onUserBeforeSave event.
MPluginHelper::importPlugin('user');
$dispatcher = MDispatcher::getInstance();
$result = $dispatcher->trigger('onUserBeforeSave', array($oldUser->getProperties(), $isNew, $this->getProperties()));
if (in_array(false, $result, true)) {
// Plugin will have to raise its own error or throw an exception.
return false;
}
//////////////////////////////////////
//todo:: update old user
//////////////////////////////////////
register_new_user($this->username, $this->email);
// Fire the onUserAfterSave event
$dispatcher->trigger('onUserAfterSave', array($this->getProperties(), $isNew, $result, $this->getError()));
} catch (Exception $e) {
$this->setError($e->getMessage());
return false;
}
return $result;
}
/** change current host **/
public function doChangeHost()
{
$index = xi("index");
MUser::userInSession()->changeHost($index);
$this->redirect("admin.index");
}
/**
* Migrate from old project management system.
*/
public function actionIndex()
{
// check rights
if (!Yii::app()->user->checkAccess(User::ADMINISTRATOR)) {
throw new CHttpException(403, Yii::t('Yii', 'You are not authorized to perform this action.'));
}
// models to migrate
$migrate = array('User' => false, 'Company' => false, 'CompanyPayment' => false, 'Project' => false, 'Task' => false, 'Time' => true, 'Invoice' => false, 'Expense' => false);
// start
$message = '';
// we won't migrate unless form is submitted
if (Yii::app()->request->isPostRequest) {
// default criteria
$findAllCriteria = new CDbCriteria();
$findAllCriteria->order = "`id` ASC";
if ($migrate['User']) {
// user
$mUsers = MUser::model()->findAll($findAllCriteria);
if (is_array($mUsers)) {
$i = $j = $c = 0;
$accessType = array('customer' => 'client', 'consultant' => 'consultant', 'manager' => 'manager', 'admin' => 'administrator');
$accessLevel = array('customer' => 2, 'consultant' => 3, 'manager' => 4, 'admin' => 5);
foreach ($mUsers as $oldModel) {
if (($model = User::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
// old model validation
if (User::model()->findByAttributes(array('email' => $oldModel->email))) {
$oldModel->email = rand(10, 99) . $oldModel->email;
}
$closeTime = strtotime($oldModel->close_date);
$isActive = empty($oldModel->close_date) || $oldModel->close_date === '0000-00-00' || $closeTime === false;
// new model
$model = new User('migrate');
$model->username = $oldModel->email;
$model->password = md5($oldModel->password);
$model->email = $oldModel->email;
$model->screenName = $oldModel->name;
$model->accessType = isset($accessType[$oldModel->class]) ? $accessType[$oldModel->class] : 'member';
$model->accessLevel = isset($accessLevel[$oldModel->class]) ? $accessLevel[$oldModel->class] : 1;
$model->isActive = $isActive ? '1' : '0';
$model->createTime = strtotime($oldModel->last);
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
if (($userDetails = UserDetails::model()->findByPk($model->id)) !== null) {
$userDetails->delete();
}
$userDetails = new UserDetails('migrate');
$userDetails->emailConfirmationKey = md5(uniqid(rand(), true));
$userDetails->initials = $oldModel->inits;
$userDetails->occupation = $oldModel->title;
$userDetails->deactivationTime = $isActive ? null : $closeTime;
$userDetails->administratorNote = '[from migration]';
$userDetails->userId = $model->id;
$userDetails->save();
// relation between user and company
if ($oldModel->customer_id >= 1) {
$user2Company = new User2Company('migrate');
$user2Company->userId = $model->id;
$user2Company->companyId = $oldModel->customer_id;
$user2Company->position = 'owner';
//$oldModel->title
if ($user2Company->save()) {
$c++;
}
}
}
$j++;
}
$message .= $i . ' of ' . $j . ' users' . ($i === $c ? '' : ' with ' . $c . ' company (relations)') . ' have been migrated.<br/>';
}
}
if ($migrate['Company']) {
// company
$mCustomers = MCustomer::model()->findAll($findAllCriteria);
if (is_array($mCustomers)) {
$i = $j = $l = 0;
foreach ($mCustomers as $oldModel) {
if (($model = Company::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
$closeTime = strtotime($oldModel->close_date);
$isActive = empty($oldModel->close_date) || $oldModel->close_date === '0000-00-00' || $closeTime === false;
$model = new Company('migrate');
$model->title = $oldModel->name;
$model->titleAbbr = $oldModel->inits;
$model->contactName = $oldModel->contact;
$model->contactEmail = $oldModel->contact_email;
$model->content = '[from migration]';
$model->contentMarkup = 'text';
$model->invoiceDueDay = $oldModel->terms_days;
$model->isActive = $isActive ? '1' : '0';
$model->deactivationTime = $isActive ? null : $closeTime;
$model->createTime = strtotime($oldModel->last);
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
// associated location
$location = new Location('migrate');
$location->address1 = $oldModel->addr;
$location->address2 = $oldModel->addr2;
$location->city = $oldModel->city;
$location->state = $oldModel->state;
$location->zipcode = $oldModel->zip;
$location->content = '[from migration]';
$location->contentMarkup = 'text';
$location->createTime = strtotime($oldModel->last);
if ($location->save()) {
// relation between company and location
$location2Record = new Location2Record('migrate');
$location2Record->locationId = $location->id;
$location2Record->record = get_class($model);
$location2Record->recordId = $model->id;
if ($location2Record->save()) {
$l++;
}
}
}
$j++;
}
$message .= $i . ' of ' . $j . ' companies' . ($i === $l ? '' : ' with ' . $l . ' locations') . ' have been migrated.<br/>';
}
}
if ($migrate['CompanyPayment']) {
// company payment
$mCustomerPayments = MCustomerPayment::model()->findAll($findAllCriteria);
if (is_array($mCustomerPayments)) {
$i = $j = 0;
$paymentMethod = array('cash' => 'cash', 'check' => 'check', 'credit card' => 'creditCard');
foreach ($mCustomerPayments as $oldModel) {
if (($model = CompanyPayment::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
$model = new CompanyPayment('migrate');
$model->companyId = $oldModel->id;
$model->paymentDate = MDate::formatToDb($oldModel->payment_date, 'date');
$model->amount = $oldModel->amount;
$model->paymentMethod = $paymentMethod[$oldModel->payment_method];
$model->paymentNumber = $oldModel->payment_number;
$model->content = $oldModel->note . "\n" . '[from migration]';
$model->contentMarkup = 'text';
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
}
$j++;
}
$message .= $i . ' of ' . $j . ' company payments have been migrated.<br/>';
}
}
if ($migrate['Project']) {
// project
$mProjects = MProject::model()->findAll($findAllCriteria);
if (is_array($mProjects)) {
$i = $j = $c = $u = 0;
foreach ($mProjects as $oldModel) {
if (($model = Project::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
$openDateNotSet = empty($oldModel->open_date) || $oldModel->open_date === '0000-00-00' || strtotime($oldModel->open_date) === false;
$closeDateNotSet = empty($oldModel->close_date) || $oldModel->close_date === '0000-00-00' || strtotime($oldModel->close_date) === false;
$model = new Project('migrate');
$model->title = $oldModel->name;
$model->content = $oldModel->description . "\n" . '[from migration]';
$model->contentMarkup = 'text';
$model->hourlyRate = $oldModel->rate;
$model->openDate = $openDateNotSet ? null : MDate::formatToDb($oldModel->open_date, 'date');
$model->closeDate = $closeDateNotSet ? null : MDate::formatToDb($oldModel->close_date, 'date');
$model->createTime = strtotime($oldModel->last);
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
// relation between project and company
if ($oldModel->customer_id >= 1) {
$company2Project = new Company2Project('migrate');
$company2Project->companyId = $oldModel->customer_id;
$company2Project->projectId = $model->id;
if ($company2Project->save()) {
$c++;
}
}
// relation between project and manager
if ($oldModel->manager_id >= 1) {
$user2Project = new User2Project('migrate');
$user2Project->userId = $oldModel->manager_id;
$user2Project->projectId = $model->id;
$user2Project->role = 'manager';
if ($user2Project->save()) {
$u++;
}
}
}
$j++;
}
$message .= $i . ' of ' . $j . ' projects' . ($i === $c ? '' : ' with ' . $c . ' company (relations)') . ($i === $u ? '' : ' with ' . $u . ' manager (relations)') . ' have been migrated.<br/>';
}
}
if ($migrate['Task']) {
// task
$mTasks = MTask::model()->findAll($findAllCriteria);
if (is_array($mTasks)) {
$i = $j = $u = $m = 0;
$priority = array('A' => 2, 'B' => 3, 'C' => 4, '' => 3);
$status = array('' => 'completed', 'Open' => 'completed', '0' => 'notStarted', 'New' => 'notStarted', 'Done' => 'completed', 'In Progress' => 'inProgress', 'Ready to Test' => 'readyToTest');
foreach ($mTasks as $oldModel) {
if (($model = Task::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
$hourlyRate = null;
if ($oldModel->project_id >= 1 && ($project = Project::model()->findByPk($oldModel->project_id)) !== null) {
$hourlyRate = $project->hourlyRate;
}
$dueDateNotSet = empty($oldModel->due_date) || $oldModel->due_date === '0000-00-00' || strtotime($oldModel->due_date) === false;
$openDateNotSet = empty($oldModel->open_date) || $oldModel->open_date === '0000-00-00' || strtotime($oldModel->open_date) === false;
$closeDateNotSet = empty($oldModel->close_date) || $oldModel->close_date === '0000-00-00' || strtotime($oldModel->close_date) === false;
$model = new Task('migrate');
$model->title = $oldModel->name;
$model->content = $oldModel->description . "\n" . '[from migration]';
$model->contentMarkup = 'text';
$model->companyId = $oldModel->customer_id;
$model->projectId = $oldModel->project_id;
$model->estimateMinute = (int) $oldModel->hours_estimate * 60;
$model->dueDate = $dueDateNotSet ? null : MDate::formatToDb($oldModel->due_date, 'date');
$model->priority = $priority[$oldModel->priority];
$model->openDate = $openDateNotSet ? null : MDate::formatToDb($oldModel->open_date, 'date');
$model->closeDate = $closeDateNotSet ? null : MDate::formatToDb($oldModel->close_date, 'date');
$model->status = $status[$oldModel->task_status];
$model->report = $oldModel->work_report;
$model->reportMarkup = 'text';
$model->hourlyRate = $hourlyRate;
$model->isConfirmed = '1';
$model->confirmationTime = strtotime($oldModel->last);
$model->createTime = strtotime($oldModel->last);
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
// relation between task and consultant
if ($oldModel->leader_id >= 1) {
$user2Task = new User2Task('migrate');
$user2Task->userId = $oldModel->leader_id;
$user2Task->taskId = $model->id;
$user2Task->role = User2Task::CONSULTANT;
if ($user2Task->save()) {
$u++;
}
}
// relation between task and manager
if ($model->projectId >= 1) {
$criteria = new CDbCriteria();
$criteria->order = "`" . User2Project::model()->tableName() . "`.`userPriority` ASC";
$criteria->order .= ",`" . User2Project::model()->tableName() . "`.`id` ASC";
if (($user2Project = User2Project::model()->findByAttributes(array('projectId' => $model->projectId, 'role' => 'manager'), $criteria)) !== null) {
$user2Task = new User2Task('migrate');
$user2Task->userId = $user2Project->userId;
$user2Task->taskId = $model->id;
$user2Task->role = 'manager';
if ($user2Task->save()) {
$m++;
}
}
}
}
$j++;
}
$message .= $i . ' of ' . $j . ' tasks' . ($i === $u ? '' : ' with ' . $u . ' consultant (relations)') . ($i === $m ? '' : ' with ' . $m . ' manager (relations)') . ' have been migrated.<br/>';
}
}
if ($migrate['Time']) {
// time
$mTime = MTime::model()->findAll($findAllCriteria);
if (is_array($mTime)) {
$i = $j = $t = 0;
foreach ($mTime as $oldModel) {
if (($model = Time::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
$taskId = $oldModel->task_id;
if (empty($taskId) && $oldModel->project_id >= 1) {
$criteria = new CDbCriteria();
$criteria->order = "`" . Task::model()->tableName() . "`.`id` ASC";
if (($task = Task::model()->findByAttributes(array('projectId' => $oldModel->project_id), $criteria)) !== null) {
$taskId = $task->id;
} else {
// auto-generate a task
$companyId = 0;
$criteria = new CDbCriteria();
$criteria->order = "`" . Company2Project::model()->tableName() . "`.`companyPriority` ASC";
$criteria->order .= ", `" . Company2Project::model()->tableName() . "`.`id` ASC";
if (($company2Project = Company2Project::model()->findByAttributes(array('projectId' => $oldModel->project_id), $criteria)) !== null) {
$companyId = $company2Project->companyId;
}
$hourlyRate = null;
if (($project = Project::model()->findByPk($oldModel->project_id)) !== null) {
$hourlyRate = $project->hourlyRate;
}
$task = new Task('migrate');
$task->projectId = $oldModel->project_id;
$task->companyId = $companyId;
$task->title = '[Auto Generated]';
$task->status = 'completed';
$task->dueDate = MDate::formatToDb($project === null ? 1234567890 : $project->createTime, 'date');
$task->openDate = MDate::formatToDb($project === null ? 1234567890 : $project->createTime, 'date');
$task->closeDate = MDate::formatToDb($project === null ? 1234567890 : $project->createTime, 'date');
$task->hourlyRate = $hourlyRate;
$task->isConfirmed = 1;
$task->confirmationTime = $project === null ? 1234567890 : $project->createTime;
if ($task->save()) {
$t++;
$taskId = $task->id;
// assigned consultant
if ($oldModel->user_id >= 1) {
$consultant2Task = new User2Task('migrate');
$consultant2Task->userId = $oldModel->user_id;
$consultant2Task->taskId = $task->id;
$consultant2Task->role = User2Task::CONSULTANT;
$consultant2Task->save();
}
// assigned manager
$criteria = new CDbCriteria();
$criteria->order = "`" . User2Project::model()->tableName() . "`.`userPriority` ASC";
$criteria->order .= ", `" . User2Project::model()->tableName() . "`.`id` ASC";
if (($user2Project = User2Project::model()->findByAttributes(array('projectId' => $oldModel->project_id, 'role' => 'manager'), $criteria)) !== null) {
$manager2Task = new User2Task('migrate');
$manager2Task->userId = $user2Project->userId;
$manager2Task->taskId = $task->id;
$manager2Task->role = User2Task::MANAGER;
$manager2Task->save();
}
}
}
}
$managerId = null;
if (!empty($taskId)) {
$criteria = new CDbCriteria();
$criteria->order = "`" . User2Task::model()->tableName() . "`.`userPriority` ASC";
$criteria->order .= ",`" . User2Task::model()->tableName() . "`.`id` ASC";
if (($user2Task = User2Task::model()->findByAttributes(array('taskId' => $taskId, 'role' => 'manager'), $criteria)) !== null) {
$managerId = $user2Task->userId;
}
}
$timeDateNotSet = empty($oldModel->time_date) || $oldModel->time_date === '0000-00-00' || strtotime($oldModel->time_date) === false;
$model = new Time('migrate');
$model->consultantId = $oldModel->user_id;
$model->taskId = $taskId;
$model->spentMinute = (int) $oldModel->hours_spent * 60;
$model->timeDate = $timeDateNotSet ? null : MDate::formatToDb($oldModel->time_date, 'date');
$model->title = $oldModel->note;
$model->content = $oldModel->details . "\n" . '[from migration]';
$model->contentMarkup = 'text';
$model->managerId = $managerId;
$model->billedMinute = (int) $oldModel->hours_billed * 60;
$model->invoiceId = $oldModel->invoice_id;
$model->invoiceAmount = $oldModel->invoice_amount;
$model->isConfirmed = '1';
$model->confirmationTime = strtotime($oldModel->last);
$model->createTime = strtotime($oldModel->last);
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
}
$j++;
}
$message .= $i . ' of ' . $j . ' time records' . ($i === $t ? '' : ' with ' . $t . ' tasks') . ' have been migrated.<br/>';
}
}
if ($migrate['Invoice']) {
// invoice
$mInvoices = MInvoice::model()->findAll($findAllCriteria);
if (is_array($mInvoices)) {
$i = $j = 0;
foreach ($mInvoices as $oldModel) {
if (($model = Invoice::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
$invoiceDateNotSet = empty($oldModel->invoice_date) || $oldModel->invoice_date === '0000-00-00' || strtotime($oldModel->invoice_date) === false;
$startDateNotSet = empty($oldModel->start_date) || $oldModel->start_date === '0000-00-00' || strtotime($oldModel->start_date) === false;
$endDateNotSet = empty($oldModel->end_date) || $oldModel->end_date === '0000-00-00' || strtotime($oldModel->end_date) === false;
$dueDateNotSet = empty($oldModel->due_date) || $oldModel->due_date === '0000-00-00' || strtotime($oldModel->due_date) === false;
$model = new Invoice('migrate');
$model->invoiceDate = $invoiceDateNotSet ? null : MDate::formatToDb($oldModel->invoice_date, 'date');
$model->companyId = $oldModel->customer_id;
$model->billedMinute = (int) $oldModel->hours_billed * 60;
$model->amountTotal = number_format($oldModel->total, 2, '.', '');
$model->startDate = $startDateNotSet ? null : MDate::formatToDb($oldModel->start_date, 'date');
$model->endDate = $endDateNotSet ? null : MDate::formatToDb($oldModel->end_date, 'date');
$model->dueDate = $dueDateNotSet ? null : MDate::formatToDb($oldModel->due_date, 'date');
$model->amountTime = number_format($oldModel->total, 2, '.', '');
$model->amountExpense = 0;
$model->content = '[from migration]';
$model->contentMarkup = 'text';
$model->createTime = $invoiceDateNotSet ? null : strtotime($oldModel->invoice_date);
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
}
$j++;
}
$message .= $i . ' of ' . $j . ' invoices have been migrated.<br/>';
}
}
if ($migrate['Expense']) {
// expense
$mExpenses = MExpense::model()->findAll($findAllCriteria);
if (is_array($mExpenses)) {
$i = $j = 0;
$billToCompany = array('Yes' => '1', 'No' => '0');
foreach ($mExpenses as $oldModel) {
if (($model = Expense::model()->findByPk($oldModel->id)) !== null) {
$model->delete();
}
$expenseDateNotSet = empty($oldModel->expense_date) || $oldModel->expense_date === '0000-00-00' || strtotime($oldModel->expense_date) === false;
$model = new Expense('migrate');
$model->managerId = $oldModel->user_id;
$model->companyId = $oldModel->customer_id;
$model->projectId = $oldModel->project_id;
$model->invoiceId = $oldModel->invoice_id;
$model->expenseDate = $expenseDateNotSet ? null : MDate::formatToDb($oldModel->expense_date, 'date');
$model->amount = $oldModel->amount;
$model->billToCompany = $billToCompany[$oldModel->bill_to_customer];
$model->content = $oldModel->note . "\n" . '[from migration]';
$model->contentMarkup = 'text';
$model->createTime = strtotime($oldModel->last);
$model->id = $oldModel->id;
if ($model->save()) {
$i++;
}
$j++;
}
$message .= $i . ' of ' . $j . ' expenses have been migrated.<br/>';
}
}
// last message line
$message .= 'done';
}
$this->render($this->action->id, array('message' => $message));
}