$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']); } } } } } }