/**
  * Returns a new ChildCreditPaymentQuery object.
  *
  * @param     string $modelAlias The alias of a model in the query
  * @param     Criteria $criteria Optional Criteria to build the query from
  *
  * @return ChildCreditPaymentQuery
  */
 public static function create($modelAlias = null, Criteria $criteria = null)
 {
     if ($criteria instanceof ChildCreditPaymentQuery) {
         return $criteria;
     }
     $query = new ChildCreditPaymentQuery();
     if (null !== $modelAlias) {
         $query->setModelAlias($modelAlias);
     }
     if ($criteria instanceof Criteria) {
         $query->mergeWith($criteria);
     }
     return $query;
 }
Exemple #2
0
        window.close();
    }, 10)
</script>
<body>
<?php 
$credit = CreditQuery::create()->filterByStatus('Active')->filterById($id)->useSalesQuery()->leftJoin('SecondParty')->withColumn('SecondParty.Id', 'second_party_id')->withColumn('SecondParty.Name', 'second_party_name')->withColumn('Sales.Date', 'date')->endUse()->select(array('id', 'sales_id', 'total', 'second_party_id', 'second_party_name', 'date'))->findOne($con);
if (!$credit) {
    throw die('Data tidak ditemukan.');
}
$credit = (object) $credit;
$payment = CreditPaymentQuery::create()->filterByStatus('Active')->filterByCreditId($credit->id)->withColumn('SUM(Paid)', 'total_paid')->select(array('total_paid'))->findOne($con);
$credit->paid = $payment;
$credit->balance = $credit->total - $credit->paid;
$credit->status = $credit->balance <= 0 ? 'Lunas' : $credit->balance;
$credit->cash_back = $credit->balance < 0 ? abs($credit->balance) : '-';
$creditPayments = CreditPaymentQuery::create()->filterByStatus('Active')->filterByCreditId($id)->leftJoin('Cashier')->withColumn('Cashier.Id', 'cashier_id')->withColumn('Cashier.Name', 'cashier_name')->select(array('id', 'date', 'paid', 'cashier_name'))->orderBy('date', 'ASC')->find($con);
?>

<div style="font-weight: bold; font-size: 15px; text-align: center;">
    <?php 
echo $info->client_name;
?>
</div>
<div style="text-align: center;"><?php 
echo $info->client_address;
?>
. Telp <?php 
echo $info->client_phone;
?>
</div>
Exemple #3
0
 /**
  * If this collection has already been initialized with
  * an identical criteria, it returns the collection.
  * Otherwise if this UserDetail is new, it will return
  * an empty collection; or if this UserDetail has previously
  * been saved, it will retrieve related CreditPayments from storage.
  *
  * This method is protected by default in order to keep the public
  * api reasonable.  You can provide public methods for those you
  * actually need in UserDetail.
  *
  * @param      Criteria $criteria optional Criteria object to narrow the query
  * @param      ConnectionInterface $con optional connection object
  * @param      string $joinBehavior optional join type to use (defaults to Criteria::LEFT_JOIN)
  * @return ObjectCollection|ChildCreditPayment[] List of ChildCreditPayment objects
  */
 public function getCreditPaymentsJoinCredit(Criteria $criteria = null, ConnectionInterface $con = null, $joinBehavior = Criteria::LEFT_JOIN)
 {
     $query = ChildCreditPaymentQuery::create(null, $criteria);
     $query->joinWith('Credit', $joinBehavior);
     return $this->getCreditPayments($query, $con);
 }
 /**
  * Performs an INSERT on the database, given a CreditPayment or Criteria object.
  *
  * @param mixed               $criteria Criteria or CreditPayment object containing data that is used to create the INSERT statement.
  * @param ConnectionInterface $con the ConnectionInterface connection to use
  * @return mixed           The new primary key.
  * @throws PropelException Any exceptions caught during processing will be
  *                         rethrown wrapped into a PropelException.
  */
 public static function doInsert($criteria, ConnectionInterface $con = null)
 {
     if (null === $con) {
         $con = Propel::getServiceContainer()->getWriteConnection(CreditPaymentTableMap::DATABASE_NAME);
     }
     if ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
         // rename for clarity
     } else {
         $criteria = $criteria->buildCriteria();
         // build Criteria from CreditPayment object
     }
     if ($criteria->containsKey(CreditPaymentTableMap::COL_ID) && $criteria->keyContainsValue(CreditPaymentTableMap::COL_ID)) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . CreditPaymentTableMap::COL_ID . ')');
     }
     // Set the correct dbName
     $query = CreditPaymentQuery::create()->mergeWith($criteria);
     // use transaction because $criteria could contain info
     // for more than one table (I guess, conceivably)
     return $con->transaction(function () use($con, $query) {
         return $query->doInsert($con);
     });
 }
Exemple #5
0
 public static function readPayment($params, $currentUser, $con)
 {
     // check role's permission
     $permission = RolePermissionQuery::create()->select('read_credit')->findOneById($currentUser->role_id, $con);
     if (!$permission || $permission != 1) {
         throw new \Exception('Akses ditolak. Anda tidak mempunyai izin untuk melakukan operasi ini.');
     }
     $page = isset($params->page) ? $params->page : 0;
     $limit = isset($params->limit) ? $params->limit : 100;
     $creditPayments = CreditPaymentQuery::create()->filterByStatus('Active')->leftJoin('Cashier')->withColumn('Cashier.Name', 'cashier_name')->useCreditQuery()->useSalesQuery()->leftJoin('SecondParty')->withColumn('SecondParty.Id', 'second_party_id')->withColumn('SecondParty.Name', 'second_party_name')->endUse()->endUse();
     if (isset($params->credit_id)) {
         $creditPayments->filterByCreditId($params->credit_id);
     }
     if (isset($params->second_party)) {
         $creditPayments->useCreditQuery()->useSalesQuery()->useSecondPartyQuery()->filterByName('%' . $params->second_party . '%')->endUse()->endUse()->endUse();
     }
     if (isset($params->start_date)) {
         $creditPayments->filterByDate(array('min' => $params->start_date));
     }
     if (isset($params->until_date)) {
         $creditPayments->filterByDate(array('max' => $params->until_date));
     }
     $creditPayments = $creditPayments->select(array('id', 'date', 'credit_id', 'paid', 'cashier_id', 'cashier_name', 'second_party_id', 'second_party_name'));
     foreach ($params->sort as $sorter) {
         $creditPayments->orderBy($sorter->property, $sorter->direction);
     }
     $creditPayments->orderBy('id', 'DESC');
     $creditPayments = $creditPayments->paginate($page, $limit);
     $total = $creditPayments->getNbResults();
     $data = [];
     foreach ($creditPayments as $creditPayment) {
         $data[] = $creditPayment;
     }
     $results['success'] = true;
     $results['data'] = $data;
     $results['total'] = $total;
     return $results;
 }
Exemple #6
0
 /**
  * Removes this object from datastore and sets delete attribute.
  *
  * @param      ConnectionInterface $con
  * @return void
  * @throws PropelException
  * @see CreditPayment::setDeleted()
  * @see CreditPayment::isDeleted()
  */
 public function delete(ConnectionInterface $con = null)
 {
     if ($this->isDeleted()) {
         throw new PropelException("This object has already been deleted.");
     }
     if ($con === null) {
         $con = Propel::getServiceContainer()->getWriteConnection(CreditPaymentTableMap::DATABASE_NAME);
     }
     $con->transaction(function () use($con) {
         $deleteQuery = ChildCreditPaymentQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
         $ret = $this->preDelete($con);
         if ($ret) {
             $deleteQuery->delete($con);
             $this->postDelete($con);
             $this->setDeleted(true);
         }
     });
 }