<?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";
}
if (!empty($valueCondition)) {
$q->ADD_CONDITION($valueCondition);
}
$q->ADD_CONDITION("tdate BETWEEN " . $fromDate . " AND " . $toDate);
if (!empty($searchCondition)) {
$q->ADD_CONDITION($searchCondition);
}
$q->ADD_CONDITION(tbl_transactions::$istransfer . "='0'");
$q->ADD_CONDITION(tbl_transactions::tableName() . "." . tbl_transactions::$store_id . "=" . tbl_stores::tableName() . "." . tbl_stores::getPrimaryKeyField());
$q->ADD_CONDITION(tbl_transactions::tableName() . "." . tbl_transactions::$tag_id . "=" . tbl_tags::tableName() . "." . tbl_tags::getPrimaryKeyField());
//Debug($q->toString());
$results = db::MySqlSubmitQuery($q->toString());
if ($results) {
$resultRow = mysql_fetch_assoc($results);
$total = $resultRow["total"];
$inTotal = $resultRow["inTotal"];
$outTotal = $resultRow["outTotal"];
//reset columns and add paging and sorting
$q->COLUMNS(tbl_transactions::tableName() . "." . tbl_transactions::getPrimaryKeyField() . "," . tbl_transactions::tableName() . "." . tbl_transactions::$tdate . "," . tbl_transactions::tableName() . "." . tbl_transactions::$in_amount . "," . tbl_transactions::tableName() . "." . tbl_transactions::$out_amount . "," . tbl_transactions::tableName() . "." . tbl_transactions::$category . "," . tbl_transactions::tableName() . "." . tbl_transactions::$description . "," . tbl_transactions::tableName() . "." . tbl_transactions::$ttype . "," . tbl_transactions::tableName() . "." . tbl_transactions::$tmonth . "," . tbl_transactions::tableName() . "." . tbl_transactions::$tyear . "," . tbl_transactions::tableName() . "." . tbl_transactions::$tday . "," . tbl_transactions::tableName() . "." . tbl_transactions::$istransfer . "," . tbl_transactions::tableName() . "." . tbl_transactions::$tag_id . "," . tbl_transactions::tableName() . "." . tbl_transactions::$store_id . "," . tbl_stores::tableName() . "." . tbl_stores::$store_name . "," . tbl_tags::tableName() . "." . tbl_tags::$tag_name . "");
$q->ADD_SORT($sortName, $sortOrder);
$q->LIMIT($offset, $recordsPerPage);
Debug($q->toString());
$pagedResults = db::MySqlSubmitQuery($q->toString());
if ($pagedResults) {
while ($row = mysql_fetch_array($pagedResults, MYSQL_ASSOC)) {
$cell = array($row[tbl_transactions::$tdate], $row[tbl_transactions::$in_amount], $row[tbl_transactions::$out_amount], $row[tbl_transactions::$ttype], $row[tbl_transactions::$category], $row[tbl_transactions::$description], $row[tbl_tags::$tag_name], $row[tbl_transactions::$tag_id], $row[tbl_stores::$store_name], $row[tbl_transactions::$store_id]);
array_push($rows, array("id" => $row["id"], "cell" => $cell));
}
}
}
echo json_encode(array(inTotal => $inTotal, outTotal => $outTotal, page => $pageNumber, total => $total . '', rows => $rows));
