$mdb2 = getConnection();
$group_id = (int) $fields['group_id'];
+ $org_id = (int) $fields['org_id'];
$name = $fields['name'];
$address = $fields['address'];
$tax = $fields['tax'];
$tax = str_replace(',', '.', $tax);
if ($tax == '') $tax = 0;
- $sql = "insert into tt_clients (group_id, name, address, tax, projects, status)".
- " values ($group_id, ".$mdb2->quote($name).", ".$mdb2->quote($address).", $tax, ".$mdb2->quote($comma_separated).", ".$mdb2->quote($status).")";
+ $sql = "insert into tt_clients (group_id, org_id, name, address, tax, projects, status)".
+ " values ($group_id, $org_id, ".$mdb2->quote($name).", ".$mdb2->quote($address).", $tax, ".$mdb2->quote($comma_separated).", ".$mdb2->quote($status).")";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
if (count($projects) > 0)
foreach ($projects as $p_id) {
- $sql = "insert into tt_client_project_binds (client_id, project_id) values($last_id, $p_id)";
+ $sql = "insert into tt_client_project_binds (client_id, project_id, group_id, org_id) values($last_id, $p_id, $group_id, $org_id)";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
return false;