<?php /* Code to save a new store to the database. */ require_once "include_files.php"; $storeName = $_POST["sname"]; $storeDefaultTag = $_POST["stag"]; if ($storeName && $storeDefaultTag) { $insertStore = new MySqlInsert(); $insertStore->INTO(tbl_stores::tableName()); $insertStore->COLUMNS(array(tbl_stores::$store_name, tbl_stores::$default_tag_id)); $insertStore->ADD_ROW(array($storeName, $storeDefaultTag)); db::MySqlSubmitQuery($insertStore->toString()); echo "Store '" . $storeName . "' added successfully."; } else { echo "Empty or Invalid Store name '" . $storeName . "' provided"; }
$month = $d->format("m"); $day = $d->format("d"); $in2 = $_POST[tbl_transactions::$in_amount . "2"]; $out2 = $_POST[tbl_transactions::$out_amount . "2"]; $cat2 = $_POST[tbl_transactions::$category . "2"]; $desc2 = $_POST[tbl_transactions::$description . "2"]; $tag2 = $_POST[tbl_transactions::$tag_id . "2"]; $store2 = $_POST[tbl_transactions::$store_id . "2"]; if ($in + $in2 != $originalIn) { throw new Exception("new amounts are not equal to original total amount of '" . $originalIn . "'"); } if ($out + $out2 != $originalOut) { throw new Exception("new amounts are not equal to original total amount of '" . $originalOut . "'"); } $insert = new MySqlInsert(); $insert->INTO(tbl_transactions::tableName()); $insert->COLUMNS(array(tbl_transactions::$tdate, tbl_transactions::$in_amount, tbl_transactions::$out_amount, tbl_transactions::$category, tbl_transactions::$description, tbl_transactions::$ttype, tbl_transactions::$tyear, tbl_transactions::$tmonth, tbl_transactions::$tday, tbl_transactions::$tag_id, tbl_transactions::$store_id)); $insert->ADD_ROW(array($date, $in2, $out2, $cat2, $desc2, $type, $year, $month, $day, $tag2, $store2)); Debug($insert->toString()); } $update = new MySqlUpdate(); $update->TABLE(tbl_transactions::tableName()); $update->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$in_amount, $in); $update->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$out_amount, $out); $update->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$category, $cat); $update->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$description, $desc); $update->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$tag_id, $tag); $update->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$store_id, $store); $update->ADD_CONDITION(tbl_transactions::getPrimaryKeyField() . "=" . $id); Debug($update->toString()); if ($insert) {