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'];
