/** * (non-PHPdoc) * @see \Home\Form\FormBase::getData() */ public function getData($flag = null) { $data = parent::getData(); if ($data['applyDateRange']) { $daterange = explode(' - ', $data['applyDateRange']); $fromDate = $daterange[0]; $toDate = $daterange[1]; $data['fromApplyDate'] = DateBase::toCommonDate(trim($fromDate)); $data['toApplyDate'] = DateBase::toCommonDate(trim($toDate)); } return $data; }
/** * (non-PHPdoc) * @see \Zend\Form\Form::getData() */ public function getData($flag = null) { $data = parent::getData(); if (isset($data['daterangepicker']) && $data['daterangepicker']) { $daterange = explode(' - ', $data['daterangepicker']); $fromDate = $daterange[0]; $toDate = $daterange[1]; $data['fromDate'] = DateBase::toCommonDate(trim($fromDate)); $data['toDate'] = DateBase::toCommonDate(trim($toDate)); } return $data; }
/** * (non-PHPdoc) * @see \Home\Form\FormBase::getData() */ public function getData($flag = null) { $data = parent::getData($flag); if ($data['applyDate']) { $data['applyDate'] = DateBase::toCommonDate($data['applyDate']); } $itemsArray = json_decode($data['items'], true); $itemData = []; foreach ($itemsArray as $itemDataPopulate) { $itemDataPopulate['accountId'] = $data['accountId']; $itemValidator = new \Accounting\Form\Transaction\ItemValidate($this->getServiceLocator()); $itemValidator->setData($itemDataPopulate); $itemValidator->isValid(); $itemData[] = $itemValidator->getData(); } $data['itemData'] = $itemData; return $data; }
/** * lấy ra danh sách employee bị tạo sau mung 1 thang 8 mà ko phải do đồng bộ về * Lấy ra lịch sử tạo tương ứng của employee đó * Nếu có lịch sử, echange array cho employee về lịch sử đó, set code= null * Nếu chưa có lịch sử, tham chiếu theo user để lấy lại tên, email, các thông tin khác đánh về null hết */ public function revertemployee20150818Action() { $fromDate = '2015-08-01 00:00:00'; $dbAdapter = $this->getServiceLocator()->get('dbAdapter'); $dbSql = $this->getServiceLocator()->get('dbSql'); $select = $dbSql->select(['e' => \Hrm\Model\EmployeeMapper::TABLE_NAME]); $select->where(['createdDateTime >= ?' => $fromDate]); $select->where(['createdById != ?' => 1]); $select->where(['code IS NOT NULL']); $select->where(['oneofficeId IS NOT NULL']); $rows = $dbAdapter->query($dbSql->buildSqlString($select), $dbAdapter::QUERY_MODE_EXECUTE); $employeeIds = []; $employees = []; foreach ($rows->toArray() as $row) { $employeeIds[$row['id']] = $row['id']; $employees[$row['id']] = new \Hrm\Model\Employee($row); } if (!count($employeeIds)) { echo 'Ko timf thaays ban ghi naof'; die; } /** lấy ra danh sách employee bị tạo sau mung 1 thang 8 mà ko phải do đồng bộ về*/ $select = $dbSql->select(['h' => \Hrm\Model\Employee\HistoryMapper::TABLE_NAME]); $select->where(['employeeId' => $employeeIds]); $select->where(['type' => 1]); $select->group(['employeeId']); $query = $dbSql->buildSqlString($select); $rows = $dbAdapter->query($dbSql->buildSqlString($select), $dbAdapter::QUERY_MODE_EXECUTE); $histories = []; foreach ($rows->toArray() as $row) { $histories[$row['employeeId']] = gzuncompress($row['dataAfter']); } $this->getViewModel()->setVariable('employees', $employees); $this->getViewModel()->setVariable('histories', $histories); $employeeMapper = $this->getServiceLocator()->get('\\Hrm\\Model\\EmployeeMapper'); $userMapper = $this->getServiceLocator()->get('\\User\\Model\\UserMapper'); foreach ($histories as $employeeId => $history) { $history = json_decode($history, true); $employee = $employees[$employeeId]; $userId = $employee->getUserId(); $employee->exchangeArray($history); if ($employee->getBirthdate()) { $employee->setBirthdate(DateBase::toCommonDate($employee->getBirthdate())); } if ($employee->getQuitDate()) { $employee->setQuitDate(DateBase::toCommonDate($employee->getQuitDate())); } if ($employee->getBirthdate()) { $employee->setBirthdate(DateBase::toCommonDate($employee->getBirthdate())); } if ($employee->getReceiveContractDate()) { $employee->setReceiveContractDate(DateBase::toCommonDate($employee->getReceiveContractDate())); } $employee->setCode(null); $employee->setOneofficeId(null); $employee->setUserId($userId); $employeeMapper->save($employee); echo 'revert từ history employee ' . $employee->getId(); echo '<br/>'; unset($employees[$employeeId]); } if (count($employees)) { foreach ($employees as $employee) { $employee->setCode(null); $employee->setOneofficeId(null); $employee->exchangeArray(array('maritalStatus' => null, 'birthdate' => null, 'birthplace' => null, 'hometown' => null, 'identification' => null, 'identificationPlace' => null, 'identificationDate' => null, 'nation' => null, 'countryId' => null, 'startedDate' => null, 'hasFullPrivilege' => null, 'oneofficeId' => null, 'mobile' => null, 'email' => null, 'yahoo' => null, 'skype' => null, 'facebook' => null, 'religion' => null, 'birthCertificate' => null, 'sittingPositionId' => null, 'workingCityId' => null, 'workingStatus' => null, 'insuranceBookId' => null, 'taxCode' => null, 'bankAccountName' => null, 'bankAccountNumber' => null, 'bankAccountBranch' => null, 'quitDate' => null, 'quitReason' => null, 'quitConfirmedById' => null, 'quitConfirmedDateTime' => null, 'temporateAddress' => null, 'permanentAddress' => null, 'receiveContractDate' => null, 'extraContent' => null)); $user = $userMapper->get($employee->getUserId()); if ($user) { $employee->setFullName($user->getFullName()); list($lastName, $middleName, $firstName) = Format::splitFullName($employee->getFullName()); $employee->setLastName($lastName); $employee->setMiddleName($middleName); $employee->setFirstName($firstName); $employee->setEmail($user->getEmail()); } $employeeMapper->save($employee); echo 'Set lại data ' . $employee->getId(); echo '<br/>'; } } die; //return $this->getViewModel(); }
public function getData($flag = 17) { $data = parent::getData(); if (isset($data['birthdate']) && $data['birthdate']) { $data['birthdate'] = DateBase::toCommonDate($data['birthdate']); } if (!$data['password']) { unset($data['password']); } return $data; }
/** * @param $mess \Admin\Model\MessagesMG */ public function reportdetail($mess) { $dm = $this->getServiceLocator()->get('doctrine.documentmanager.odm_default'); $select = $this->getDbSql()->select(['ca' => self::TABLE_NAME]); $predicateSet = new PredicateSet(); $predicateSet->addPredicate(new Operator('ca.callcenter', Operator::OPERATOR_EQUAL_TO, $mess->getSender()), $predicateSet::OP_OR); $predicateSet->addPredicate(new Operator('ca.mentor', Operator::OPERATOR_EQUAL_TO, $mess->getSender()), $predicateSet::OP_OR); $select->where($predicateSet); $select->where(['ca.endedDate' => DateBase::toCommonDate($mess->getCreated())]); $query = $this->getDbSql()->buildSqlString($select); $rows = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE); $result = []; $time = ''; foreach ($rows as $r) { $result[DateBase::toDisplayDateTime($r['createdDateTime']) . ' - ' . DateBase::toDisplayDateTime($r['endedDateTime'])] = ['rating' => $r['rating'], 'comment' => $r['note']]; $createdDatetime = new \DateTime($r['createdDateTime']); $endDatetime = new \DateTime($r['endedDateTime']); $timediff = date_diff($createdDatetime, $endDatetime); $result[DateBase::toDisplayDateTime($r['createdDateTime']) . ' - ' . DateBase::toDisplayDateTime($r['endedDateTime'])]['time'] += $timediff->format('%i'); $qb = $dm->createQueryBuilder('Admin\\Model\\MessagesMG'); $qb->field('receiver')->equals($r['room']); $qb->field('created')->range($createdDatetime, $endDatetime); $querymg = $qb->getQuery(); $resultmg = $querymg->execute(); $i = 0; /** @var \Admin\Model\MessagesMG $m */ foreach ($resultmg as $m) { $i++; $result[DateBase::toDisplayDateTime($r['createdDateTime']) . ' - ' . DateBase::toDisplayDateTime($r['endedDateTime'])]['messages'][] = ['sender' => $m->getSender(), 'room' => $m->getReceiver(), 'msg' => $m->getMsg(), 'imgPath' => $m->getImgPath(), 'created' => $m->getCreated()->format(DateBase::DISPLAY_DATETIME_FORMAT)]; // vdump($i.'. Sender: '.$m->getSender().'|| Receiver: '.$m->getReceiver().' || Msg: '.$m->getMsg().' || Created: '.$m->getCreated()->format(DateBase::DISPLAY_DATETIME_FORMAT)); } } return $result; // if($mess->getSender()){ // $qb->field('sender')->equals($mess->getSender()); // } }
public function addAction() { /** @var \Zend\Http\Request $request */ $request = $this->getRequest(); $sl = $this->getServiceLocator(); /* @var $cityMapper \Address\Model\CityMapper */ $cityMapper = $sl->get('Address\\Model\\CityMapper'); $city = new \Address\Model\City(); /* @var $districtMapper \Address\Model\DistrictMapper */ $districtMapper = $sl->get('Address\\Model\\DistrictMapper'); $district = new \Address\Model\District(); $districts = array(); if (!!($cityId = $request->getPost('cityId'))) { $district->setCityId($cityId); $districts = $districtMapper->fetchAll($district); } $form = new \System\Form\User\Add($this->getServiceLocator()); $form->setCities($city->toSelectBoxArray($cityMapper->fetchAll())); $form->setDistricts($district->toSelectBoxArray($districts)); if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $form->setData($data); if ($form->isValid()) { $user = new User(); $user->exchangeArray($form->getData()); $user->setSalt($user->generateSalt()); $user->setPassword($user->createPassword()); if (!$user->getRole()) { $user->setRole(User::ROLE_GUEST); } if ($user->getBirthdate()) { $user->setBirthdate(DateBase::toCommonDate($user->getBirthdate())); } $user->setActive(1); $user->setCreatedById($this->user()->getIdentity()); $user->setCreatedDate(DateBase::getCurrentDate()); $user->setCreatedDateTime(DateBase::getCurrentDateTime()); $userMapper = $this->getServiceLocator()->get('\\User\\Model\\UserMapper'); $userMapper->save($user); if ($form->get('afterSubmit')->getValue()) { return $this->redirect()->toUrl($form->get('afterSubmit')->getValue()); } } } $viewModel = new ViewModel(); $viewModel->setVariable('form', $form); return $viewModel; }