public static function logToReceiptRecords($f) { $file_db = new PDO('sqlite:' . $f); $file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $result = $file_db->query('SELECT * FROM transactions;'); $receiptNO = ""; foreach ($result as $m) { $receiptNo = $m["receiptNo"]; } $receiptlines = ReceiptLine::where('receiptNo', $receiptNo)->get(); foreach ($receiptlines as $receiptline) { ReceiptLine::destroy($receiptline->id); } $receiptRecords = Receiptrecord::where(['receiptNo' => $receiptNo, 'progress' => '提供済み'])->get(); foreach ($receiptRecords as $receiptRecord) { $receiptRecord->payment_id = $m['payment_id']; $receiptRecord->progress = "支払い済み"; $receiptRecord->save(); } $file_db = new PDO('sqlite:' . $f); $file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $result = $file_db->query('SELECT * FROM payments;'); foreach ($result as $m) { $payment = new Payment(); $payment->price = $m["price"]; $payment->payment = $m["payment"]; $payment->changes = $m["changes"]; $payment->time = $m["time"]; $payment->uuid = $m["uuid"]; $payment->shopName = $m["shopName"]; $payment->employeeName = $m["employeeName"]; $payment->save(); } // unlink($f); }
/** * Remove the specified receiptline from storage. * * @param int $id * @return Response */ public function destroy($id) { ReceiptLine::destroy($id); return Redirect::route('receipt_lines.index'); }
public function clear() { Datafromio::truncate(); ReceiptLine::truncate(); return Redirect::route('dataFromIOs.index'); }
<?php include "system.php"; include_once '../simbiz/class/Receipt.php'; include_once '../simbiz/class/ReceiptLine.php'; include_once "../simantz/class/datepicker/class.datepicker.php"; include_once '../simantz/class/Currency.inc.php'; $cur = new Currency(); //include_once "../system/class/Period.php"; $dp = new datepicker($url); $dp->dateFormat = 'Y-m-d'; error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $o = new Receipt(); $pl = new ReceiptLine(); $s = new XoopsSecurity(); $orgctrl = ""; $action = ""; $o->receipt_id = 0; if (isset($_POST['action'])) { $action = $_POST['action']; $o->receipt_id = $_POST["receipt_id"]; } elseif (isset($_GET['action'])) { $action = $_GET['action']; $o->receipt_id = $_GET["receipt_id"]; } else { $action = ""; } $token = $_POST['token']; $o->paidto = $_POST["paidto"]; $iscomplete = $_POST['iscomplete']; $o->organization_id = $_POST['organization_id'];