library/transactions.inc.php

   1 <?php
   2
   3 function getTransById($id, $cols = "*")
   4 {
   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'];
   9     }
  10
  11     return $row;
  12 }
  13
  14 function getTransByPid($pid, $cols = "*")
  15 {
  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));
  18
  19     $all = [];
  20
  21     for ($iter = 0; $row = sqlFetchArray($res); $iter++) {
  22         $fres = sqlStatement(
  23             "SELECT field_id, field_value FROM lbt_data WHERE form_id = ?",
  24             array($row['id'])
  25         );
  26         while ($frow = sqlFetchArray($fres)) {
  27               $row[$frow['field_id']] = $frow['field_value'];
  28         }
  29
  30         $all[$iter] = $row;
  31     }
  32
  33     return $all;
  34 }
  35
  36 function newTransaction(
  37     $pid,
  38     $body,
  39     $title,
  40     $authorized = "0",
  41     $status = "1",
  42     $assigned_to = "*"
  43 ) {
  44
  45     $body = add_escape_custom($body);
  46     $id = sqlInsert("insert into transactions ( " .
  47     "date, title, pid, user, groupname, authorized " .
  48     ") values ( " .
  49     "NOW(), '$title', '$pid', '" . $_SESSION['authUser'] .
  50     "', '" . $_SESSION['authProvider'] . "', '$authorized' " .
  51     ")");
  52     sqlStatement(
  53         "INSERT INTO lbt_data (form_id, field_id, field_value) VALUES (?, ?, ?)",
  54         array($id, 'body', $body)
  55     );
  56     return $id;
  57 }
  58
  59 function authorizeTransaction($id, $authorized = "1")
  60 {
  61     sqlQuery("update transactions set authorized = ? where " .
  62     "id = ?", array($authorized, $id));
  63 }