PHP Opifer\Imuis\Criteria Criteria::setTable Examples

Example #1

File: Client.php Project: opifer/imuis

 /**
  * Get balance by creditor & invoice
  *
  * @param integer $creditorNo
  * @param integer $invoiceNo
  *
  * @return bool|float
  */
 public function getBalanceByInvoice($creditorNo, $invoiceNo)
 {
     $criteria = new Criteria();
     $criteria->setTable('CREOPP')->setSelect('SALDO')->setWheres("FACT\tCRE")->setOperators("=\t=")->setValues(sprintf("%s\t%s", $invoiceNo, $creditorNo))->setOrderBy('SALDO')->setMaxResults(0)->setPageSize(1)->setPage(1);
     $response = $this->getResults($criteria);
     $data = json_decode(json_encode($response->getData()));
     return isset($data->DATA->SALDO) ? (double) $data->DATA->SALDO : false;
 }