StartTrans(); common_materials::update_quote_materials($actual,$id); $sql = " SELECT actual_used,quote_id,materials FROM quotes_materials WHERE id = '$id' "; list($total,$quote_id,$material_name) = $database->getRow($sql); $get_job_id = " SELECT id FROM jobs WHERE quote_id = '$quote_id' "; $job_id = $database->getOne($get_job_id); $quotes_materials_desc = mysql_escape_string("Added ".$material_name." x $actual"); logs::submit_logs(array("table" => "quotes_materials", "action_type" => 2,"foreign_id" => $id, "description" => $actual)); logs::submit_logs(array("table" => "jobs", "action_type" => 10,"foreign_id" => $job_id, "description" => "Updated Material Used - ".$quotes_materials_desc)); $result = $database->CompleteTrans(); $status = false; if($result) $status = true; else $status = false; $results = array("status" => $status, "response" => $total); $json = json_encode($results); echo $json; ?>