$componentClientorder->press_rate_a_id = $pressclientorder['press_rate'][0]['id'];
$componentClientorder->press_rate_a_name = $pressclientorder['press_rate'][0]['name'];
$componentClientorder->press_rate_b_id = $pressclientorder['press_rate'][1]['id'];
$componentClientorder->press_rate_b_name = $pressclientorder['press_rate'][1]['name'];
$componentClientorder->press_rate_a_inks = $pressclientorder['press_rate'][0]['colors'];
$componentClientorder->press_rate_a_machine = $pressclientorder['press_rate'][0]['machine'];
$componentClientorder->press_rate_b_inks = $pressclientorder['press_rate'][1]['colors'];
$componentClientorder->press_rate_b_machine = $pressclientorder['press_rate'][1]['machine'];
$componentClientorder->assigned_user_id = $current_user->id;
$componentClientorder->press_paperwaste_rate_id = $paperclientorder['press_paperwaste_rate']['id'];
$componentClientorder->press_paperwaste_rate_name = $paperclientorder['press_paperwaste_rate']['name'];
$componentClientorder->press_paperwaste_rate_machine = $paperclientorder['press_paperwaste_rate']['machine'];
$componentClientorder->save($GLOBALS['check_notify']);
}
///////////
$clientorderCalc = new ClientorderCalc();
$clientordercalc_id = $focus->get_calc_record($focus->id);
if (!is_null($clientordercalc_id) && !empty($clientordercalc_id)) {
$clientorderCalc->retrieve($clientordercalc_id);
}
$components_clientorder = $clientorderCalc->componentsClientorder($focus->id);
$clientorderCalc->name = $mod_strings['LBL_EST_NAME_PREFIX'] . "-" . $focus->name;
$clientorderCalc->clientorder_name = $focus->name;
$clientorderCalc->clientorder_id = $focus->id;
$clientorderCalc->total_paper = $components_clientorder['total_paper'];
$clientorderCalc->total_prepress = $components_clientorder['total_prepress'];
$clientorderCalc->total_press = $components_clientorder['total_press'];
$clientorderCalc->total_operations = $components_clientorder['total_operations'];
$clientorderCalc->total_clientorder = $components_clientorder['total'];
$clientorderCalc->assigned_user_id = $current_user->id;
$clientorderCalc->status = 'uptodate';
function clientorder_update($id, $close = false)
{
$clientorder_clientorder = new ClientorderCalc();
$components_clientorder = new ComponentClientorder();
$component = new ClientorderComponents();
if (close == true) {
$query = ' UPDATE ' . $clientorder_clientorder->table_name . ' SET status="closed" WHERE clientorder_id="' . $id . '" AND deleted=0 ';
$this->db->query($query, true, "");
} else {
$query = ' SELECT id FROM ' . $clientorder_clientorder->table_name . ' WHERE clientorder_id="' . $id . '" AND deleted=0 ';
$result = $this->db->query($query, true, "");
if ($result != false) {
while ($data = $this->db->fetchByAssoc($result)) {
$clientorder_clientorder->mark_deleted($data['id']);
}
}
}
$query = ' SELECT id FROM ' . $component->table_name . ' WHERE parent_id="' . $id . '" AND deleted=0 ';
$result = $this->db->query($query, true, "");
if ($result != false) {
if (close == true) {
$query = ' UPDATE ' . $component->table_name . ' SET status="closed" WHERE parent_id="' . $id . '" AND deleted=0 ';
$this->db->query($query, true, "");
}
while ($data = $this->db->fetchByAssoc($result)) {
if (close == true) {
$query = ' UPDATE ' . $components_clientorder->table_name . ' SET status="closed" WHERE component_id="' . $data['id'] . '" AND deleted=0 ';
$this->db->query($query, true, "");
} else {
$component->mark_deleted($data['id']);
$query = ' SELECT id FROM ' . $components_clientorder->table_name . ' WHERE component_id="' . $data['id'] . '" AND deleted=0 ';
$result_components_clientorder = $this->db->query($query, true, "");
if ($result_components_clientorder != false) {
while ($data = $this->db->fetchByAssoc($result)) {
$components_clientorder->mark_deleted($data['id']);
}
}
}
}
}
}
