protected function genAndGetEngSql($whereStr)
{
return str_replace('$whereStr', $whereStr, Processor::getStorageSql('CTILayout_ENG.sql'));
}
protected function fetchCampaignsCount()
{
$sql = str_replace(['$yesterday', '$tomorrow'], [Carbon::now()->format('Y-m-d H:i:s'), Carbon::now()->format('Y-m-d H:i:s')], Processor::getStorageSql('FV/Import/campaign_count.sql'));
return array_get(Processor::getArrayResult($sql, Processor::DB_CTI), 0)['_count'];
}
protected function getMarqGroupQuery()
{
$startOfMonth = Carbon::now()->modify('first day of this month')->format('Ymd');
$today = Carbon::now()->format('Ymd');
return str_replace(['$whereCondition', '$today', '$weekStart', '$weekEnd'], ["CCS_OrderIndex.Status = 1 AND CCS_OrderIndex.KeyInDate BETWEEN {$startOfMonth} AND {$today} AND FAS_Corp.Code IN('CH53000','CH54000','CH54100')", Carbon::now()->format('Ymd'), Carbon::now()->startOfWeek()->format('Ymd'), Carbon::now()->endOfWeek()->format('Ymd')], Processor::getStorageSql('Board/Marq/record_group_corp.sql'));
}
protected function fetchEntitysCountImplement($flag = 'Erp')
{
$sql = str_replace(['$mdtTime', '$dependLimitTime'], [$this->mdtTime->format('Y-m-d H:i:s'), $this->dependLimitTime->format('Y-m-d H:i:s')], Processor::getStorageSql("FV/Sync/{$this->type}_count.sql"));
return array_get(Processor::getArrayResult($sql, $flag), 0)['_count'];
}
protected function fetchMembers(array $ids)
{
$whereCondition = 'WHERE POS_Member.Code IN(' . sqlInWrap($ids) . ')';
return Processor::getArrayResult(str_replace(['$whereCondition', '$begin', '$end'], [$whereCondition, 0, self::MAX_LIMIT_ROWS], Processor::getStorageSql('FV/Import/member.sql')));
}
protected function fetchMembers(array $chunk)
{
return Processor::getArrayResult(str_replace('$memberCode', sqlInWrap($chunk), Processor::getStorageSql('CTILayout.sql')));
}
protected function getQuery(Carbon $date)
{
// Prevent reference link error
$cloneDate = new Carbon($date->format('Y-m-d H:i:s'));
$pszCurrentYear = $cloneDate->format('Y');
$pszCurrentMonth = $cloneDate->format('m');
$pszCurrentDay = $cloneDate->format('d');
$pszPastYear = $cloneDate->subYear()->format('Y');
$pszTailDate = $pszCurrentMonth . $pszCurrentDay;
$pszPastYearLastDayThisMonth = $cloneDate->modify('last day of this month')->format('d');
return str_replace(['$pszCurrentYear', '$pszCurrentMonth', '$pszCurrentDay', '$pszPastYearLastDayThisMonth', '$pszPastYear', '$pszTailDate'], [$pszCurrentYear, $pszCurrentMonth, $pszCurrentDay, $pszPastYearLastDayThisMonth, $pszPastYear, $pszTailDate], Processor::getStorageSql('RetailSales.sql'));
}
public function fetchTargetCount()
{
$sql = str_replace(['$date', '$serno'], [$this->_getSpecificDateStr(), MemberCode::genSerNoStr(1)], Processor::getStorageSql('FV/Import/list_and_log_target_count.sql'));
return array_get(Processor::getArrayResult($sql), 0)['_count'];
}
