phalcon count統計

單表count:

多表count:

$result = $this->modelsManager->createBuilder()

->columns("SysContractWarn.con_warn_id")

->from("SysCustomer")

->join("SysContract","SysCustomer.cus_id = SysContract.cus_id")

->join("SysContractWarn","SysContract.con_id = SysContractWarn.con_id")

->where($where." AND SysCustomer.serv_status = 0 AND SysContractWarn.rmk_del = 0",array("manId"=>$man->man_id))

->getQuery()

->execute()

->count();