public static function showtransfer($f) { $file_db = new PDO('sqlite:' . $f); $file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $result = $file_db->query('SELECT * FROM transfer;'); /* 1. Clear all old data of receiptlines before sending to clien 2. Datafromio when deleted, set it to receipt line */ foreach ($result as $m) { $r = new Receiptrecord(); $r->tantoID = $m["tantoID"]; $r->goodsTitle = $m["goodsTitle"]; $r->kosu = $m["kosu"]; $r->orderTime = $m["time"]; $r->receiptNo = $m["receiptNo"]; $r->tableNO = $m["tableNO"]; $r->progress = "受注済み"; $r->price = 0; $r->serveTime = ""; $r->paymentTime = ""; $r->payment_id = 0; $r->save(); } $file_db = new PDO('sqlite:' . $f); $file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $result = $file_db->query('SELECT * FROM transfer;'); foreach ($result as $m) { $d = new Datafromio(); $d->tanto = $m["tantoID"]; $d->goodsTitle = $m["goodsTitle"]; $d->kosu = $m["kosu"]; $d->time = $m["time"]; $d->receiptNo = $m["receiptNo"]; $d->tableNO = $m["tableNO"]; $d->save(); } unlink($f); }
public function clear() { Datafromio::truncate(); ReceiptLine::truncate(); return Redirect::route('dataFromIOs.index'); }