public function payAction()
{
$this->checkLevel2();
$request = $this->getRequest();
if ($request->isPost()) {
$pay = new MoneyHistory();
// validate TODO
// user info
$pay->user_id = $this->auth->getIdentity()->id;
$pay->create_date = date('Y-m-d H:i:s');
$pay->last_update = $pay->create_date;
$pay->last_user_id = $this->auth->getIdentity()->id;
// info pay
$pay->task_id = $request->getPost('task_id');
$pay->money = str_replace(',', '', $request->getPost('money', 0));
$pay->date_pay = Date::changeVNtoDateSQL($request->getPost('date_pay'));
$pay->money_option = $request->getPost('money_option');
$pay->note = $request->getPost('note');
$pay->type = $request->getPost('type');
$pay->id = $request->getPost('id', 0);
$task = $this->databaseService->getInfoTask($pay->task_id)->current();
$email = new MailHelper();
$pay->custumer = $task['custumer'];
if ($pay->id != 0) {
$old_pay = $this->databaseService->getPayById($pay->id);
if ($old_pay != null) {
$this->databaseService->modifyPayLog($this->auth->getIdentity()->id, $old_pay, $pay, $pay->type);
$email->notify_edit_pay($task, $this->auth->getIdentity()->username, $old_pay, $pay, $pay->type);
}
} else {
$this->databaseService->payLog($this->auth->getIdentity()->id, $pay, $pay->type);
$email->notify_add_pay($task, $this->auth->getIdentity()->username, $pay, $pay->type);
}
/* viet add */
/* Get task (get custumer) */
$id = $this->databaseService->insertMoneyHistory($pay);
}
return new JsonModel(array());
}
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));
}
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 addCourseAction()
{
$this->checkLevel1();
$id = $this->params()->fromRoute('id', 1);
$certificate = $this->databaseService->getCertificateByID($id);
$request = $this->getRequest();
if ($request->isPost()) {
$course = new Course();
$course->create_id = $this->auth->getIdentity()->id;
$course->create_date = date('Y-m-d H:i:s');
$course->edit_date = $course->create_date;
$course->edit_id = $this->auth->getIdentity()->id;
$course->month = $request->getPost('month', 1);
$course->year = $request->getPost('year', 2015);
$course->certificate_id = $request->getPost('certificate_id');
$start = $request->getPost('start');
$end = $request->getPost('end');
$finish = $request->getPost('finish');
$course->start = Date::changeVNtoDateSQL($start);
$course->end = Date::changeVNtoDateSQL($end);
$course->finish = Date::changeVNtoDateSQL($finish);
$id = $this->databaseService->addCourse($course);
return $this->redirect()->toRoute('manager-certificates/list-course', array('id' => $course->certificate_id));
}
return new ViewModel(array('certificate' => $certificate));
}
