$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) {
db::MySqlSubmitTransaction(array($update->toString(), $insert->toString()));
} else {
db::MySqlSubmitQuery($update->toString());
}
echo "Success.";
} catch (Exception $e) {
$updateStore->TABLE(tbl_transactions::tableName());
$updateStore->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$store_id, $value["id"]);
$updateStore->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$tag_id, $value["default_tag_id"]);
$updateStore->ADD_CONDITION(alphaNumericLowerMySql(tbl_transactions::$description) . " LIKE '%" . alphaNumericLower($value["name"]) . "%'");
//$updateStore->ADD_CONDITION(tbl_transactions::$in_amount . "=0");
$updateStore->ADD_CONDITION(tbl_transactions::$istransfer . "=0");
$updateStore->ADD_CONDITION(tbl_transactions::$store_id . "='" . db_cache_store::$_none["id"] . "'");
db::MySqlSubmitQuery($updateStore->toString());
}
}
echo 'tagging complete. ';
} else {
if (!is_null($_GET["reset-tagging"])) {
//reset all tags to other
$resetTag = new MySqlUpdate();
$resetTag->TABLE(tbl_transactions::tableName());
$resetTag->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$tag, db_enum_tag::c_none);
$resetTag->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$store_id, db_cache_store::$_none["id"]);
$resetTag->ADD_COLUMN_VALUE_PAIR(tbl_transactions::$istransfer, "0");
db::MySqlSubmitQuery($resetTag->toString());
echo 'tag reset complete.';
}
}
function alphaNumericLower($text)
{
return strtolower(str_ireplace('\'', '', str_ireplace('#', '', str_ireplace('(', '', str_ireplace(')', '', str_ireplace('-', '', str_ireplace(' ', '', trim($text))))))));
}
function alphaNumericLowerMySql($fieldName)
{
return 'LOWER(REPLACE(REPLACE(REPLACE(REPLACE(' . $fieldName . ', " ", ""),"-",""),"#",""),"\'",""))';
}
