public function fixapierror20150626Action()
{
set_time_limit(300);
$dbSql = $this->getServiceLocator()->get('dbSql');
$dbAdapter = $this->getServiceLocator()->get('dbAdapter');
/*@var $dbAdapter \Zend\Db\Adapter\Adapter */
$fromDate = '2015-06-26 00:00:00';
$toDate = '2015-06-30 00:00:00';
$defaultSupporter = 21;
// lấy ra các lead do api tạo thành trong khoảng từ 26/6 -> 29/6 (arr1)
$select = $dbSql->select(['l' => \Crm\Model\LeadMapper::TABLE_NAME]);
$select->where(['createdById' => 1]);
$select->where(['createdDateTime >= ?' => $fromDate]);
$select->where(['createdDateTime <= ?' => $toDate]);
$query = $dbSql->buildSqlString($select);
echo $query;
echo '<br/>';
echo '<br/>';
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
$leadIds = [];
$leads = [];
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$leadIds[$row['id']] = $row['id'];
}
}
unset($select);
unset($rows);
// thêm ra các lead có yêu cầu tính năng hoặc đăng kí dùng thử trong đoạn thời gian này
$select = $dbSql->select(['a' => \Crm\Model\ActivityMapper::TABLE_NAME]);
$select->columns(['leadId']);
$select->where(['accountId IS NULL']);
$select->where(['createdById' => 1]);
$select->where(['type' => [\Crm\Model\Activity::TYPE_CUSTOMER_REQUEST, \Crm\Model\Activity::TYPE_REGISTER_FOR_TRIAL]]);
$select->where(['createdDateTime >= ?' => $fromDate]);
$select->where(['createdDateTime <= ?' => $toDate]);
$query = $dbSql->buildSqlString($select);
echo $query;
echo '<br/>';
echo '<br/>';
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
if (!isset($leadIds[$row['leadId']])) {
$leadIds[$row['leadId']] = $row['leadId'];
}
}
}
unset($select);
unset($rows);
// loại trừ trong số lead này các lead mà lan đang năm giữ (arr2)
$select = $dbSql->select(['l' => \Crm\Model\LeadMapper::TABLE_NAME]);
$select->join(['lu' => \Crm\Model\Lead\UserMapper::TABLE_NAME], 'l.id=lu.leadId', []);
$select->columns(['id']);
$select->where(['leadId' => $leadIds]);
$select->where(['lu.userId' => $defaultSupporter]);
$select->group(['l.id']);
$query = $dbSql->buildSqlString($select);
echo $query;
echo '<br/>';
echo '<br/>';
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
if (isset($leadIds[$row['id']])) {
unset($leadIds[$row['id']]);
}
}
}
unset($select);
unset($rows);
// loaij trừ các leadId trong số đó mà có bất cứ hành động nào ko thuộc (nhận, bàn giao, yêu cầu tính năng, tự đăng kí, yêu cầu gọi)
$select = $dbSql->select(['a' => \Crm\Model\ActivityMapper::TABLE_NAME]);
$select->columns(['leadId']);
$select->where(['leadId' => $leadIds]);
$select->where(new NotIn('type', [\Crm\Model\Activity::TYPE_ASSIGN_LEAD, \Crm\Model\Activity::TYPE_SELF_ASSIGN_LEAD, \Crm\Model\Activity::TYPE_REQUEST_PHONECALL, \Crm\Model\Activity::TYPE_CUSTOMER_REQUEST, \Crm\Model\Activity::TYPE_REGISTER_FOR_TRIAL]));
$select->where(['companyId' => 1]);
$select->group(['leadId']);
$query = $dbSql->buildSqlString($select);
echo $query;
echo '<br/>';
echo '<br/>';
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
if (isset($leadIds[$row['leadId']])) {
unset($leadIds[$row['leadId']]);
}
}
}
unset($select);
unset($rows);
// với mỗi leadId này, gỡ hết user ra, gắn lại cho Lan + thêm yêu cầu gọi cho cái lan
if (count($leadIds)) {
$activityMapper = $this->getServiceLocator()->get('\\Crm\\Model\\ActivityMapper');
$leadMapper = $this->getServiceLocator()->get('\\Crm\\Model\\LeadMapper');
foreach ($leadIds as $leadId) {
// xóa action nhận - bàn giao của lead này
$delete = $dbSql->delete(\Crm\Model\ActivityMapper::TABLE_NAME);
$delete->where(['leadId' => $leadId]);
$delete->where(['companyId' => 1]);
$delete->where(['type' => [\Crm\Model\Activity::TYPE_ASSIGN_LEAD, \Crm\Model\Activity::TYPE_SELF_ASSIGN_LEAD]]);
$delete->where(['relatedUserId != ?' => $defaultSupporter]);
$query = $dbSql->buildSqlString($delete);
$dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
// xóa user đang chăm sóc lead này
$delete = $dbSql->delete(\Crm\Model\Lead\UserMapper::TABLE_NAME);
$delete->where(['leadId' => $leadId]);
$delete->where(['companyId' => 1]);
$delete->where(['userId != ?' => $defaultSupporter]);
$query = $dbSql->buildSqlString($delete);
$dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
// lay ra lead
$lead = new \Crm\Model\Lead();
$lead->setId($leadId);
$leadMapper->get($lead);
// thêm action yêu cầu gọi cho Lan
$activity = new \Crm\Model\Activity();
$activity->setLeadId($leadId);
$activity->setCompanyId(1);
$activity->setType(\Crm\Model\Activity::TYPE_REQUEST_PHONECALL);
$activity->setStatus(\Crm\Model\Activity::STATUS_SUCCESS);
$activity->setTitle('Bổ sung xác nhận dùng thử 26/6 - 30/6');
$content = [];
if ($lead->getNhanhStoreId()) {
$content[] = '<b>nhanhStoreId: </b>' . $lead->getNhanhStoreId();
}
if ($lead->getNhanhStoreName()) {
$content[] = '<b>nhanhStoreName: </b>' . $lead->getNhanhStoreName();
}
$activity->setContent(count($content) ? implode('<br/>', $content) : null);
$activity->setCreatedById(1);
$activity->setCreatedDate(DateBase::getCurrentDate());
$activity->setCreatedDateTime(DateBase::getCurrentDateTime());
$activity->setRelatedUserId($defaultSupporter);
$activityMapper->save($activity);
//gắn cho lan
$leadUser = new \Crm\Model\Lead\User();
$leadUser->setLeadId($leadId);
$leadUser->setCompanyId(1);
$leadUser->setUserId($defaultSupporter);
$leadUser->setType(\Crm\Model\Lead\User::TYPE_SALE);
$leadUserMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Lead\\UserMapper');
if (!$leadUserMapper->isExisted($leadUser)) {
$leadUser->setCreatedById(1);
$leadUser->setCreatedDateTime(DateBase::getCurrentDateTime());
$leadUserMapper->save($leadUser);
}
//update lại companyStatus + lastActivity
$leadCompany = new \Crm\Model\Lead\Company();
$leadCompany->setLeadId($leadId);
$leadCompany->setCompanyId(1);
$leadCompanyMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Lead\\CompanyMapper');
$leadCompanyMapper->isExisted($leadCompany);
$leadCompany->setLastActivityDateTime(DateBase::getCurrentDateTime());
$leadCompany->setStatus(\Crm\Model\Lead\Company::STATUS_BELONG);
$leadCompanyMapper->save($leadCompany);
echo 'update lead : <b>' . $leadId . '</b><br/>';
}
}
die;
}
/**
* @author KienNN
* @param \Accounting\Model\Transaction $item
* @param unknown $options
*/
public function searchCrmContract($item, $options)
{
$select = $this->getDbSql()->select(['t' => self::TABLE_NAME]);
$select->join(['c' => \Crm\Model\ContractMapper::TABLE_NAME], 't.itemId=c.id', []);
$select->where(['t.itemType' => \Accounting\Model\Transaction::ITEM_TYPE_CRM_CONTRACT]);
if ($item->getCompanyId()) {
$select->where(['t.companyId' => $item->getCompanyId()]);
}
if ($item->getOption('companyIds')) {
$select->where(['t.companyId' => $item->getOption('companyIds')]);
}
if ($item->getOption('userIds')) {
$select->join(['lu' => \Crm\Model\Lead\UserMapper::TABLE_NAME], new Expression('lu.accountId=c.accountId OR lu.leadId=c.leadId'), []);
$select->where(['lu.userId' => $item->getOption('userIds')]);
}
if ($item->getId()) {
$select->where(['t.id' => $item->getId()]);
}
if ($item->getStatus()) {
$select->where(['t.status' => $item->getStatus()]);
}
if ($item->getType()) {
$select->where(['t.type' => $item->getType()]);
}
if ($item->getCreatedById()) {
$select->where(['t.createdById' => $item->getCreatedById()]);
}
if ($item->getOption('departmentId')) {
$select->where(['c.departmentId' => $item->getOption('departmentId')]);
}
if ($item->getOption('contractId')) {
$select->where(['t.itemId' => $item->getOption('contractId')]);
}
if ($item->getOption('productId')) {
$select->join(['cp' => \Crm\Model\Contract\ProductMapper::TABLE_NAME], 'cp.contractId=t.itemId', []);
$select->where(['cp.productId' => $item->getOption('productId')]);
}
if ($item->getOption('accountingType')) {
$select->join(['i' => \Accounting\Model\Transaction\ItemMapper::TABLE_NAME], 'i.transactionId=t.id', []);
$condition = new Expression('i.creditAccountId=ac.id OR i.debitAccountId=ac.id');
$select->join(['ac' => \Accounting\Model\AccountMapper::TABLE_NAME], $condition, []);
$select->where(['ac.type' => $item->getOption('accountingType')]);
}
if ($item->getOption('accountId')) {
$select->where(['c.accountId' => $item->getOption('accountId')]);
}
if ($item->getOption('leadId')) {
$select->where(['c.leadId' => $item->getOption('leadId')]);
}
if ($item->getOption('fromApplyDate')) {
$select->where(['t.applyDate >= ?' => $item->getOption('fromApplyDate')]);
$select->where(['t.accountingById IS NOT NULL']);
}
if ($item->getOption('toApplyDate')) {
$select->where(['t.applyDate <= ?' => $item->getOption('toApplyDate')]);
$select->where(['t.accountingById IS NOT NULL']);
}
if ($item->getOption('fromCreatedDate')) {
$select->where(['t.createdDate >= ?' => $item->getOption('fromCreatedDate')]);
}
if ($item->getOption('toCreatedDate')) {
$select->where(['t.createdDate <= ?' => $item->getOption('toCreatedDate')]);
}
if ($item->getCreatedById()) {
$select->where(['t.createdById' => $item->getCreatedById()]);
}
if ($item->getAccountingById()) {
$select->where(['t.accountingById' => $item->getAccountingById()]);
}
if ($item->getOption('commisstionToEmployeeId')) {
$select->join(['com' => \Crm\Model\Contract\CommissionMapper::TABLE_NAME], 't.itemId=com.contractId', []);
$select->where(['com.employeeId' => $item->getOption('commisstionToEmployeeId')]);
}
$select->group(['t.id']);
$select->order([new Expression('IFNULL(t.applyDate, t.createdDate) DESC'), 't.id DESC']);
$paginator = $this->preparePaginator($select, $options, new \Accounting\Model\Transaction());
$contractIds = [];
$userIds = [];
$transactionIds = [];
foreach ($paginator as $transaction) {
if ($transaction->getItemId()) {
$contractIds[$transaction->getItemId()] = $transaction->getItemId();
}
if ($transaction->getCreatedById()) {
$userIds[$transaction->getCreatedById()] = $transaction->getCreatedById();
}
if ($transaction->getApprovedById()) {
$userIds[$transaction->getApprovedById()] = $transaction->getApprovedById();
}
if ($transaction->getAccountingById()) {
$userIds[$transaction->getAccountingById()] = $transaction->getAccountingById();
}
if ($transaction->getPaymentById()) {
$userIds[$transaction->getPaymentById()] = $transaction->getPaymentById();
}
$transactionIds[$transaction->getId()] = $transaction->getId();
}
$crmAccounts = [];
$crmLeads = [];
$contractValues = [];
$contractPaids = [];
if (count($contractIds)) {
if ($item->getOption('loadCustomer')) {
$select = $this->getDbSql()->select(['a' => \Crm\Model\AccountMapper::TABLE_NAME]);
$select->join(['c' => \Crm\Model\ContractMapper::TABLE_NAME], 'c.accountId=a.id', ['contractId' => 'id']);
$select->where(['c.id' => $contractIds]);
$rows = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$account = new \Crm\Model\Account();
$account->exchangeArray($row);
$crmAccounts[$row['contractId']] = $account;
}
}
$select = $this->getDbSql()->select(['l' => \Crm\Model\LeadMapper::TABLE_NAME]);
$select->join(['c' => \Crm\Model\ContractMapper::TABLE_NAME], 'c.leadId=l.id', ['contractId' => 'id']);
$select->where(['c.id' => $contractIds]);
$rows = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$lead = new \Crm\Model\Lead();
$lead->exchangeArray($row);
$crmLeads[$row['contractId']] = $lead;
}
}
}
if ($item->getOption('loadContractValue')) {
$select = $this->getDbSql()->select(['p' => \Crm\Model\Contract\ProductMapper::TABLE_NAME]);
$select->where(['contractId' => $contractIds]);
$rows = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$product = new \Crm\Model\Contract\Product($row);
$value = $product->calculateValue();
if (isset($contractValues[$product->getContractId()])) {
$contractValues[$product->getContractId()] += $value;
} else {
$contractValues[$product->getContractId()] = $value;
}
}
}
}
if ($item->getOption('loadContractPaid')) {
$select = $this->getDbSql()->select(['t' => self::TABLE_NAME]);
$select->where(['itemType' => \Accounting\Model\Transaction::ITEM_TYPE_CRM_CONTRACT]);
$select->where(['itemId' => $contractIds]);
$select->where(['status' => [\Accounting\Model\Transaction::STATUS_ACCOUNTING, \Accounting\Model\Transaction::STATUS_PAYMENT]]);
$rows = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
if (isset($contractPaids[$row['itemId']])) {
$contractPaids[$row['itemId']] += $row['amount'];
} else {
$contractPaids[$row['itemId']] = $row['amount'];
}
}
}
}
}
$accountingAccounts = [];
if ($item->getOption('loadAccountingAccount') && count($transactionIds)) {
$select = $this->getDbSql()->select(['a' => \Accounting\Model\AccountMapper::TABLE_NAME]);
$select->join(['i' => \Accounting\Model\Transaction\ItemMapper::TABLE_NAME], new Expression('i.creditAccountId=a.id OR i.debitAccountId=a.id'), ['transactionId' => 'transactionId']);
$select->where(['i.transactionId' => $transactionIds]);
$select->group(['i.transactionId']);
$rows = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$accountingAccount = new \Accounting\Model\Account();
$accountingAccount->exchangeArray($row);
$accountingAccounts[$row['transactionId']] = $accountingAccount;
}
}
}
$users = [];
if ($item->getOption('loadUsers') && count($userIds)) {
$select = $this->getDbSql()->select(['u' => \User\Model\UserMapper::TABLE_NAME]);
$select->where(['id' => $userIds]);
$rows = $this->getDbAdapter()->query($this->getDbSql()->buildSqlString($select), Adapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
foreach ($rows->toArray() as $row) {
$user = new \User\Model\User();
$user->exchangeArray($row);
$users[$user->getId()] = $user;
}
}
}
if ($paginator->getCurrentModels()) {
foreach ($paginator->getCurrentModels() as $transaction) {
if ($transaction->getItemId() && isset($crmAccounts[$transaction->getItemId()])) {
$transaction->addOption('crmAccount', $crmAccounts[$transaction->getItemId()]);
}
if ($transaction->getItemId() && isset($crmLeads[$transaction->getItemId()])) {
$transaction->addOption('crmLead', $crmLeads[$transaction->getItemId()]);
}
if (isset($accountingAccounts[$transaction->getId()])) {
$transaction->addOption('accountingAccount', $accountingAccounts[$transaction->getId()]);
}
if ($transaction->getCreatedById() && isset($users[$transaction->getCreatedById()])) {
$transaction->addOption('createdBy', $users[$transaction->getCreatedById()]);
}
if ($transaction->getAccountingById() && isset($users[$transaction->getAccountingById()])) {
$transaction->addOption('accountingBy', $users[$transaction->getAccountingById()]);
}
if ($transaction->getPaymentById() && isset($users[$transaction->getPaymentById()])) {
$transaction->addOption('paymentBy', $users[$transaction->getCreatedById()]);
}
if (isset($contractValues[$transaction->getItemId()])) {
$transaction->addOption('contractValue', $contractValues[$transaction->getItemId()]);
}
if (isset($contractPaids[$transaction->getItemId()])) {
$transaction->addOption('contractPaid', $contractPaids[$transaction->getItemId()]);
}
}
}
return $paginator;
}
public function fixaddlead20150630Action()
{
$fromDateTime = '2015-06-26 00:00:00';
$toDateTime = '2015-06-29 00:00:00';
//@TODO fix cung nguoi dc yeu cau laf Thanh Lan
$relatedUserId = 21;
if ($this->getRequest()->isPost()) {
$formValidate = new \System\Form\Api\LeadValidate($this->getServiceLocator());
$dataToPopulate = $this->getRequest()->getPost();
//@TODO: fix cứng cho nhanh đã
$dataToPopulate['companyId'] = 1;
$formValidate->setData($dataToPopulate);
if ($formValidate->isValid()) {
$formData = $formValidate->getData();
$isNew = true;
$accountId = null;
$campaignId = null;
$createdDateTime = $this->getRequest()->getPost('createdDateTime');
//Tạo mới thông tin nếu chưa có
$lead = new \Crm\Model\Lead();
$lead->exchangeArray($formData);
$lead->setSource(\Crm\Model\Lead::SOURCE_WEB);
if ($lead->getSourceReference()) {
$lead->setSourceReference(substr($lead->getSourceReference(), 0, 220));
}
$lead->setCreatedById(1);
$lead->setCreatedDate(DateBase::getCurrentDate());
$lead->setCreatedDateTime(DateBase::getCurrentDateTime());
$lead->setDescription('Khách hàng tự đăng kí dùng thử trên nhanh.vn');
$leadMapper = $this->getServiceLocator()->get('\\Crm\\Model\\LeadMapper');
if (!$leadMapper->isExisted($lead)) {
$referSource = [];
$content = [];
$isVaild = false;
if (isset($formData['utm_source']) && $formData['utm_source']) {
$referSource[] = $formData['utm_source'];
$content[] = '<b>utm_source: </b>' . $formData['utm_source'];
$isVaild = true;
} else {
$referSource[] = '';
$content[] = '<b>utm_source: </b>';
}
if (isset($formData['utm_medium']) && $formData['utm_medium']) {
$referSource[] = $formData['utm_medium'];
$content[] = '<b>utm_medium: </b>' . $formData['utm_medium'];
$isVaild = true;
} else {
$referSource[] = '';
$content[] = '<b>utm_medium: </b>';
}
if (isset($formData['utm_campaign']) && $formData['utm_campaign']) {
$referSource[] = $formData['utm_campaign'];
$content[] = '<b>utm_campaign: </b>' . $formData['utm_campaign'];
$isVaild = true;
} else {
$referSource[] = '';
$content[] = '<b>utm_campaign: </b>';
}
if (isset($formData['utm_term']) && $formData['utm_term']) {
$content[] = '<b>utm_term: </b>' . $formData['utm_term'];
} else {
$content[] = '<b>utm_term: </b>';
}
if (isset($formData['utm_content']) && $formData['utm_content']) {
$content[] = '<b>utm_content: </b>' . $formData['utm_content'];
} else {
$content[] = '<b>utm_content: </b>';
}
if ($isVaild) {
$campaign = new \Crm\Model\Campaign();
$campaign->setCode(implode('_', $referSource));
$campaign->setCompanyId($lead->getCompanyId());
$campaignMapper = $this->getServiceLocator()->get('\\Crm\\Model\\CampaignMapper');
if ($campaignMapper->isExistedCode($campaign) === false) {
$campaign->setStartDate(DateBase::getCurrentDate());
$today = new \DateTime();
$today->add(new \DateInterval('P12M'));
$campaign->setEndDate($today->format(DateBase::COMMON_DATE_FORMAT));
$campaign->setName($campaign->getCode());
$campaign->setContent(implode('<br/>', $content));
$campaign->setCreatedById(1);
$campaign->setCreatedDateTime(DateBase::getCurrentDateTime());
$campaignMapper->save($campaign);
}
$campaignId = $campaign->getId();
$lead->setSource(\Crm\Model\Lead::SOURCE_MARKETING_CAMPAIGN);
$lead->setDescription(implode('<br/>', $content));
$lead->setCampaignId($campaignId);
}
$leadMapper->save($lead);
} else {
if ($lead->getOption('tableExisted') == 'lead') {
$dbAdapter = $this->getServiceLocator()->get('dbAdapter');
/* @var $dbSql \Zend\Db\Sql\Sql */
$dbSql = $this->getServiceLocator()->get('dbSql');
// check nếu đã tồn tại yêu cầu dùng thử trong khoảng thời gian cần check thì sẽ kiểm tra lại
// nếu có hành động bàn giao cho người khác Lan nhưng ko có bất kì hành động j sau đó thì xóa đi
$select = $dbSql->select(['a' => \Crm\Model\ActivityMapper::TABLE_NAME]);
$select->where(['leadId' => $lead->getId()]);
$select->where(['companyId' => $lead->getCompanyId()]);
$select->where(['type' => [\Crm\Model\Activity::TYPE_CUSTOMER_REQUEST, \Crm\Model\Activity::TYPE_REGISTER_FOR_TRIAL]]);
$select->where(['createdDateTime >= ?' => $fromDateTime]);
$select->where(['createdDateTime >= ?' => $createdDateTime]);
//$select->where(['createdDateTime <= ?' => $toDateTime]);
$query = $dbSql->buildSqlString($select);
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
return $this->getJsonModel()->setVariables(['code' => 1, 'messages' => 'sended']);
}
//check thông tin có dc ai nhận sau thời điểm bắn về ko
$select = $dbSql->select(['a' => \Crm\Model\ActivityMapper::TABLE_NAME]);
$select->where(['leadId' => $lead->getId()]);
$select->where(['companyId' => $lead->getCompanyId()]);
$select->where(['type' => [\Crm\Model\Activity::TYPE_ASSIGN_LEAD, \Crm\Model\Activity::TYPE_SELF_ASSIGN_LEAD]]);
$select->where(['createdById != ?' => $relatedUserId]);
$select->where(['createdDateTime >= ?' => $fromDateTime]);
$select->where(['createdDateTime >= ?' => $createdDateTime]);
//$select->where(['createdDateTime <= ?' => $toDateTime]);
$select->order(['createdDateTime ASC']);
$select->limit(1);
$query = $dbSql->buildSqlString($select);
$rows = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if ($rows->count()) {
// nếu có, check tiếp có hành động nào sau đấy ko
$row = (array) $rows->current();
$select = $dbSql->select(['a' => \Crm\Model\ActivityMapper::TABLE_NAME]);
$select->where(['leadId' => $lead->getId()]);
$select->where(['companyId' => $lead->getCompanyId()]);
$select->where(new NotIn('type', ['\\Crm\\Model\\Activity::TYPE_ASSIGN_LEAD, \\Crm\\Model\\Activity::TYPE_SELF_ASSIGN_LEAD']));
$select->where(['createdDateTime > ?' => $row['createdDateTime']]);
$select->limit(1);
$query = $dbSql->buildSqlString($select);
$row2 = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
if (!$row2->count()) {
// nếu chỉ nhận về mà ko có bất kì hành động j,
// Xóa các lead user dc tạo trong khoảng thời gian từ lúc bắn về đến hết thời điểm check
$delete = $dbSql->delete(\Crm\Model\Lead\UserMapper::TABLE_NAME);
$delete->where(['leadId' => $lead->getId()]);
$delete->where(['companyId' => $lead->getCompanyId()]);
$delete->where(['userId != ?' => $relatedUserId]);
$delete->where(['createdDateTime > ?' => $createdDateTime]);
$delete->where(['createdDateTime <= ?' => $toDateTime]);
$query = $dbSql->buildSqlString($delete);
$dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
// xóa các activities nhận chăm sóc
$delete = $dbSql->delete(\Crm\Model\ActivityMapper::TABLE_NAME);
$delete->where(['leadId' => $lead->getId()]);
$delete->where(['companyId' => $lead->getCompanyId()]);
$delete->where(['createdById != ?' => $relatedUserId]);
$delete->where(['type' => [\Crm\Model\Activity::TYPE_ASSIGN_LEAD, \Crm\Model\Activity::TYPE_SELF_ASSIGN_LEAD]]);
$delete->where(['createdDateTime > ?' => $createdDateTime]);
$delete->where(['createdDateTime <= ?' => $toDateTime]);
$query = $dbSql->buildSqlString($delete);
$dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE);
}
}
}
$isNew = false;
if ($lead->getOption('tableExisted') == 'account') {
$accountId = $lead->getOption('accountId');
}
}
//Update nguồn cho leadCompany
$leadCompany = new \Crm\Model\Lead\Company();
$leadCompany->setCompanyId($lead->getCompanyId());
$leadCompany->setLeadId($lead->getId());
$leadCompany->setAccountId($accountId);
if ($campaignId) {
$leadCompany->setSource(\Crm\Model\Lead::SOURCE_MARKETING_CAMPAIGN);
$leadCompany->setSourceCampaignId($campaignId);
$leadCompany->setSourceReference($lead->getSourceReference());
} elseif ($isNew) {
$leadCompany->setSource(\Crm\Model\Lead::SOURCE_WEB);
if ($lead->getSourceReference()) {
$leadCompany->setSourceReference($lead->getSourceReference());
} else {
$leadCompany->setSourceReference('nhanh.vn');
}
}
$leadCompany->setStatus(\Crm\Model\Lead\Company::STATUS_FREE);
$leadCompanyMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Lead\\CompanyMapper');
//Nếu leadCompany đã tồn tại (thông tin đã được sử dụng với cty đang check) thì chỉ update lastActivityDateTime
$leadCompanyMapper->isExisted($leadCompany);
$leadCompany->setLastActivityDateTime(DateBase::getCurrentDateTime());
$leadCompanyMapper->save($leadCompany);
//Log hành động yêu cầu dùng thử của khách hàng
$activity = new \Crm\Model\Activity();
$activity->setLeadId($lead->getId());
$activity->setAccountId($accountId);
$activity->setCompanyId($lead->getCompanyId());
$activity->setType(\Crm\Model\Activity::TYPE_REGISTER_FOR_TRIAL);
$activity->setStatus(\Crm\Model\Activity::STATUS_SUCCESS);
//$activity->setTitle('Đăng kí dùng thử '.$formData['service']) ;
$activity->setTitle($formData['title'] ?: 'Đăng kí dùng thử ' . $formData['service']);
$activity->setContent($formData['note'] ?: null);
$activity->setCreatedById(1);
$activity->setCreatedDate(DateBase::toFormat($createdDateTime, DateBase::COMMON_DATE_FORMAT));
$activity->setCreatedDateTime($createdDateTime);
$activityMapper = $this->getServiceLocator()->get('\\Crm\\Model\\ActivityMapper');
$activityMapper->save($activity);
$activityMapper->updateLeadId($activity);
//Check lại 1 lần nữa trạng thái của leadCompany là thả nổi hay đã có KD
$leadCompanyMapper->updateStatus($leadCompany);
//Nếu là thả nổi (tức là vừa dc tạo hoặc đang thả nổi) thì tạo 1 yêu cầu gọi cho chăm sóc mặc định và gắn cho cham sóc mặc định
if ($leadCompany->getStatus() == \Crm\Model\Lead\Company::STATUS_FREE) {
$activity = new \Crm\Model\Activity();
$activity->setLeadId($lead->getId());
$activity->setAccountId($accountId);
$activity->setCompanyId($lead->getCompanyId());
$activity->setType(\Crm\Model\Activity::TYPE_REQUEST_PHONECALL);
$activity->setStatus(\Crm\Model\Activity::STATUS_SUCCESS);
$activity->setTitle('Gọi xác nhận yêu cầu dùng thử');
$activity->setCreatedById(1);
$activity->setCreatedDate(DateBase::toFormat($createdDateTime, DateBase::COMMON_DATE_FORMAT));
$activity->setCreatedDateTime($createdDateTime);
$activity->setRelatedUserId($relatedUserId);
$activityMapper->save($activity);
$leadUser = new \Crm\Model\Lead\User();
$leadUser->setLeadId($lead->getId());
$leadUser->setAccountId($accountId);
$leadUser->setCompanyId($lead->getCompanyId());
$leadUser->setType(\Crm\Model\Lead\User::TYPE_SALE);
$leadUser->setUserId($relatedUserId);
$leadUser->setCreatedById(1);
$leadUser->setCreatedDateTime(DateBase::getCurrentDateTime());
$leadUserMapper = $this->getServiceLocator()->get('\\Crm\\Model\\Lead\\UserMapper');
if (!$leadUserMapper->isExisted($leadUser)) {
$leadUserMapper->save($leadUser);
}
$leadCompanyMapper->updateColumns(['status' => \Crm\Model\Lead\Company::STATUS_BELONG], $leadCompany);
}
return $this->getJsonModel()->setVariable('code', 1);
}
return $this->getJsonModel()->setVariables(['code' => 0, 'messages' => [$formValidate->getMessages()]]);
}
return $this->getJsonModel()->setVariables(['code' => 0, 'messages' => ['']]);
}
