public function upload_contacts($cuf_id = '')
{
$data = array();
$ObjCUF = new contactsUploadedFileModel();
$ObjCUFF = new contactsUploadedFileFieldsModel();
$ObjCUT = new contactsUploadedTempModel();
$ObjContacts = new contactsModel();
$ObjCompanies = new companiesModel();
$loggin_user = $ObjContacts->get_loggin_user_info();
$contact_id = $loggin_user->contact_id;
$where_params = array('`contact_id_assigned`=' => $contact_id);
$order_params = array('ASC' => 'contact_id');
$data['contacts_rows'] = $ObjContacts->get_records($where_params, $order_params);
if ($cuf_id == '') {
$where_params = array('`j1`.`contact_id`=' => $contact_id);
$order_params = array('DESC' => '`j1`.`cuf_id`');
$col = $ObjCUT->get_record_join($where_params, $order_params);
if ($col) {
$cuf_id = $col->cuf_id;
}
}
$data['cuf_id'] = $cuf_id;
if ($cuf_id) {
$data['unmatched_columns'] = $ObjCUFF->get_unmatched_columns($cuf_id);
$where_params = array('`cuf_id`=' => $cuf_id);
$cuf = $ObjCUF->get_record($where_params);
$header_format = $cuf->cuf_header_format;
$data['header_format_unserialize'] = unserialize($header_format);
$file_path = $ObjCUF->base_path . $cuf->cuf_filepath;
//$data['show_upload_contacts_head'] = $ObjCUF->show_upload_contacts_head( $header_format );
//$data['show_upload_contacts_head'] = $ObjCUFF->show_upload_contacts_head( $cuf_id );
$data['show_upload_contacts_header'] = $ObjCUFF->show_upload_contacts_header($cuf_id);
$header_format_rows = $ObjCUFF->get_records(array('`cuf_id`=' => $cuf_id));
$cuff_id_list = $ObjCUFF->get_id_to_list($header_format_rows);
$data['header_format_rows'] = $header_format_rows;
$data['no_column'] = count($header_format_rows);
$data['cuff_id_list'] = $cuff_id_list;
$data['uploaded_contacts_rows'] = $ObjCUT->get_records(array('`cuf_id`=' => $cuf_id), array('ASC' => 'cut_id'));
$data['filepath'] = $file_path;
$where_params = array('`cuf_id`=' => $cuf_id, $this->tblpref . 'error_message<>' => '');
$uploaded_contacts_number_errors = $ObjCUT->get_records($where_params);
$data['uploaded_contacts_number_errors'] = count($uploaded_contacts_number_errors);
}
return View::make('upload_contacts', $data);
}
