protected function fetchMembersCount() { $lowerSerno = MemberCode::genSerNoStr($this->getCondition()['serno']); $upperSerno = MemberCode::genSerNoStr($this->getCondition()['upserno']); return array_get(Processor::getArrayResult("SELECT COUNT(*) AS _count FROM POS_Member WITH(NOLOCK) WHERE POS_Member.SerNo >= '{$lowerSerno}' AND POS_Member.SerNo <= '{$upperSerno}'"), 0)['_count']; }
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']; }