- // insert - inserts an invoice in database.
- static function insert($fields)
- {
- $mdb2 = getConnection();
-
- $team_id = (int) $fields['team_id'];
- $name = $fields['name'];
- if (!$name) return false;
-
- $client_id = (int) $fields['client_id'];
- $date = $fields['date'];
- if (array_key_exists('status', $fields)) { // Key exists and may be NULL during migration of data.
- $status_f = ', status';
- $status_v = ', '.$mdb2->quote($fields['status']);
- }
-
- // Insert a new invoice record.
- $sql = "insert into tt_invoices (team_id, name, date, client_id $status_f)
- values($team_id, ".$mdb2->quote($name).", ".$mdb2->quote($date).", $client_id $status_v)";
- $affected = $mdb2->exec($sql);
-
- if (is_a($affected, 'PEAR_Error')) return false;
-
- $last_id = 0;
- $sql = "select last_insert_id() as last_insert_id";
- $res = $mdb2->query($sql);
- $val = $res->fetchRow();
- $last_id = $val['last_insert_id'];
-
- return $last_id;
- }
-