コード例 #1
0
ファイル: TestController.php プロジェクト: VitaliyMinenko/CRM
 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));
 }
コード例 #2
0
 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);
 }
コード例 #3
0
 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 'Ошибка в сохранени';
     }
 }
コード例 #4
0
 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');
     }
 }
コード例 #5
0
ファイル: components.class.php プロジェクト: noikiy/qdpm
 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();
 }
コード例 #6
0
 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));
 }
コード例 #7
0
 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 'Ошибка в сохранени';
     }
 }
コード例 #8
0
 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));
 }
コード例 #9
0
ファイル: Tasks.class.php プロジェクト: noikiy/qdpm
 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();
     }
 }