Exemple #1
0
        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) {
    echo $e->getMessage();
}
Exemple #2
0
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));