id = $context['id']; $this->status_table = $context['status_table']; $this->status_id = $context['status']; $this->department_id = $context['department_id']; $this->sign_counter = 0; } public function set() { global $database; $id = $this->id; $department_id = $this->department_id; if(!empty($id)) { $request = common_jobs::get_notes($id); $this->sitesurvey_notes = $request['sitesurvey_notes']; $this->qualification_notes = $request['qualification_notes']; $this->production_notes = $request['production_notes']; $this->management_notes = $request['management_notes']; $this->finance_notes = $request['finance_notes']; $this->visualmockup_notes = $request['visualmockup_notes']; } if($_POST['Submit'] == "Save") { $this->sitesurvey_notes =$_POST['sitesurvey_notes']; $this->qualification_notes =$_POST['qualification_notes']; $this->production_notes =$_POST['production_notes']; $this->management_notes =$_POST['management_notes']; $this->finance_notes =$_POST['finance_notes']; $this->visualmockup_notes =$_POST['visualmockup_notes']; } $this->config['sitesurvey_notes'] = array("id"=> $id,"value"=> $this->sitesurvey_notes, "input_name" => "sitesurvey_notes", "name" => "Site Survey Notes","rule" => ""); $this->config['qualification_notes'] = array("id"=> $id,"value"=> $this->qualification_notes, "input_name" => "qualification_notes", "name" => "Qualification Notes","rule" => ""); $this->config['production_notes'] = array("id"=> $id,"value"=> $this->production_notes, "input_name" => "production_notes", "name" => "Production Notes","rule" => ""); $this->config['management_notes'] = array("id"=> $id,"value"=> $this->management_notes, "input_name" => "management_notes", "name" => "Management Notes","rule" => ""); $this->config['finance_notes'] = array("id"=> $id,"value"=> $this->finance_notes, "input_name" => "finance_notes", "name" => "Finance Notes","rule" => ""); $this->config['visualmockup_notes'] = array("id"=> $id,"value"=> $this->visualmockup_notes, "input_name" => "visualmockup_notes", "name" => "Visual Art Mockup Notes","rule" => ""); self::run_validation(); } public function run_validation() { $static_function = (($_POST['Submit'] == "")) ? "initial" : "validate"; $this->validation['sitesurvey_notes'] = validation::$static_function($this->config['sitesurvey_notes']); $this->validation['qualification_notes'] = validation::$static_function($this->config['qualification_notes']); $this->validation['production_notes'] = validation::$static_function($this->config['production_notes']); $this->validation['management_notes'] = validation::$static_function($this->config['management_notes']); $this->validation['finance_notes'] = validation::$static_function($this->config['finance_notes']); $this->validation['visualmockup_notes'] = validation::$static_function($this->config['visualmockup_notes']); $this->reasons = validation::formalise($this->validation); } public function add_notes($context) { $table = $context['table']; $foreign_id = $context['id']; ?>
Add Notes
query($insert); if(($ajax === false) || empty($ajax)) redirect::set(); else { if($query_insert) return true; else return false; } } else { if(($ajax === false) || empty($ajax)) redirect::set(); else return false; } } public function submit_notes_ajax($context) { global $database; $description = mysql_real_escape_string($context['notes_description']); if(!empty($description)) { $ajax = $context['ajax']; $table = $context['table']; $foreign_id = $context['id']; $db_name = $context['db_name']; $submitter = $_SESSION['user']['id']; $current_date_time = date('Y-m-d G:i:s'); $insert = " INSERT INTO $db_name"."logs_notes (`table_name`, `action_type`,`foreign_id` ,`description` ,`date_submitted` ,`submitter`) VALUES('$table','4','$foreign_id','$description','$current_date_time','$submitter')"; $query_insert = $database->query($insert); if($query_insert) return true; else return false; } else { return false; } } public function get_notes() { global $database; $table = $context['table']; $id = $context['id']; $user_db = $context['user_db']; $get_notes = " SELECT qualification_notes,sitesurvey_notes,production_notes,management_notes,finance_notes FROM jobs WHERE id = '$id' LIMIT 1"; $results = $database->getRow($get_notes); $final_results = array(); if(count($results) > 0) { foreach($results AS $result) { $description = nl2br( stripslashes( htmlentities( $result['description'], ENT_QUOTES, 'UTF-8' ) ) ); $submitter = common_users::full_name($result['submitter']); $date = $result['date_submitted']; $id = $result['id']; $date = dates::change_date_time($date); $final_results[] = array( "description" => $description, "submitter" => $submitter, "date" => $date, "id" => $id ); } } ?>
FOR BUSINESS DEVELOPMENT DEPARTMENT USE:
$this->qualification_notes); $validation['qualification_notes'] = array("input_name" => "qualification_notes"); $options['attr'] = array("cols" => 100); ?>

Qualification Notes:

FOR INSTALLATION DEPARTMENT USE:
$this->sitesurvey_notes); $validation['sitesurvey_notes'] = array("input_name" => "sitesurvey_notes"); $options['attr'] = array("cols" => 100); ?>

Site Survey Notes:

DESIGN USE: $this->visualmockup_notes); $validation['visualmockup_notes'] = array("input_name" => "visualmockup_notes"); $options['attr'] = array("cols" => 100); ?>

Visual Art Mockup Notes:

PRODUCTION USE: $this->production_notes); $validation['production_notes'] = array("input_name" => "production_notes"); $options['attr'] = array("cols" => 100); ?>

Production Notes:

FOR MANAGEMENT DEPARTMENT USE: $this->management_notes); $validation['management_notes'] = array("input_name" => "management_notes"); $options['attr'] = array("cols" => 100); ?>

Management Notes:

FOR FINANCE DEPARTMENT USE: $this->finance_notes); $validation['finance_notes'] = array("input_name" => "finance_notes"); $options['attr'] = array("cols" => 100); ?>

Finance Notes:

debug = true; $table = $context['table']; $foreign_id = $context['id']; $db_name = $context['db_name']; $user_db_name = $context['user_db_name']; $results = array(); $get_notes = " SELECT * FROM $db_name"."logs_notes WHERE foreign_id = '$foreign_id' AND table_name = '$table' AND action_type = '4' ORDER BY date_submitted DESC"; $results = $database->getAll($get_notes); $users = common_ref_client::get_all_staff(); if(count($results) > 0) { foreach($results AS $result) { $description = nl2br( stripslashes( htmlentities( $result['description'], ENT_QUOTES, 'UTF-8' ) ) ); $submitter = ''.$users[$result['submitter']]['first_name']." ".$users[$result['submitter']]['last_name'].''; $date = $result['date_submitted']; $id = $result['id']; $date = dates::change_date_time($date); ?>

-

No Notes!

db_name; $id = $this->id; $reasons = "

"; $reasons .= trim($this->reasons); $check_reasons = strip_tags($reasons); $results = false; $sql_string = ""; if($check_reasons == "") { $submitter = $_SESSION['user']['id']; $current_date_time = date('Y-m-d G:i:s'); $qualification_notes = mysql_real_escape_string($_POST['qualification_notes']); $sitesurvey_notes = mysql_real_escape_string($_POST['sitesurvey_notes']); $visualmockup_notes = mysql_real_escape_string($_POST['visualmockup_notes']); $production_notes = mysql_real_escape_string($_POST['production_notes']); $management_notes = mysql_real_escape_string($_POST['management_notes']); $finance_notes = mysql_real_escape_string($_POST['finance_notes']); //$sql_string = "('$qualification_notes','$first','$first_score','$second','$second_score','$third','$third_score','$fourth','$fourth_score','1','$submitter','$current_date_time'), "; } $update = " UPDATE $db_name"."jobs SET qualification_notes = '$qualification_notes', sitesurvey_notes = '$sitesurvey_notes', visualmockup_notes = '$visualmockup_notes', production_notes = '$production_notes', management_notes = '$management_notes', finance_notes = '$finance_notes' WHERE id ='$id' "; $results = $database->query($update); if(!$results) { confirmation::error_temp("Edit Notes ".$reasons); return false; } else { confirmation::success_temp("Edited Notes"); return true; } } } ?>