public function findmentorAction()
{
if (!$this->getRequest()->isPost()) {
return $this->page404();
}
$data = $this->getRequest()->getPost();
$form = new SearchDetail($this->getServiceLocator());
$form->setData($data);
if ($form->isValid()) {
$user = new User();
$user->setEmail($data['email']);
$activeKey = md5($user->getEmail() . DateBase::getCurrentDateTime());
$user->setActiveKey($activeKey);
$user->setRole(User::ROLE_MEMBER);
$user->setCreatedDateTime(DateBase::getCurrentDateTime());
$user->setCreatedDate(DateBase::getCurrentDate());
/** @var \User\Model\UserMapper $userMapper */
$userMapper = $this->getServiceLocator()->get('User\\Model\\UserMapper');
if (!$userMapper->isExistedEmail($user)) {
$userMapper->save($user);
Uri::autoLink('/user/user/sendemail', ['email' => $data['email'], 'activeKey' => $user->getActiveKey()]);
$this->getJsonModel()->setVariables(['code' => 2, 'data' => 'Email kích hoạt tài khoản đã được gửi đến địa chỉ email của bạn. Kiểm tra hòm thư và làm theo hướng dẫn đễ kích hoạt tài khoản.']);
return $this->getJsonModel();
}
return $this->getViewModel();
} else {
$this->getJsonModel()->setVariables(['code' => 1, 'data' => $form->getErrorMessagesList()]);
}
return $this->getJsonModel();
}
public function signupemailAction()
{
$viewModels = new ViewModel();
if (!$this->getRequest()->isPost()) {
$viewModels->setTemplate('error/404');
return $viewModels;
}
if ($this->getRequest()->isPost()) {
$email = $this->getRequest()->getPost('email');
$user = new User();
$user->setEmail($email);
$activeKey = md5($user->getEmail() . DateBase::getCurrentDateTime());
$user->setActiveKey($activeKey);
$user->setRole(User::ROLE_MEMBER);
$user->setCreatedDateTime(DateBase::getCurrentDateTime());
$user->setCreatedDate(DateBase::getCurrentDate());
/** @var \User\Model\UserMapper $userMapper */
$userMapper = $this->getServiceLocator()->get('User\\Model\\UserMapper');
$jsonModel = new JsonModel();
if (!$userMapper->isExistedEmail($user)) {
$userMapper->save($user);
Uri::autoLink('/user/user/sendemail', ['email' => $email, 'activeKey' => $user->getActiveKey()]);
$jsonModel->setVariables(['code' => 2, 'data' => 'Email kích hoạt tài khoản đã được gửi đến địa chỉ email của bạn. Kiểm tra hòm thư và làm theo hướng dẫn đễ kích hoạt tài khoản.']);
} else {
$jsonModel->setVariables(['code' => 1, 'data' => 'Email này đã được đăng ký, bạn vui lòng đăng nhập.']);
}
}
return $jsonModel;
}
/**
* Thả nổi các lead sau 1 số ngày nhất định mà ko có ghi nhận activity nào
* @return \Zend\View\Model\ViewModel
*/
public function freeleadAction()
{
// tạm ko sử dụng nữa
echo 'Tạm không hỗ trợ nữa';
die;
set_time_limit(300);
$dbAdapter = $this->getServiceLocator()->get('dbAdapter');
/* @var $dbAdapter \Zend\Db\Adapter\Adapter */
$dbSql = $this->getServiceLocator()->get('dbSql');
/* @var $dbSql \Zend\Db\Sql\Sql */
$select = $dbSql->select(array('lu' => \Crm\Model\Lead\UserMapper::TABLE_NAME));
$select->join(['lc' => \Crm\Model\Lead\CompanyMapper::TABLE_NAME], new Expression('lu.leadId = lc.leadId AND lu.companyId=lc.companyId'), ['lastActivityDateTime', 'releaseDateTime', 'lc.id' => 'id'], $select::JOIN_LEFT);
$select->where(['lu.type' => \Crm\Model\Lead\User::TYPE_SALE]);
$select->where(['lc.lastActivityDateTime IS NOT NULL']);
$select->where(['lc.accountId IS NULL']);
$date = new \DateTime();
$date->setTime('0', 0, 0);
$today = $date->format(DateBase::COMMON_DATETIME_FORMAT);
$date->sub(new \DateInterval('P' . \Crm\Model\Lead::MAXIMUM_KEEP_DAY . 'D'));
$lastActDate = $date->format(DateBase::COMMON_DATETIME_FORMAT);
$select->where(['lc.lastActivityDateTime <= ?' => $lastActDate]);
$predicateSet = new PredicateSet();
$predicateSet->addPredicate(new IsNull('lc.releaseDateTime'), $predicateSet::OP_OR);
$predicateSet->addPredicate(new Operator('lc.releaseDateTime', '<=', $today), $predicateSet::OP_OR);
$select->where($predicateSet);
$select->limit(300);
$query = $dbSql->buildSqlString($select);
echo $query;
echo '<br/>';
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
$leadUserMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Lead\\UserMapper');
$activityMapper = $this->getServiceLocator()->get('\\Crm\\Model\\ActivityMapper');
$leadCompanyMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Lead\\CompanyMapper');
$lcIds = [];
if ($rows->count()) {
foreach ($rows as $row) {
$row = (array) $row;
$leadUser = new \Crm\Model\Lead\User($row);
$leadUserMapper->delete($leadUser);
$activity = new \Crm\Model\Activity();
$activity->setType(\Crm\Model\Activity::TYPE_AUTO_FREE);
$activity->setCompanyId($leadUser->getCompanyId());
$activity->setLeadId($leadUser->getLeadId());
$activity->setAccountId($leadUser->getAccountId());
$activity->setTitle('Tự giải phóng sau ' . \Crm\Model\Lead::MAXIMUM_KEEP_DAY . ' ngày');
$activity->setRelatedUserId($leadUser->getUserId());
$activity->setCreatedById(1);
$activity->setCreatedDate(DateBase::getCurrentDate());
$activity->setCreatedDateTime(DateBase::getCurrentDateTime());
$activity->setStatus(\Crm\Model\Activity::STATUS_SUCCESS);
$activityMapper->save($activity);
$lcIds[$row['lc.id']] = $row['lc.id'];
}
if (count($lcIds)) {
$select = $dbSql->select(array('lc' => \Crm\Model\Lead\CompanyMapper::TABLE_NAME));
$select->join(['lu' => \Crm\Model\Lead\UserMapper::TABLE_NAME], new Expression('lu.leadId = lc.leadId AND lu.companyId=lc.companyId AND lu.type=' . \Crm\Model\Lead\User::TYPE_SALE), [], $select::JOIN_LEFT);
$select->where(['lc.id' => $lcIds]);
$select->where(['lu.id IS NULL']);
$relatedLcIds = [];
$query = $dbSql->buildSqlString($select);
echo $query;
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
$currentDatetime = DateBase::getCurrentDateTime();
foreach ($rows as $row) {
$row = (array) $row;
$leadCompany = new \Crm\Model\Lead\Company($row);
$leadCompanyMapper->updateColumns(['lastActivityDateTime' => $currentDatetime], $leadCompany);
}
}
}
$updateQuery = 'UPDATE
crm_leads_companies lc
LEFT JOIN crm_leads_users lu
ON lu.companyId=lc.companyId AND lu.leadId=lc.leadId AND lu.type=' . \Crm\Model\Lead\User::TYPE_SALE . '
SET lc.status=' . \Crm\Model\Lead\Company::STATUS_FREE . '
WHERE lc.accountId IS NULL AND lu.id IS NULL';
$updateQuery2 = 'UPDATE crm_leads_companies lc
INNER JOIN crm_leads_users lu ON lc.leadId=lu.leadId AND lc.companyId=lu.companyId AND lu.type= ' . \Crm\Model\Lead\User::TYPE_SALE . ' SET
lc.status = ' . \Crm\Model\Lead\Company::STATUS_BELONG . ' WHERE
lc.leadId IS NOT NULL AND lc.companyId IS NOT NULL';
echo '<br/>';
echo '<br/>';
echo $updateQuery;
$results = $dbAdapter->query($updateQuery, $dbAdapter::QUERY_MODE_EXECUTE);
echo '<br/>';
echo '<br/>';
echo $updateQuery2;
$results = $dbAdapter->query($updateQuery2, $dbAdapter::QUERY_MODE_EXECUTE);
echo '<br/>';
echo '<br/>';
echo 'DONE!';
\Home\Service\Uri::autoLink('/system/auto/freelead');
}
die;
}
