$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")