public function actionIndex() { $model = new UserReports(); $reports = $model->getByDate(3, '2012-01-01', '2018-01-01'); $data = new CArrayDataProvider($reports, array('id' => 'id', 'sort' => array('attributes' => array('city', 'phone')), 'pagination' => array('pageSize' => 1))); $this->render('index', array('dataProvider' => $data)); }
public function actionSaveReport() { $model = new UserReports(); $model->user_id = (int) Yii::app()->user->id; $model->client_id = 0; $model->action = 1; $model->comment = $_POST['comment']; $model->date = date('Y-m-d'); $model->save(); $this->render('index'); Yii::app()->user->setFlash('success', "Запись добавлена в отчет"); Yii::app()->clientScript->registerScript('myHideEffect', '$(".info").animate({opacity: 1.0}, 30).fadeOut("slow");', CClientScript::POS_READY); }
public function actionSaveSpecOrders() { $comment = $_POST['comment']; if (empty($comment)) { echo 'Заполните коментарий'; return false; } $model = new UserReports(); $model->user_id = (int) Yii::app()->user->id; $model->client_id = 0; $model->action = 5; $model->comment = $comment; $model->date = date('Y-m-d'); $r = $model->save(); if ($r == true) { echo 'Запись успешно добавлена в отчет'; } else { echo 'Ошибка в сохранени'; } }
public function actionRenPart($user_id, $start, $stop) { $model = new UserReports(); $reports = $model->getByDate($user_id, $start, $stop); var_dump($reports); die; if (count($reports) != 0) { $statisic = array('Совершено звонков' => 0, 'Проведено встречь' => 0, 'Заключено договоров' => 0, 'Иные действия' => 0, 'Особые поручения' => 0, 'Отправил mail' => 0); foreach ($reports as $report) { if ($report['action'] == 1) { $statisic['Совершено звонков'] = $statisic['Совершено звонков'] + 1; } if ($report['action'] == 2) { $statisic['Проведено встречь'] = $statisic['Проведено встречь'] + 1; } if ($report['action'] == 3) { $statisic['Заключено договоров'] = $statisic['Заключено договоров'] + 1; } if ($report['action'] == 4) { $statisic['Иные действия'] = $statisic['Иные действия'] + 1; } if ($report['action'] == 5) { $statisic['Особые поручения'] = $statisic['Особые поручения'] + 1; } if ($report['action'] == 6) { $statisic['Отправил mail'] = $statisic['Отправил mail'] + 1; } } arsort($statisic); $maxIs100 = max($statisic); $one_procent = 100 / $maxIs100; foreach ($statisic as $key => $sta) { $new_static[$key] = array($sta, ceil($one_procent * $sta)); } $data = new CArrayDataProvider($reports, array('pagination' => array('pageSize' => 999))); $this->renderPartial('result', array('dataProvider' => $data, 'statisic' => $new_static, 'maxIs100' => $maxIs100), FALSE, true); } else { $this->renderPartial('ss'); } }
public function executeListing(sfWebRequest $request) { if (!isset($this->reports_id)) { $this->reports_id = false; } $q = Doctrine_Core::getTable('Tasks')->createQuery('t')->leftJoin('t.TasksPriority tp')->leftJoin('t.TasksStatus ts')->leftJoin('t.TasksLabels tl')->leftJoin('t.TasksTypes tt')->leftJoin('t.TasksGroups tg')->leftJoin('t.ProjectsPhases pp')->leftJoin('t.Versions v')->leftJoin('t.Projects p')->leftJoin('t.Users'); if ($request->hasParameter('projects_id')) { $q->addWhere('projects_id=?', $request->getParameter('projects_id')); if (Users::hasAccess('view_own', 'tasks', $this->getUser(), $request->getParameter('projects_id'))) { $q->addWhere("find_in_set('" . $this->getUser()->getAttribute('id') . "',t.assigned_to) or t.created_by='" . $this->getUser()->getAttribute('id') . "'"); } } else { if (Users::hasAccess('view_own', 'projects', $this->getUser())) { $q->addWhere("find_in_set('" . $this->getUser()->getAttribute('id') . "',team) or p.created_by='" . $this->getUser()->getAttribute('id') . "'"); } if (Users::hasAccess('view_own', 'tasks', $this->getUser())) { $q->addWhere("find_in_set('" . $this->getUser()->getAttribute('id') . "',t.assigned_to) or t.created_by='" . $this->getUser()->getAttribute('id') . "'"); } } if ($this->reports_id > 0) { $q = UserReports::addFiltersToQuery($q, $this->reports_id, $this->getUser()->getAttribute('id')); } elseif ($request->hasParameter('search')) { $q = app::addSearchQuery($q, $request->getParameter('search'), 'TasksComments', 't', $request->getParameter('search_by_extrafields')); $q = app::addListingOrder($q, 'tasks', $this->getUser()); } else { $q = Tasks::addFiltersToQuery($q, $this->getUser()->getAttribute('tasks_filter' . ((int) $request->getParameter('projects_id') > 0 ? $request->getParameter('projects_id') : ''))); $q = app::addListingOrder($q, 'tasks', $this->getUser(), (int) $request->getParameter('projects_id')); } $this->pager = false; if (sfConfig::get('app_rows_limit') > 0) { $this->pager = new sfDoctrinePager('Tasks', sfConfig::get('app_rows_limit')); $this->pager->setQuery($q); $this->pager->setPage($request->getParameter('page', 1)); $this->pager->init(); } $this->tasks_list = $q->fetchArray(); if (isset($this->is_dashboard)) { $this->url_params = 'redirect_to=dashboard'; $this->display_insert_button = true; } elseif ($this->reports_id > 0) { $this->url_params = 'redirect_to=userReports' . $this->reports_id; $this->display_insert_button = true; } else { $this->url_params = 'redirect_to=tasksList'; if ($request->hasParameter('projects_id')) { $this->url_params = 'projects_id=' . $request->getParameter('projects_id'); } $this->display_insert_button = true; } $this->tlId = rand(1111111, 9999999); $this->users_schema = Users::getSchema(); }
public function actionSaveCall() { $user = User::model()->find('id=:id', array(':id' => Yii::app()->user->id)); $user_name = $user['first_name'] . ' ' . $user['last_name']; $id = $_POST['id']; $comment = $_POST['comment']; $post = Carrier::model()->findByPk($id); $post->Comment = $comment . '( ' . $user_name . ')'; $post->Last_Activity_Date = date('Y-m-d'); $post->save(); $reports = new UserReports(); $reports->client_id = (int) $id; $reports->user_id = (int) Yii::app()->user->id; $reports->action = 1; $reports->comment = $comment; $reports->date = date('Y-m-d'); $reports->save(); $model = new Carrier('search'); $model->unsetAttributes(); // clear any default values if (isset($_GET['Carrier'])) { $model->attributes = $_GET['Carrier']; } $this->render('admin', array('model' => $model)); }
public function actionSetReport() { $id = $_POST['id']; $comment = $_POST['comment']; if (empty($comment)) { echo 'Комментарий не может быть пустым'; return; } $act = $_POST['action']; if ($act == 'button_call') { $action = 1; } elseif ($act == 'button_mail') { $action = 6; } elseif ($act == 'button_meet') { $action = 2; } elseif ($act == 'button_agreement') { $action = 3; } elseif ($act == 'button_other') { $action = 4; } $model = new UserReports(); $model->client_id = (int) $id; $model->user_id = (int) Yii::app()->user->id; $model->action = (int) $action; $model->comment = $comment; $model->date = date('Y-m-d'); $r = $model->save(); if ($r == true) { echo 'Запись успешно добавлена в отчет'; } else { echo 'Ошибка в сохранени'; } }
public function actionCreateDirection() { $Directory = new Direction(); $Directory->date = $_POST['date']; $Directory->comment = $_POST['comment']; $Directory->cost = $_POST['cost']; $Directory->client = $_POST['client_name']; $Directory->Shipping = $_POST['route_name']; $Directory->carrier = $_POST['carrier_name']; $Directory->client_id = $_POST['client_id']; $Directory->carrier_id = $_POST['carrier_id']; $Directory->shipping_id = $_POST['route_id']; $Directory->manager_id = Yii::app()->user->id; $Directory->save(); if ($Directory->save()) { $model = new UserReports(); $model->user_id = (int) Yii::app()->user->id; $model->client_id = $_POST['client_id']; $model->action = 3; $model->comment = $_POST['comment']; $model->date = $_POST['date']; $model->save(); } $this->redirect(array('view', 'id' => $Directory->id)); }
public static function saveTasksFilter($request, $filters, $sf_user, $filter_type = 'filter') { $report_type = Tasks::getReportType($request, $filter_type); if ($request->getParameter('update_user_filter') > 0) { $r = Doctrine_Core::getTable('UserReports')->createQuery()->addWhere('id=?', $request->getParameter('update_user_filter'))->addWhere('users_id=?', $sf_user->getAttribute('id'))->addWhere('report_type=?', $report_type)->fetchOne(); if ($r) { $r->setName($request->getParameter('name')); $r->setIsDefault($request->getParameter('is_default')); } else { return false; } } else { $r = new UserReports(); $r->setName($request->getParameter('name')); $r->setUsersId($sf_user->getAttribute('id')); $r->setReportType($report_type); $r->setIsDefault($request->getParameter('is_default')); } if (!$request->hasParameter('update_user_filter') or $request->hasParameter('update_user_filter') and $request->hasParameter('update_values')) { foreach ($filters as $table => $fstr) { switch ($table) { case 'TasksPriority': $r->setTasksPriorityId($fstr); break; case 'TasksStatus': $r->setTasksStatusId($fstr); break; case 'TasksTypes': $r->setTasksTypeId($fstr); break; case 'TasksLabels': $r->setTasksLabelId($fstr); break; case 'TasksGroups': $r->setTasksGroupsId($fstr); break; case 'Versions': $r->setVersionsId($fstr); break; case 'ProjectsPhases': $r->setProjectsPhasesId($fstr); break; case 'TasksAssignedTo': $r->setAssignedTo($fstr); break; case 'TasksCreatedBy': $r->setCreatedBy($fstr); break; case 'Projects': $r->setProjectsId($fstr); break; case 'ProjectsPriority': $r->setProjectsPriorityId($fstr); break; case 'ProjectsStatus': $r->setProjectsStatusId($fstr); break; case 'ProjectsTypes': $r->setProjectsTypeId($fstr); break; case 'ProjectsGroups': $r->setProjectsGroupsId($fstr); break; } } } $r->save(); if ($r->getIsDefault() == 1) { Doctrine_Query::create()->update('UserReports')->set('is_default', 0)->addWhere('id != ?', $r->getId())->addWhere('report_type=?', $report_type)->execute(); } }