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; }
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); }
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)); }
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; }
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; }
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; }