/**
* (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;
}
