3 function getTransById($id, $cols = "*")
5 $row = sqlQuery("SELECT " . escape_sql_column_name(process_cols_escape($cols), array('transactions')) . " FROM transactions WHERE id = ?", array($id));
6 $fres = sqlStatement("SELECT field_id, field_value FROM lbt_data WHERE form_id = ?", array($id));
7 while ($frow = sqlFetchArray($fres)) {
8 $row[$frow['field_id']] = $frow['field_value'];
14 function getTransByPid($pid, $cols = "*")
16 $res = sqlStatement("select " . escape_sql_column_name(process_cols_escape($cols), array('transactions')) . " from transactions where pid = ? " .
17 "order by date DESC", array($pid));
21 for ($iter = 0; $row = sqlFetchArray($res); $iter++
) {
23 "SELECT field_id, field_value FROM lbt_data WHERE form_id = ?",
26 while ($frow = sqlFetchArray($fres)) {
27 $row[$frow['field_id']] = $frow['field_value'];
36 function newTransaction(
45 $body = add_escape_custom($body);
46 $id = sqlInsert("insert into transactions ( " .
47 "date, title, pid, user, groupname, authorized " .
49 "NOW(), '$title', '$pid', '" . $_SESSION['authUser'] .
50 "', '" . $_SESSION['authProvider'] . "', '$authorized' " .
53 "INSERT INTO lbt_data (form_id, field_id, field_value) VALUES (?, ?, ?)",
54 array($id, 'body', $body)
59 function authorizeTransaction($id, $authorized = "1")
61 sqlQuery("update transactions set authorized = ? where " .
62 "id = ?", array($authorized, $id));