Ejemplo n.º 1
0
 public function getlistAction()
 {
     $this->checkAuth();
     $request = $this->getRequest();
     $draw = $request->getPost('draw', 1);
     $start = $request->getPost('start', 0);
     $length = $request->getPost('length', 10);
     $search = $request->getPost('search', '');
     $search = $search['value'];
     $total = $this->databaseService->getTotalUsers();
     $users = $this->databaseService->getListUsers($start, $length, $search);
     $data = new DataTablesObject();
     $data->recordsTotal = $total;
     $data->recordsFiltered = $this->databaseService->getCountUsers($search);
     $data->draw = $draw;
     foreach ($users as $user) {
         $user->create_date = Date::changeDateSQLtoVN($user->create_date);
         array_push($data->data, new UserListItem($user->id, $user->username, $user->role_name, $user->block, $user->create_date));
     }
     echo \Zend\Json\Json::encode($data, false);
     exit;
 }
Ejemplo n.º 2
0
 public function payhistoryAction()
 {
     $this->checkLevel2();
     $request = $this->getRequest();
     if ($request->isPost()) {
         $taks_id = $request->getPost('task_id');
         $type = $request->getPost('type');
         $historys = $this->databaseService->getPayHistory($taks_id, $type);
         $result = array();
         foreach ($historys as $history) {
             $item = new MoneyHistory();
             $item->id = $history->id;
             $item->username = $history->username;
             $item->money = number_format($history->money);
             $item->date_pay = Date::changeDateSQLtoVN($history->date_pay);
             array_push($result, $item);
         }
     }
     return new JsonModel($result);
 }
Ejemplo n.º 3
0
 public function taskdetailAction()
 {
     $this->checkAuth();
     $id = $this->params()->fromRoute('id', 0);
     $task = $this->databaseService->getInfoTask($id);
     if ($task->count() == 0) {
         return $this->redirect()->toRoute('tasks');
     }
     $task = $task->current();
     $task->date_open = Date::changeDateSQLtoVN($task->date_open);
     $task->date_end = Date::changeDateSQLtoVN($task->date_end);
     $task->date_open_pr = Date::changeDateSQLtoVN($task->date_open_pr);
     $task->date_end_pr = Date::changeDateSQLtoVN($task->date_end_pr);
     $task->last_update = Date::changeDateSQLtoVN($task->last_update);
     $listprocess = $this->databaseService->getListProcess();
     $users = $this->databaseService->getListByRole(Config::ROLE_AGENCY);
     $pay_custumer = $this->databaseService->getTotalPay($id, Config::PAY_CUSTUMER);
     $pay_custumer = number_format($pay_custumer);
     $pay_provider = $this->databaseService->getTotalPay($id, Config::PAY_PROVIDER);
     $provider_debt = number_format($task->cost_buy - $pay_provider);
     $pay_provider = number_format($pay_provider);
     $task->cost_buy = number_format($task->cost_buy);
     $provider_historys = $this->databaseService->getPayHistory($id, Config::PAY_PROVIDER);
     $this->getServiceLocator()->get('ViewHelperManager')->get('HeadTitle')->set($task->id . " - " . $task->custumer);
     return new ViewModel(array('task' => $task, 'listprocess' => $listprocess, 'pay_provider' => $pay_provider, 'provider_historys' => $provider_historys, 'provider_debt' => $provider_debt));
 }
Ejemplo n.º 4
0
 protected function getSelectListPay($start, $length, $search, $columns, $order, $user_id)
 {
     $sql = new Sql($this->dbAdapter);
     $select = $sql->select('pay_action');
     $select->join('users', 'pay_action.user_id = users.id', array('username' => 'username'), 'left');
     $select->join(array('create' => 'users'), 'pay_action.create_user = create.id', array('user_create' => 'username'), 'left');
     if ($search != '' && $search != null) {
         $select->where->like('pay_action.title', '%' . $search . '%');
     }
     $username = DataTableUtility::getSearchValue($columns, "username");
     if ($username != "" && $username != 0) {
         $select->Where(array('users.id' => $username));
     }
     $type = DataTableUtility::getSearchValue($columns, "type");
     if ($type != "" && $type != 0) {
         $select->Where(array('pay_action.type' => $type));
     }
     $date_open = DataTableUtility::getSearchValue($columns, "date_pay");
     $date_open = explode("-", $date_open);
     $date_open_1 = "";
     $date_open_2 = "";
     if (count($date_open) == 2) {
         $date_open_1 = $date_open[0];
         $date_open_2 = $date_open[1];
     }
     if ($date_open_1 != "" && $date_open_2 != "") {
         $select->where->lessThanOrEqualTo("pay_action.date_pay", Date::changeVNtoDateSQL($date_open_2))->and->greaterThanOrEqualTo("pay_action.date_pay", Date::changeVNtoDateSQL($date_open_1));
     } elseif ($date_open_1 == "" && $date_open_2 != "") {
         $select->where->lessThanOrEqualTo("pay_action.date_pay", Date::changeVNtoDateSQL($date_open_2));
     } else {
         if ($date_open_1 != "" && $date_open_2 == "") {
             $select->where->greaterThanOrEqualTo("pay_action.date_pay", Date::changeVNtoDateSQL($date_open_1));
         }
     }
     return $select;
 }
Ejemplo n.º 5
0
 public function newAction()
 {
     $type = $this->params()->fromRoute('id', 1);
     if ($type == Config::PAY_CUSTUMER) {
         $this->getServiceLocator()->get('ViewHelperManager')->get('HeadTitle')->set("Tạo Phiếu Thu");
     } else {
         $this->getServiceLocator()->get('ViewHelperManager')->get('HeadTitle')->set("Tạo Phiếu Chi");
     }
     $request = $this->getRequest();
     if ($request->isPost()) {
         $date_pay = Date::changeVNtoDateSQL($request->getPost('date_pay'));
         $money_option = $request->getPost('money_option', 1);
         $create_user = $this->auth->getIdentity()->id;
         $create_date = date('Y-m-d H:i:s');
         $pay = new PayAction();
         $pay->title = $request->getPost('title', '');
         $pay->user_id = 0;
         $pay->date_pay = $date_pay;
         $pay->pay_option = $money_option;
         $pay->create_user = $create_user;
         $pay->create_date = $create_date;
         $pay->type = $type;
         $pay->is_task = Config::PAY_ACTION_NOT_TASK;
         $count = $request->getPost('count', 0);
         $datas = array();
         $total = 0;
         for ($i = 1; $i <= $count; $i++) {
             $data = new DataPay();
             $data->code_product = $request->getPost(sprintf('code_product_%d', $i), '');
             $data->name_product = $request->getPost(sprintf('name_product_%d', $i), '');
             $data->name_task = $request->getPost(sprintf('name_task_%d', $i), '');
             $data->cost_1 = str_replace(',', '', $request->getPost(sprintf('cost_1_%d', $i), 0));
             $data->cost_2 = str_replace(',', '', $request->getPost(sprintf('cost_2_%d', $i), 0));
             $data->cost_3 = str_replace(',', '', $request->getPost(sprintf('cost_3_%d', $i), 0));
             $data->cost_4 = str_replace(',', '', $request->getPost(sprintf('cost_4_%d', $i), 0));
             $total += $data->cost_4;
             array_push($datas, $data);
         }
         $pay->cost = $total;
         $pay->data = json_encode($datas);
         $pay_id = $this->databaseService->addPayAction($pay);
         return $this->redirect()->toRoute('pay/detail', array('id' => $pay_id));
     }
     return new ViewModel(array("type" => $type));
 }
 public function listCourseAjaxAction()
 {
     $this->checkLevel2();
     $request = $this->getRequest();
     $draw = $request->getPost('draw', 1);
     $start = $request->getPost('start', 0);
     $length = $request->getPost('length', 10);
     $search = $request->getPost('search', '');
     $columns = $request->getPost('columns', '');
     $orders = $request->getPost('order', '');
     $id = $this->params()->fromRoute('id', 1);
     $search = $search['value'];
     $total = $this->databaseService->getTotalCourse($id);
     $tasks = $this->databaseService->getListCourse($start, $length, $search, $columns, $orders, $id);
     $data = new DataTablesObject();
     $data->recordsTotal = $total;
     $data->recordsFiltered = $this->databaseService->getCountCourseFiltered($start, $length, $search, $columns, $orders, $id);
     $data->draw = $draw;
     foreach ($tasks as $task) {
         $item = new CourseListItem();
         $item->DT_RowId = $task->id;
         $item->end = Date::changeDateSQLtoVN($task->end);
         $item->start = Date::changeDateSQLtoVN($task->start);
         $item->finish = Date::changeDateSQLtoVN($task->finish);
         $item->month = $task->month;
         $item->year = $task->year;
         array_push($data->data, $item);
     }
     echo \Zend\Json\Json::encode($data, false);
     exit;
 }
Ejemplo n.º 7
0
 function notify_edit_pay($task, $user_action, $pay, $pay_new, $type)
 {
     $validator = new \Zend\Validator\EmailAddress();
     $email = NULL;
     $getcontent = file_get_contents(MailHelper::EMAIL_TEMPLETE_PATH . 'add_pay.html');
     $subject = sprintf(MailHelper::EMAIL_SUBJECT_FILTER_TEMPLATE, $task['id'], $task['certificate'], "Chỉnh Sửa Thanh Toán");
     // $getcontent = str_replace('{|link|}', "Nhận hồ sơ", $getcontent);
     $getcontent = str_replace('{|task_info|}', $task['id'] . " - " . $task['custumer'] . " - " . $task['certificate'], $getcontent);
     $getcontent = str_replace('{|user|}', $user_action, $getcontent);
     if ($pay->money != $pay_new->money) {
         $getcontent = str_replace('{|money|}', "<span style='text-decoration:line-through;color: red'>" . number_format($pay->money) . "</span>" . "<span style='color: #3c8dbc;'>" . number_format($pay_new->money) . "</span>", $getcontent);
     } else {
         $getcontent = str_replace('{|money|}', number_format($pay->money), $getcontent);
     }
     if (Date::changeDateSQLtoVN($pay->date_pay) != Date::changeDateSQLtoVN($pay_new->date_pay)) {
         $getcontent = str_replace('{|date_pay|}', "<span style='text-decoration:line-through;color: red'>" . Date::changeDateSQLtoVN($pay->date_pay) . "</span>" . "<span style='color: #3c8dbc;'>" . Date::changeDateSQLtoVN($pay_new->date_pay) . "</span>", $getcontent);
     } else {
         $getcontent = str_replace('{|date_pay|}', Date::changeDateSQLtoVN($pay->date_pay), $getcontent);
     }
     if ($pay->note != $pay_new->note) {
         $getcontent = str_replace('{|note|}', "<span style='text-decoration:line-through;color: red'>" . $pay->note . "</span>" . "<span style='color: #3c8dbc;'>" . $pay_new->note . "</span>", $getcontent);
     } else {
         $getcontent = str_replace('{|note|}', $pay->note, $getcontent);
     }
     if ($pay->money_option != $pay_new->money_option) {
         $getcontent = str_replace('{|money_option|}', "<span style='text-decoration:line-through;color: red'>" . ($pay->money_option == 1 ? "Tiền Mặt" : "Chuyển Khoản") . "</span>" . "<span style='color: #3c8dbc;'>" . ($pay_new->money_option == 1 ? "Tiền Mặt" : "Chuyển Khoản") . "</span>", $getcontent);
     } else {
         $getcontent = str_replace('{|money_option|}', $pay->money_option == 1 ? "Tiền Mặt" : "Chuyển Khoản", $getcontent);
     }
     $getcontent_tmp = str_replace('{|name|}', $task['reporter_name'], $getcontent);
     $getcontent_tmp = str_replace('{|link|}', MailHelper::REAL_SERVER_SITE . "/manager-tasks/detail/" . $task['id'], $getcontent_tmp);
     if ($validator->isValid($task['reporter_email'])) {
         $this->SendMail(MailHelper::EMAIL_SYSTEM_NAME, $task['reporter_email'], $subject, $getcontent_tmp);
     }
     $getcontent_tmp = str_replace('{|name|}', $task['assign_name'], $getcontent);
     $getcontent_tmp = str_replace('{|link|}', MailHelper::REAL_SERVER_SITE . "/manager-tasks/detail/" . $task['id'], $getcontent_tmp);
     if ($validator->isValid($task['assign_email'])) {
         $this->SendMail(MailHelper::EMAIL_SYSTEM_NAME, $task['assign_email'], $subject, $getcontent_tmp);
     }
     if ($type == Config::PAY_CUSTUMER) {
         $getcontent_tmp = str_replace('{|name|}', $task['agency_name'], $getcontent);
         $getcontent_tmp = str_replace('{|link|}', MailHelper::REAL_SERVER_SITE . "/tasks/orderdetail/" . $task['id'], $getcontent_tmp);
         if ($validator->isValid($task['agency_email'])) {
             $this->SendMail(MailHelper::EMAIL_SYSTEM_NAME, $task['agency_email'], $subject, $getcontent_tmp);
         }
     }
     if ($type == Config::PAY_PROVIDER) {
         $getcontent_tmp = str_replace('{|name|}', $task['provider_name'], $getcontent);
         $getcontent_tmp = str_replace('{|link|}', MailHelper::REAL_SERVER_SITE . "/tasks/taskdetail/" . $task['id'], $getcontent_tmp);
         if ($validator->isValid($task['provider_email'])) {
             $this->SendMail(MailHelper::EMAIL_SYSTEM_NAME, $task['provider_email'], $subject, $getcontent_tmp);
         }
     }
     //echo $getcontent;
     return NULL;
 }