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']; }