public function all_implants()
{
//implant administration
$genModel = model_load_model('generic_model');
$viewData['impAdmin'] = $genModel->get_all_implants();
load_fullview('implant_administration_view', $viewData);
}
/**
* @abstract Emails invoice due reminders at the 7 and 2 day intervals
*/
function email_invoice_reminders()
{
$invoice_model = model_load_model('invoice_model');
$sql = "SELECT *, DATEDIFF(duedate, CURDATE()) AS upcoming FROM invoice WHERE (DATEDIFF(duedate, CURDATE()) = 7 OR DATEDIFF(CURDATE(), duedate) = 2) AND paid = 0 AND remind = 1";
$query = $this->db->query($sql);
if ($query->num_rows() > 0) {
echo "Found {$query->num_rows()} invoices to be mailed.\n";
foreach ($query->result_array() as $row) {
if ($invoice_model->select_email_remain_month($row['company_id'])) {
$message = "This is an automated email reminder that your invoice is due in {$row['upcoming']} days.";
$status = $invoice_model->mail_invoice($row['id'], FALSE, nl2br($message), 'Invoice Reminder', 'Your invoice is due soon.');
echo "Sending Invoice {$row['id']}:\n";
if ($status) {
echo "Success.\n";
} else {
echo "Faulure.\n";
}
} else {
echo "Company {$row['company_id']} has an automated email to send but has ran out of emails.\n";
}
}
} else {
echo "There are no invoices to be sent today.\n";
}
}
function load_basic_model($tablename)
{
$CI =& get_instance();
$basicModel = model_load_model('basic_model');
$basicModel->tablename = $tablename;
return $basicModel;
}
public function all_wastages()
{
$target = 'all_wastages';
$viewData['target'] = $target;
$genModel = model_load_model('generic_model');
$viewData['wastages'] = $genModel->get_report_all_wastages();
load_fullview('reports/report_template', $viewData);
}
public function get_user($search_string = null, $order = null, $order_type = 'DESC', $limit_start = null, $limit_end = null, $wherestatus = null, $user_id)
{
$get_parent_userids = model_load_model('user_role_extended_model')->get_user_role_extended_by_field_array(array("parent_user_id"), array(Access_level::session_user_id()));
$this->db->select('*');
$this->db->from('order');
$this->db->where('user_id', $user_id);
$query = $this->db->get();
return $query->result_array();
}
public function index()
{
$genModel = model_load_model('generic_model');
$viewData['wastage'] = $genModel->get_all_wastage();
$sitesModel = load_basic_model('sites');
$viewData['sites'] = $sitesModel->get();
$batchModel = load_basic_model('drug_batch');
$viewData['batches'] = $batchModel->get();
load_fullview('manage_wastage_view', $viewData);
}
public function index()
{
check_session();
// get user roles
$roleModel = load_basic_model('user_roles');
$viewData['userRoles'] = $roleModel->get();
// get all users
$genModel = model_load_model('generic_model');
$viewData['users'] = $genModel->get_all_users();
load_fullview('user_management_view', $viewData);
}
public function index()
{
$genModel = model_load_model('generic_model');
$viewData['deliveries'] = $genModel->get_all_deliveries();
//get all sites data
$sitesModel = load_basic_model('sites');
$viewData['sites'] = $sitesModel->get();
//get all batch data
$batchModel = load_basic_model('drug_batch');
$viewData['batches'] = $batchModel->get();
load_fullview('manage_delivery_view', $viewData);
}
/**
* Fetch user data from the database
* possibility to mix search, filter and order
* @param string $search_string
* @param strong $order
* @param string $order_type
* @param int $limit_start
* @param int $limit_end
* @return array
*/
public function get_user($search_string = null, $order = null, $order_type = 'DESC', $limit_start = null, $limit_end = null, $wherestatus = null)
{
$get_parent_userids = model_load_model('user_role_extended_model')->get_user_role_extended_by_field_array(array("parent_user_id"), array(Access_level::session_user_id()));
$this->db->select('*');
$this->db->from('user');
$this->db->where('user_type', 'operator');
$parent_ids[] = Access_level::session_user_id();
switch (Access_level::session_user_type()) {
case 'super_admin':
break;
case 'admin':
for ($i = 0; $i < count($get_parent_userids); $i++) {
$parent_ids[] = $get_parent_userids[$i]['user_id'];
}
break;
default:
break;
}
$parent_string = implode(",", $parent_ids);
if (Access_level::session_user_type() != 'super_admin') {
$this->db->where("user_id IN ({$parent_string})");
}
if ($wherestatus != null) {
$this->db->where('status', $wherestatus);
}
//$this->db->order_by('status', 'Active');
if ($search_string) {
if ($order == 'language_interface') {
$this->load->model('site_language_model');
//$language_interface = $this->site_language_model->get_language_by_id();
//$lang = !empty($language_interface[0]['language_longform']) ? $language_interface[0]['language_longform'] : '--';
$this->db->join('site_language', 'user.language_interface = site_language.site_language_id');
$order = 'site_language.language_longform';
}
$this->db->like($order, $search_string);
}
$this->db->group_by('user_id');
if ($order) {
$this->db->order_by($order, $order_type);
} else {
$this->db->order_by('user_id', $order_type);
}
if ($limit_start && $limit_end) {
$this->db->limit($limit_start, $limit_end);
}
if ($limit_start != null) {
$this->db->limit($limit_start, $limit_end);
}
$query = $this->db->get();
return $query->result_array();
}
function site_email($userData)
{
$email_title = config_item('howToUseSite');
$templatesModel = model_load_model('templates_model');
$where_template = array('template_subject' => $email_title);
$templateData = $templatesModel->get($where_template, $single = TRUE);
// @todo: there may be some changes in email of how to use site
// $search = array(
// 'ID', 'TOKEN'
// );
// $replace = array(
// $userData['user_id'], strtotime($userData['user_created'])
// );
// $templateBody = str_replace($search, $replace, $templateData['template_body']);
$email_data = array('from' => config_item('email_from'), 'username' => $userData['user_firstname'], 'subject' => $templateData['template_subject'], 'message' => $templateData['template_body'], 'to' => $userData['user_email']);
$email_result = send_email($email_data);
return $email_result;
}
public function index()
{
//clinicalData
$basicModal = load_basic_model('clinical_data');
$viewData['clinicalData'] = $basicModal->get();
//batchData
$genModel = model_load_model('generic_model');
$viewData['batchData'] = $genModel->get_all_batches();
//deliverires lData
$viewData['deliveries'] = $genModel->get_all_deliveries();
//sites Data
$sitesModal = load_basic_model('sites');
$viewData['sites'] = $sitesModal->get();
//wastage Data
$genModel = model_load_model('generic_model');
$viewData['wastage'] = $genModel->get_all_wastage();
//implant administration
$genModel = model_load_model('generic_model');
$viewData['impAdmin'] = $genModel->get_imp_administrations();
load_fullview('dashboard', $viewData);
}
/**
* @param int $invoice_id The ID of the invoice the email is based on
* @param string $recipient The email address of the recipient
* @param string $message Message text placed inside the HTML invoice
* @param string $email_title The title of the email
* @param string $email_subtitle The subtitle of the email, used in the HTML invoice
* @return bool True if the email was sent properly, False if there was an error
* @abstract Sends an HTML invoice to the recipient. Updates the number of sent emails, generates and attaches a PDF invoice
* @see insert_sent_mail(), generate_pdf()
*/
function mail_invoice($invoice_id, $recipient, $message, $email_title, $email_subtitle = '', $cc_sender)
{
$this->load->library('email');
$company_model = model_load_model('company_model');
$expense_model = model_load_model('expense_model');
$invoice = $this->invoice_model->select_single($invoice_id);
if (!$recipient) {
$recipient = $invoice['client_email'];
}
$data['message'] = $message;
$data['title'] = $email_title;
$data['subtitle'] = $email_subtitle;
$data['invoice'] = $invoice;
$data['company'] = $company_model->select_single($data['invoice']['company_id']);
$data['expenses'] = $expense_model->select_multiple($invoice_id);
if ($invoice['itemize']) {
$data['segments'] = $this->select_segments_by_invoice($invoice_id);
} else {
$data['segments'] = FALSE;
}
$html = $this->load->view('mail_templates/reminder', $data, TRUE);
$pdf_filename = 'system/cache/invoice-' . md5($this->session->userdata('company_id') . '-' . $invoice_id) . '.pdf';
$this->invoice_model->generate_pdf($invoice_id, FALSE, $pdf_filename);
$this->email->initialize(array('mailtype' => 'html', 'useragent' => 'NeoInvoice'));
$this->email->from($this->session->userdata('email'), $this->session->userdata('name'));
$this->email->to($recipient);
$this->email->subject($email_title);
$this->email->message($html);
$this->email->attach($pdf_filename);
$this->invoice_model->insert_sent_email($this->session->userdata('company_id'), $invoice_id, $recipient);
$status = $this->email->send();
if ($status) {
$this->update($invoice_id, array('sent' => 1));
}
if ($cc_sender) {
$this->email->initialize(array('mailtype' => 'html', 'useragent' => 'NeoInvoice'));
$this->email->from($this->session->userdata('email'), $this->session->userdata('name'));
$this->email->to($this->session->userdata('email'));
$this->email->subject($email_title);
$this->email->message($html);
$this->invoice_model->insert_sent_email($this->session->userdata('company_id'), $invoice_id, $recipient);
$this->email->send();
}
$this->email->clear(TRUE);
unlink($pdf_filename);
return $status;
}
public function calculate_implants()
{
$post = $this->input->post(null, TRUE);
$genModel = model_load_model('generic_model');
$result1 = $genModel->get_batch_deliveries($post);
$result2 = $genModel->total_implants_for_batch($post);
$result['deliveries'] = $result1;
$result['total'] = $result2;
echo json_encode($result);
}
