public static function save(DB $db, Purchase $p)
{
$stmt = $db->prepare('
UPDATE `purchases`
SET `currency_amount` = :currency_amount,
`bitcoin_amount` = :bitcoin_amount,
`txid` = :txid,
`ntxid` = :ntxid,
`status` = :status,
`message` = :message,
`notice` = :notice,
`email_to_notify` = :email_to_notify
WHERE `id` = :id
');
$result = $stmt->execute(array(':id' => $p->getId(), ':currency_amount' => $p->getCurrencyAmount(), ':bitcoin_amount' => $p->getBitcoinAmount(), ':txid' => $p->getTXID(), ':ntxid' => $p->getNTXID(), ':message' => $p->getMessage(), ':notice' => $p->getNotice(), ':status' => $p->getStatus(), ':email_to_notify' => $p->getEmailToNotify()));
return $result;
}
public function executeDsrmulti(sfWebRequest $request)
{
$requestparams = $request->getParameter("invoice");
$day = $requestparams["date"]["day"];
$month = $requestparams["date"]["month"];
$year = $requestparams["date"]["year"];
$invoice = new Invoice();
if (!$day or !$month or !$year) {
$invoice->setDate(MyDate::today());
} else {
$invoice->setDate($year . "-" . $month . "-" . $day);
}
$requestparams = $request->getParameter("purchase");
$day = $requestparams["date"]["day"];
$month = $requestparams["date"]["month"];
$year = $requestparams["date"]["year"];
$purchase = new Purchase();
if (!$day or !$month or !$year) {
$purchase->setDate(MyDate::today());
} else {
$purchase->setDate($year . "-" . $month . "-" . $day);
}
$this->form = new InvoiceForm($invoice);
$this->toform = new PurchaseForm($purchase);
$this->purchases = PurchaseTable::fetchByDateRange($invoice->getDate(), $purchase->getDate());
$this->events = EventTable::fetchByDatenParentclass($purchase->getDate(), "Purchase");
$this->cashsales = 0;
$this->chequesales = 0;
$this->creditsales = 0;
$this->cashother = 0;
$this->chequeother = 0;
$this->creditother = 0;
$this->cashtotal = 0;
$this->chequetotal = 0;
$this->credittotal = 0;
$this->deducttotal = 0;
foreach ($this->purchases as $purchase) {
if ($purchase->getStatus() != "Cancelled") {
$this->cashsales += $purchase->getCash();
$this->chequesales += $purchase->getCheque();
$this->creditsales += $purchase->getCredit();
$this->cashtotal += $purchase->getCash();
$this->chequetotal += $purchase->getCheque();
$this->credittotal += $purchase->getCredit();
//$this->deducttotal+=$purchase->getDsrdeduction();
}
}
foreach ($this->events as $event) {
$purchase = $event->getParent();
if ($purchase->getStatus() != "Cancelled") {
$this->cashother += $event->getDetail("cashamt");
$this->chequeother += $event->getDetail("chequeamt");
$this->creditother += $event->getDetail("creditamt");
$this->cashtotal += $event->getDetail("cashamt");
$this->chequetotal += $event->getDetail("chequeamt");
$this->credittotal += $event->getDetail("creditamt");
$this->deducttotal += $event->getDetail3();
}
}
$this->total = $this->cashtotal + $this->chequetotal + $this->credittotal;
}
