示例#1
0
 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'];
 }
示例#2
0
 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'];
 }