/**
* Change Case status using select-box
*/
public function actionChangeStatus()
{
// check if user has permissions to changeStatusCases
if (Yii::app()->user->checkAccess('changeStatusCases')) {
// verify is request was made via post ajax
if (Yii::app()->request->isAjaxRequest && isset($_POST)) {
// get Cases object model
$model = $this->loadModel($_REQUEST['id']);
// set new status
$model->status_id = $_POST['changeto'];
// validate and save
if ($model->save()) {
// save log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'CaseStatusChanged', 'log_resourceid' => $model->case_id, 'log_type' => Logs::LOG_UPDATED, 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id, 'project_id' => $model->project_id);
Logs::model()->saveLog($attributes);
// create comment to let then know that some user change the case status
$modelComment = new Comments();
$modelComment->comment_date = date("Y-m-d G:i:s");
$modelComment->comment_text = Status::STATUS_COMMENT . ": " . $model->Status->status_id;
$modelComment->user_id = Yii::app()->user->id;
$modelComment->module_id = Modules::model()->find(array('condition' => 't.module_name = :module_name', 'params' => array(':module_name' => $this->getId())))->module_id;
$modelComment->comment_resourceid = $model->case_id;
$modelComment->save(false);
// prepare email template for each project manager
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$subject = Yii::t('email', 'CaseStatusChange') . " - " . $model->case_name;
//$Users = Users::model()->with('Clients')->findManagersByProject($model->project_id);
$Users = Projects::model()->findAllUsersByProject($model->project_id);
$recipientsList = array();
foreach ($Users as $client) {
$recipientsList[] = array('name' => $client->CompleteName, 'email' => $client->user_email);
}
// load template
$str = $this->renderPartial('//templates/cases/StatusChanged', array('case' => $model, 'user' => Users::model()->findByPk(Yii::app()->user->id), 'urlToCase' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->createUrl('cases/view', array('id' => $model->case_id)), 'typeNews' => $model->status_id == Status::STATUS_ACCEPTED || $model->status_id == Status::STATUS_TOREVIEW ? 'buenas' : 'malas', 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$mailer->pushMail($subject, $str, $recipientsList, Emails::PRIORITY_NORMAL);
$output = Yii::t('cases', 'StatusChanged');
} else {
$output = Yii::t('cases', 'StatusError');
}
echo $output;
Yii::app()->end();
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
public function actionMilestonesPending()
{
$Milestones = Milestones::model()->MilestoneWithPendingTasks();
foreach ($Milestones as $milestone) {
$Tasks = Tasks::model()->findTaskByMilestone($milestone->milestone_id);
$str = CBaseController::renderInternal(Yii::app()->params['templatesPath'] . '/milestones/overdueMilestones.php', array('user' => $milestone->Users->completeName, 'tasks' => $Tasks, 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://localhost/celestic/" . Yii::app()->request->baseUrl), true);
$subject = Yii::t('email', 'overdueMilestone');
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$mailer->pushMail($subject, $str, array('name' => $milestone->Users->CompleteName, 'email' => $milestone->Users->user_email), Emails::PRIORITY_NORMAL);
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
// verify if user has permissions to createDownloads
if (Yii::app()->user->checkAccess('createDownloads')) {
// create object model Documents
$model = new Documents();
// verify _POST['Documents'] exist
if (isset($_POST['Documents'])) {
// set form elements to Documents model attributes
$model->attributes = $_POST['Documents'];
$model->project_id = Yii::app()->user->getState('project_selected');
$model->user_id = Yii::app()->user->id;
// verify file upload exist
if (isset($_FILES['Documents']['name']['image']) && !empty($_FILES['Documents']['name']['image'])) {
// create an instance of uploaded file
$model->image = CUploadedFile::getInstance($model, 'image');
if (!$model->image->getError()) {
// name is formed by date(day+month+year+hour+minutes+seconds+dayofyear+microtime())
$this->tmpFileName = str_replace(" ", "", date('dmYHis-z-') . microtime());
// get the file extension
$extension = $model->image->getExtensionName();
if ($model->image->saveAs(DocumentsController::FOLDERIMAGES . $this->tmpFileName . '.' . $extension)) {
// set other attributes
$model->document_path = DocumentsController::FOLDERIMAGES . $this->tmpFileName . '.' . $extension;
$model->document_revision = '1';
$model->document_uploadDate = date("Y-m-d");
$model->document_type = $model->image->getType();
$model->document_baseRevision = date('dmYHis');
$model->user_id = Yii::app()->user->id;
// create email object
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$subject = Yii::t('email', 'newDocumentUpload') . " - " . $model->document_name;
// find users managers to send email
$Users = Projects::model()->findManagersByProject($model->project_id);
// create array of users destinations
$recipientsList = array();
foreach ($Users as $client) {
$recipientsList[] = array('name' => $client->CompleteName, 'email' => $client->user_email);
}
// set layout then send
$str = $this->renderPartial('//templates/documents/newUpload', array('document' => $model, 'urlToDocument' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->createUrl('documents/view', array('id' => $model->document_id)), 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$mailer->pushMail($subject, $str, $recipientsList, Emails::PRIORITY_NORMAL);
}
} else {
$model->addError('image', $model->image->getError());
}
}
// validate and save
if ($model->save()) {
// save log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'DocumentCreated', 'log_resourceid' => $model->primaryKey, 'log_type' => 'created', 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id, 'project_id' => $model->project_id);
Logs::model()->saveLog($attributes);
$this->redirect(array('view', 'id' => $model->document_id));
}
}
// response with create view
$this->render('create', array('model' => $model));
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
/**
* Creates a new model.
*/
public function actionCreate()
{
// create Comments Object
$model = new Comments();
// if Comments form exist
if (isset($_POST['Comments'])) {
// set form elements to Comments model attributes
$model->attributes = $_POST['Comments'];
$module = Modules::model()->find(array('condition' => 't.module_name = :module_name', 'params' => array(':module_name' => $model->module_id)));
// set module_id finded to model
$model->module_id = $module->module_id;
$project = Yii::app()->user->getState('project_selected');
$model->project_id = $project;
// validate and save
if ($model->save()) {
// create an instance of file uploaded
$image = CUploadedFile::getInstancesByName('Comment');
// if file upload exist
if (count($image > 0)) {
// for each file uploaded
for ($i = 0; $i < count($image); $i++) {
// create an Document object
$modeldocs = new Documents();
$modeldocs->image = $image[$i];
if (!$modeldocs->image->getError()) {
// name is formed by date(day+month+year+hour+minutes+seconds+dayofyear+microtime())
$this->tmpFileName = str_replace(" ", "", date('dmYHis-z-') . microtime());
// set the extension file uploaded
$extension = $modeldocs->image->getExtensionName();
// if no error saving file
if ($modeldocs->image->saveAs(self::FOLDERIMAGES . $this->tmpFileName . '.' . $extension)) {
$modeldocs->project_id = $project;
$modeldocs->document_name = substr($modeldocs->image->getName(), 0, 30);
$modeldocs->document_description = $model->comment_text;
$modeldocs->document_path = self::FOLDERIMAGES . $this->tmpFileName . '.' . $extension;
$modeldocs->document_revision = '1';
$modeldocs->document_uploadDate = date("Y-m-d");
$modeldocs->document_type = $modeldocs->image->getType();
$modeldocs->document_baseRevision = date('dmYHis');
$modeldocs->user_id = Yii::app()->user->id;
$modeldocs->comment_id = $model->primaryKey;
// save file uploaded as document
if ($modeldocs->save()) {
Yii::app()->user->setFlash('CommentMessageSuccess', $modeldocs->image->getName() . " " . Yii::t('comments', 'UploadOk'));
} else {
Yii::app()->user->setFlash('CommentMessage', $modeldocs->getErrors());
}
} else {
Yii::app()->user->setFlash('CommentMessage', $modeldocs->image->getName() . " " . Yii::t('comments', 'UploadError'));
}
} else {
Yii::app()->user->setFlash('CommentMessage', $modeldocs->image->error . " " . Yii::t('comments', 'UploadCheckErrors'));
}
}
}
// save log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'CommentPosted', 'log_resourceid' => $model->comment_resourceid, 'log_type' => Logs::LOG_COMMENTED, 'log_commentid' => $model->primaryKey, 'user_id' => Yii::app()->user->id, 'module_id' => $module->module_name, 'project_id' => $project);
Logs::model()->saveLog($attributes);
// find project managers to sent comment via mail
$recipientsList = array();
$ProjectManagers = Projects::model()->findManagersByProject($project);
$managersArray = array();
foreach ($ProjectManagers as $manager) {
$managersArray['email'] = $manager->user_email;
$managersArray['name'] = $manager->CompleteName;
array_push($recipientsList, $managersArray);
}
// find task owners to send comment via mail
if ($module->module_name == 'tasks') {
$collaborators = Projects::model()->findAllUsersByProject($project);
$ColaboratorsArray = array();
foreach ($collaborators as $colaborator) {
$ColaboratorsArray['email'] = $colaborator->user_email;
$ColaboratorsArray['name'] = $colaborator->CompleteName;
// avoid to repeat email address
if (!in_array($ColaboratorsArray, $recipientsList)) {
array_push($recipientsList, $ColaboratorsArray);
}
}
}
// finding resource title
switch ($module->module_name) {
case "budgets":
$resourceModelTitle = Budgets::model()->findByPk($model->comment_resourceid)->budget_title;
break;
case "invoices":
$resourceModelTitle = Invoices::model()->findByPk($model->comment_resourceid)->invoice_number;
break;
case "expenses":
$resourceModelTitle = Expenses::model()->findByPk($model->comment_resourceid)->expense_name;
break;
case "documents":
$resourceModelTitle = Documents::model()->findByPk($model->comment_resourceid)->document_name;
break;
case "milestones":
$resourceModelTitle = Milestones::model()->findByPk($model->comment_resourceid)->milestone_title;
break;
case "cases":
$resourceModelTitle = Cases::model()->findByPk($model->comment_resourceid)->case_name;
break;
case "tasks":
$resourceModelTitle = Tasks::model()->findByPk($model->comment_resourceid)->task_name;
break;
default:
$resourceModelTitle = "{empty}";
break;
}
// get project information
$project = Projects::model()->findByPk($project);
// prepare template to send via email
$str = $this->renderPartial('//templates/comments/created', array('model' => $model, 'projectName' => $project->project_name, 'userposted' => Yii::app()->user->CompleteName, 'resourceTitle' => $resourceModelTitle, 'moduleName' => Yii::t('modules', $module->module_name), 'applicationName' => Yii::app()->name, 'applicationUrl' => Yii::app()->createAbsoluteUrl($module->module_name . '/view', array('id' => $model->comment_resourceid))), true);
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$subject = Yii::t('email', 'CommentPosted') . " - " . $project->project_name . " - " . Yii::t('modules', $module->module_name);
$mailer->pushMail($subject, $str, $recipientsList, Emails::PRIORITY_NORMAL);
} else {
Yii::app()->user->setFlash('CommentMessage', Yii::t('comments', 'RequiredComment'));
}
}
$this->redirect(Yii::app()->createUrl($_GET['module'] . '/' . $_GET['action'], array('id' => $_GET['id'], '#' => 'comment-' . $model->primaryKey)));
}
public function actionRecover()
{
// create ForgottenPasswordForm object
$model = new ForgottenPasswordForm();
// verify if ForgottenPasswordForm was used
if (isset($_POST['ForgottenPasswordForm'])) {
$model->attributes = $_POST['ForgottenPasswordForm'];
// validate model
if ($model->validate()) {
// criteria object used to find all user data information
$userCriteria = new CDbCriteria();
$userCriteria->condition = "user_email = :user_email";
$userCriteria->params = array(':user_email' => $model->user_email);
$CountUser = Users::model()->count($userCriteria);
$transaction = Yii::app()->db->beginTransaction();
if ($CountUser > 0) {
$user = Users::model()->find($userCriteria);
// -- Password Generator
$vowels = 'aeiou';
$consonants = 'bcdfghjklmnpqrstvwxyz';
$password = '';
$alt = time() % 2;
for ($i = 0; $i < 10; $i++) {
if ($alt == 1) {
$password .= $consonants[rand() % strlen($consonants)];
$alt = 0;
} else {
$password .= $vowels[rand() % strlen($vowels)];
$alt = 1;
}
}
$user->user_password = md5($password);
if ($user->save(false)) {
$str = $this->renderPartial('//templates/users/PasswordChanged', array('userRequest' => $user->CompleteName, 'user_email' => $user->user_email, 'user_password' => $password, 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$subject = Yii::t('email', 'PasswordReset');
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$mailer->Ready($subject, $str, array('name' => $user->CompleteName, 'email' => $user->user_email), Emails::PRIORITY_NORMAL);
Yii::app()->user->setFlash('PasswordSuccessChanged', Yii::t('site', 'PasswordSuccessChanged'));
$this->refresh();
} else {
throw new CException('Error #000001');
}
} else {
throw new CException(Yii::t('site', 'EmailNotExist'));
}
}
}
$this->layout = 'login';
$this->render('recover', array('model' => $model));
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
if (Yii::app()->user->checkAccess('createTasks')) {
$model = new Tasks();
$Milestones = Milestones::model()->with('Projects.Company.Cusers')->together()->findAll(array('condition' => 'Cusers.user_id = :user_id AND t.project_id = :project_id AND Projects.project_endDate > CURDATE()', 'params' => array(':user_id' => Yii::app()->user->id, ':project_id' => Yii::app()->user->getState('project_selected'))));
$Cases = Cases::model()->with('Projects.Company.Cusers')->together()->findAll(array('condition' => 'Cusers.user_id = :user_id AND t.project_id = :project_id', 'params' => array(':user_id' => Yii::app()->user->id, ':project_id' => Yii::app()->user->getState('project_selected'))));
if (isset($_POST['Tasks'])) {
$model->attributes = $_POST['Tasks'];
$model->user_id = Yii::app()->user->id;
$model->status_id = Status::STATUS_PENDING;
$model->project_id = Yii::app()->user->getState('project_selected');
$model->task_startDate = date("Y-m-d");
//new CDbExpression('NOW()');
if ($model->save()) {
// Guardar log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'TaskCreated', 'log_resourceid' => $model->primaryKey, 'log_type' => 'created', 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id, 'project_id' => $model->project_id);
Logs::model()->saveLog($attributes);
// avisar a los participantes del proyecto que una nueva tarea se ha agregado
$Users = Projects::model()->findAllUsersByProject($model->project_id);
$recipientsList = array();
foreach ($Users as $user) {
$recipientsList[] = array('name' => $user->CompleteName, 'email' => $user->user_email);
}
$subject = Yii::t('email', 'TaskStatusChanged') . " - " . $model->task_name;
$str = $this->renderPartial('//templates/tasks/statusChanged', array('task' => $model, 'username' => Yii::app()->user->CompleteName, 'task_url' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->createUrl('tasks/view', array('id' => $model->task_id)), 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$mailer->pushMail($subject, $str, $recipientsList, Emails::PRIORITY_NORMAL);
$this->redirect(array('view', 'id' => $model->task_id));
}
}
$this->render('create', array('model' => $model, 'status' => Status::model()->findAll(), 'types' => TaskTypes::model()->findAll(), 'stages' => TaskStages::model()->findAll(), 'milestones' => $Milestones, 'cases' => $Cases, 'allowEdit' => true));
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
if (Yii::app()->user->checkAccess('createUsers')) {
$model = new Users();
$address = new Address();
if (isset($_POST['Users']) && isset($_POST['Address'])) {
$model->attributes = $_POST['Users'];
$address->attributes = $_POST['Address'];
$model->account_id = Users::model()->findByPk(Yii::app()->user->id)->account_id;
$valid = $address->validate();
$valid = $model->validate() && $valid;
if ($valid) {
$address->save(false);
$model->address_id = $address->primaryKey;
$passBeforeMD5 = $model->user_password;
$model->user_password = md5($model->user_password);
if ($model->save(false)) {
// Guardar log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'UserCreated', 'log_resourceid' => $model->primaryKey, 'log_type' => 'created', 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id);
Logs::model()->saveLog($attributes);
$str = $this->renderPartial('//templates/users/invitation', array('userCreateInvitation' => Yii::app()->user->CompleteName, 'user_email' => $model->user_email, 'user_password' => $passBeforeMD5, 'userInvited' => $model->CompleteName, 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$subject = Yii::t('email', 'UserInvitation');
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
//$mailer->Ready($subject, $str, array('email'=>$model->user_email, 'name'=>$model->CompleteName));
$mailer->pushMail($subject, $str, array('email' => $model->user_email, 'name' => $model->CompleteName), Emails::PRIORITY_NORMAL);
$this->redirect(array('view', 'id' => $model->user_id));
}
}
}
$this->render('create', array('model' => $model, 'allowEdit' => true, 'userManager' => true, 'address' => $address));
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
private function sendEmailAlert($attributes)
{
$recipients = Users::model()->with('Companies.Projects')->findAll(array('condition' => 'Projects.project_id = ' . $attributes['project_id'], 'together' => true));
$recipientsList = array();
foreach ($recipients as $user) {
array_push($recipientsList, $user->user_email);
}
$str;
Yii::import('application.extensions.miniTemplator.miniTemplator');
$t = new miniTemplator();
$t->readTemplateFromFile("templates/ActivityCreation.tpl");
$t->setVariable("applicationName", Yii::app()->name);
$t->setVariable("project", Projects::model()->findByPk($attributes['project_id'])->project_name);
$t->setVariable("logActivity", $attributes['log_activity']);
$t->setVariable("activityCreatedByUser", Users::model()->findByPk($attributes['user_id'])->CompleteName);
$t->setVariable("date", $attributes['log_date']);
$t->setVariable("applicationUrl", "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl);
$t->generateOutputToString($str);
$subject = "Activity Notification";
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$mailer->Ready($subject, $str, $recipientsList);
}
/**
* Creates a new model.
* @return create view
*/
public function actionCreate()
{
// check if user has permissions to createClients
if (Yii::app()->user->checkAccess('createClients')) {
// create Users object model
$modelUsers = new Users();
// create Address object model
$address = new Address();
// if Users and Address form exist and was sent
if (isset($_POST['Users']) && isset($_POST['Address'])) {
// set form elements to Users model attributes
$modelUsers->attributes = $_POST['Users'];
// set form elements to Address model attributes
$address->attributes = $_POST['Address'];
$modelUsers->user_admin = 0;
$modelUsers->account_id = Yii::app()->user->Accountid;
// validate both models
$valid = $address->validate();
$valid = $modelUsers->validate() && $valid;
if ($valid) {
// save address
$address->save(false);
$modelUsers->address_id = $address->primaryKey;
// temporary variable with user password
$passBeforeMD5 = $modelUsers->user_password;
// hashed user password
$modelUsers->user_password = md5($modelUsers->user_password);
// save user
if ($modelUsers->save(false)) {
// create clients object
$model = new Clients();
$model->user_id = $modelUsers->user_id;
// validate and save
if ($model->save()) {
// save log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'ClientCreated', 'log_resourceid' => $model->primaryKey, 'log_type' => Logs::LOG_CREATED, 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id);
Logs::model()->saveLog($attributes);
// prepare to send email template to new user
$str = $this->renderPartial('//templates/users/invitation', array('userCreateInvitation' => Yii::app()->user->CompleteName, 'user_email' => $modelUsers->user_email, 'user_password' => $passBeforeMD5, 'userInvited' => $modelUsers->CompleteName, 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$subject = Yii::t('email', 'UserInvitation');
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$mailer->pushMail($subject, $str, array('email' => $modelUsers->user_email, 'name' => $modelUsers->CompleteName), Emails::PRIORITY_NORMAL);
// to prevent F5 keypress, redirect to view detail page
$this->redirect(array('view', 'id' => $model->client_id));
}
}
}
}
$this->render('create', array('model' => $modelUsers, 'address' => $address));
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
/**
* Add relation between user and company
*/
public function actionAddUsers()
{
// check if user has permissions to addusersCompanies
if (Yii::app()->user->checkAccess('addusersCompanies')) {
// account_id used to find all users in my account
$account_id = Users::model()->findByPk(Yii::app()->user->id)->account_id;
// verify params request
if (Yii::app()->request->isAjaxRequest && isset($_POST['action'])) {
// users and clients filter
if ($_POST['action'] == 'useradd') {
$availableUsers = Users::model()->findUsersByAccount($account_id, $_GET['owner']);
} elseif ($_POST['action'] == 'clientadd') {
$availableUsers = Users::model()->findClientsByAccount($account_id, $_GET['owner']);
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
$html = $this->renderPartial('_dropdownUsersList', array('availableUsers' => $availableUsers), true);
echo $html;
Yii::app()->end();
}
if (Yii::app()->request->isAjaxRequest) {
// create object model for CompaniesHasUsers
$model = new CompaniesHasUsers();
if (Yii::app()->request->isPostRequest) {
// set params to CompaniesHasUsers attributes
$_POST['CompaniesHasUsers'] = array('user_id' => $_POST['icls'], 'company_id' => $_POST['owner']);
$model->attributes = $_POST['CompaniesHasUsers'];
// perform validation
$error = CActiveForm::validate($model, array('user_id', 'company_id'));
if ($error == '[]') {
// output json array
$result = array();
// save new user - company relation
if ($model->save()) {
$result['hasreg'] = isset($_POST['iclstyp']) && (int) $_POST['iclstyp'] == 0 ? (bool) CompaniesHasUsers::model()->HasUsersAvailablesToAdd(Yii::app()->user->Accountid, $model->company_id) : (bool) CompaniesHasUsers::model()->HasClientsAvailablesToAdd(Yii::app()->user->Accountid, $model->company_id);
$result['saved'] = true;
if (isset($_GET['action']) && !empty($_GET['action']) && $_GET['action'] == 'useradd') {
$availableUsers = Users::model()->findUsersByAccount(Yii::app()->user->Accountid, $model->company_id);
} else {
$availableUsers = Users::model()->findClientsByAccount(Yii::app()->user->Accountid, $model->company_id);
}
$html = $this->renderPartial('_dropdownUsersList', array('availableUsers' => $availableUsers), true);
$result['html'] = $html;
$userSelected = Users::model()->findByPk($model->user_id);
// template to send mail
$str = $this->renderPartial('//templates/companies/useradd', array('userCreateInvitation' => Yii::app()->user->CompleteName, 'userInvited' => $userSelected->CompleteName, 'companyName' => $model->Company->company_name, 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$subject = Yii::t('email', 'UserAddtoCompany');
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$mailer->pushMail($subject, $str, array('email' => $userSelected->user_email, 'name' => $userSelected->CompleteName), Emails::PRIORITY_NORMAL);
} else {
$result['hasreg'] = isset($_POST['iclstyp']) && (int) $_POST['iclstyp'] == 0 ? (bool) CompaniesHasUsers::model()->HasUsersAvailablesToAdd(Yii::app()->user->Accountid, $model->company_id) : (bool) CompaniesHasUsers::model()->HasClientsAvailablesToAdd(Yii::app()->user->Accountid, $model->company_id);
$result['saved'] = false;
}
echo CJSON::encode($result);
Yii::app()->end();
} else {
echo $error;
Yii::app()->end();
}
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
/**
* Create client user as project participant
*/
public function actionAddClient()
{
// check if user has permissions to updateProjects
if (Yii::app()->user->checkAccess('updateProjects') && Yii::app()->user->getIsManager()) {
// verify params request
if (Yii::app()->request->isAjaxRequest) {
// verify params request
if (Yii::app()->request->isPostRequest) {
// create object to save relation between user and project as manager
$model = new ProjectsHasUsers();
$model->user_id = $_POST['uid'];
$model->project_id = (int) Yii::app()->user->getState('project_selected');
if ($model->save()) {
// find data for project and user to send an email
$userSelected = Users::model()->findByPk($model->user_id);
$project = Projects::model()->findByPk($model->project_id);
// prepares to send email to user added to PM
$str = $this->renderPartial('//templates/projects/useradd', array('userCreateInvitation' => Yii::app()->user->CompleteName, 'userInvited' => $userSelected->CompleteName, 'projectName' => $project->project_name, 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$subject = Yii::t('email', 'UserAddtoProject');
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$mailer->pushMail($subject, $str, array('email' => $userSelected->user_email, 'name' => $userSelected->CompleteName), Emails::PRIORITY_NORMAL);
// save log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'ClientAssigned', 'log_resourceid' => $model->project_id, 'log_type' => Logs::LOG_ASSIGNED, 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id, 'project_id' => $model->project_id);
Logs::model()->saveLog($attributes);
$managers = Projects::model()->findManagersByProject((int) Yii::app()->user->getState('project_selected'));
$managerList = array();
if (count($managers) > 0) {
foreach ($managers as $users) {
array_push($managerList, $users->user_id);
}
} else {
array_push($managerList, -1);
}
$ManagersAvailables = Users::model()->findAll(array('condition' => 'Companies.company_id = :company_id AND t.user_id NOT IN (' . implode(",", $managerList) . ')', 'params' => array(':company_id' => Projects::model()->findByPk(Yii::app()->user->getState('project_selected'))->company_id), 'together' => true, 'order' => 't.user_name ASC', 'with' => array('Companies')));
$availablesClients = Users::model()->filterManagers($managerList)->findClientsByProject(Yii::app()->user->getState('project_selected'));
$str = $this->renderPartial('_dropdownUsersList', array('availablesManagers' => $availablesClients), true);
$strManager = $this->renderPartial('_dropdownUsersList', array('availablesManagers' => $ManagersAvailables), true);
// output is a json denotation result
$output = array('saved' => true, 'html' => $str, 'htmlManager' => $strManager, 'hasreg' => count($availablesClients) > 0 ? true : false);
}
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
echo CJSON::encode($output);
Yii::app()->end();
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
/**
* Creates a new model.
* @return create view
*/
public function actionCreate()
{
// check if user has permissions to createInvoices
if (Yii::app()->user->checkAccess('createInvoices')) {
// create Invoices object model
$model = new Invoices();
// find all budgets relateds to current project
$Budgets = Budgets::model()->findBudgetsByProjects(Yii::app()->user->getState('project_selected'));
// if Invoices form exist
if (isset($_POST['Invoices'])) {
// set form elements to Invoices model attributes
$model->attributes = $_POST['Invoices'];
$model->project_id = Yii::app()->user->getState('project_selected');
$model->status_id = Status::STATUS_PENDING;
// validate and save
if ($model->save()) {
// save log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'InvoiceCreated', 'log_resourceid' => $model->primaryKey, 'log_type' => Logs::LOG_CREATED, 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id, 'project_id' => $model->project_id);
Logs::model()->saveLog($attributes);
$project = Projects::model()->findByPk(Yii::app()->user->getState('project_selected'));
// send an email to projects managers only
$recipientsList = array();
$ProjectManagers = Projects::model()->findManagersByProject($project->project_id);
$managersArray = array();
foreach ($ProjectManagers as $manager) {
$managersArray['email'] = $manager->user_email;
$managersArray['name'] = $manager->CompleteName;
array_push($recipientsList, $managersArray);
}
// prepare template to send via email
$str = $this->renderPartial('//templates/invoices/activity', array('model' => $model, 'projectName' => $project->project_name, 'userposted' => Yii::app()->user->CompleteName, 'applicationName' => Yii::app()->name, 'applicationUrl' => Yii::app()->createAbsoluteUrl('invoices/view', array('id' => $model->primaryKey))), true);
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$subject = Yii::t('email', 'InvoiceCreated') . " - " . $project->project_name;
$mailer->pushMail($subject, $str, $recipientsList, Emails::PRIORITY_NORMAL);
// to prevent F5 keypress, redirect to create page
$this->redirect(array('view', 'id' => $model->invoice_id));
}
}
$this->render('create', array('invoice' => $model, 'lastused' => Invoices::model()->getLastUsed(), 'budgets' => $Budgets));
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}
/**
* Creates a new model.
* @return create view
*/
public function actionCreate()
{
// check if user has permissions to createMilestones
if (Yii::app()->user->checkAccess('createMilestones')) {
// create Milestones object model
$model = new Milestones();
// find all project managers
$Users = Projects::model()->findManagersByProject(Yii::app()->user->getState('project_selected'));
// if Milestones form exist
if (isset($_POST['Milestones'])) {
// set form elements to Milestones model attributes
$model->attributes = $_POST['Milestones'];
$model->project_id = Yii::app()->user->getState('project_selected');
// validate milestone model
if ($model->validate()) {
// find milestones dates
$milestone_startdate = date("Ymd", strtotime($model->milestone_startdate));
$milestone_duedate = date("Ymd", strtotime($model->milestone_duedate));
// get project data
$project = Projects::model()->findByPk($model->project_id);
// find project dates
$project_startDate = date("Ymd", strtotime($project->project_startDate));
$project_endDate = date("Ymd", strtotime($project->project_endDate));
// If milestone dates are not within project dates ERROR!!
if ($milestone_startdate >= $project_startDate && $milestone_startdate <= $project_endDate) {
if ($milestone_duedate <= $project_endDate && $milestone_duedate >= $project_startDate) {
// validate and save
if ($model->save()) {
// save log
$attributes = array('log_date' => date("Y-m-d G:i:s"), 'log_activity' => 'MilestoneCreated', 'log_resourceid' => $model->primaryKey, 'log_type' => Logs::LOG_CREATED, 'user_id' => Yii::app()->user->id, 'module_id' => Yii::app()->controller->id, 'project_id' => $model->project_id);
Logs::model()->saveLog($attributes);
// notify to user that has a milestone to attend
Yii::import('application.extensions.phpMailer.yiiPhpMailer');
$mailer = new yiiPhpMailer();
$subject = Yii::t('email', 'MilestoneAssigned') . " :: " . $model->milestone_title;
// user you will be notified
$User = Users::model()->findByPk($model->user_id);
$recipientsList = array('name' => $User->CompleteName, 'email' => $User->user_email);
// render template
$str = $this->renderPartial('//templates/milestones/assigned', array('milestone' => $model, 'urlToMilestone' => Yii::app()->createAbsoluteUrl('milestones/view', array('id' => $model->milestone_id)), 'applicationName' => Yii::app()->name, 'applicationUrl' => "http://" . $_SERVER['SERVER_NAME'] . Yii::app()->request->baseUrl), true);
$mailer->pushMail($subject, $str, $recipientsList, Emails::PRIORITY_NORMAL);
// to prevent F5 keypress, redirect to create page
$this->redirect(array('view', 'id' => $model->milestone_id));
}
} else {
$model->addError('milestone_duedate', Yii::t('milestones', 'DueDateError'));
}
} else {
$model->addError('milestone_startdate', Yii::t('milestones', 'StartDateError'));
}
}
}
$this->render('create', array('model' => $model, 'users' => $Users));
} else {
throw new CHttpException(403, Yii::t('site', '403_Error'));
}
}