$year = $d->format("Y");
$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());
<?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";
}
$date_year = "Y";
$date_month = "m";
$date_day = "d";
$transactionType = $_POST["transactionsType"];
$filename = $_FILES["file"]["tmp_name"];
$delimiter = ",";
Debug("File type is '" . $transactionType . "'");
if ($_FILES["file"]["error"] > 0) {
echo "Error: " . $_FILES["file"]["error"] . "<br>";
} else {
Debug("Upload: " . $_FILES["file"]["name"]);
Debug("Type: " . $_FILES["file"]["type"]);
Debug("Size: " . $_FILES["file"]["size"] / 1024 . " kB");
Debug("Stored in: " . $filename);
try {
$insertQuery = new MySqlInsert();
$insertQuery->INTO(tbl_transactions::tableName());
$insertQuery->COLUMNS(array(tbl_transactions::$tdate, tbl_transactions::$in_amount, tbl_transactions::$out_amount, tbl_transactions::$category, tbl_transactions::$description, tbl_transactions::$ttype, tbl_transactions::$tmonth, tbl_transactions::$tyear, tbl_transactions::$tday));
if (($handle = fopen($filename, 'r')) !== FALSE) {
while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) {
$record_date = "";
$record_in_amount = "";
$record_out_amount = "";
$record_category = "";
$record_description = "";
$record_type = "";
$record_month = "";
$record_year = "";
$record_day = "";
if ($transactionType == db_enum_ttype::c_visa) {
//("date", "description", "value")
