ikan Uploader :
Directory : /var/www/html/shardahospital.org/pdms/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/pdms/application/models/Home_Model.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
Class Home_Model extends CI_Model{
/*
* Function : getAllRecords
*/
public function getAllRecords($tbl_name, $col = ' * ', $condition=null, $order_by = NULL,$limit=NULL, $start=NULL, $likeSearch=null, $betweenDate=null)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$this->db->where("DATE_FORMAT($tbl_name.createdon,'%Y-%m-%d') >='$from_date'");
$this->db->where("DATE_FORMAT($tbl_name.createdon,'%Y-%m-%d') <='$to_date'");
}
if(!empty($likeSearch))
{ $k=1;
$multiLike = array();
foreach($likeSearch as $key=>$val) {
$str = "";
$str = str_replace(" ","|", $val);
$multiLike[] = " $key rlike '".$str."' ";
}
$lwhere = '';
$lwhere = implode(' OR ', $multiLike);
$likewhere = '( '.$lwhere.' )';
$this->db->where($likewhere);
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
if ($limit !== null && $start !== null) {
$query = $this->db->get($tbl_name,$limit, $start);
} else {
$query = $this->db->get($tbl_name);
}
//echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function : deleteRecord
*/
function deleteRecord($tbl_name = 'tbl_user_registration', $field = '', $uid = ''){
$this->db->where($field,$uid);
if($this->db->delete($tbl_name)){
return true;
}else{
return false;
}
}
/*
* Function : getAllModuleList
*/
public function getAllModuleList($tbl_name, $col = ' * ', $condition=null, $where_in=NULL, $where_key = 'id')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
$this->db->where_in($where_key, $where_in);
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
//$this->db->order_by('display_order', 'asc');
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function : getSingleRecord
*/
public function getSingleObjRecord($tbl_name, $col = ' * ', $condition=null)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->row();
}
/*
* Function : getSingleRecord
*/
public function getSingleRecord($tbl_name, $col = ' * ', $condition=null)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if(!empty($val)){
$this->db->where($key, $val);
}
}
}
$this->db->order_by('id', 'desc');
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->row_array();
}
/*
* Function : updatefeedbackCount
*/
public function updatefeedbackCount($myslag = '')
{
$result = '';
if($myslag!=''){
$result = $this->db->query("UPDATE tbl_pdms_ip_patient_info SET feedback_count = feedback_count + 1 WHERE slag_id = $myslag");
}
return $result;
}
/*
* Function : registrationCount
*/
public function registrationCount($tbl_name = 'patient_registration')
{
$result = $this->db->query("SELECT id FROM ".$tbl_name." where is_deleted='0'");
return $result->num_rows();
}
/*
* Function : countrylist
*/
public function countrylist($tbl_name = 'su_country', $col = ' * ')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
$this->db->order_by('country_name', 'asc');
$query = $this->db->get($tbl_name);
return $query->result_array();
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'tbl_schools', $col = ' * ', $condition='',$order_by = NULL)
{
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
if(!empty($order_by))
{
foreach($order_by as $key=>$val) {
$this->db->order_by($key,$val);
}
}
$query = $this->db->get($tbl_name);
return $query->result_array();
}
public function saveinfo($tbl_name='', $post)
{
$this->db->insert($tbl_name, $post);
//echo $this->db->last_query(); die;
return $this->db->insert_id();
}
public function updateinfo($tbl_name='', $post, $field, $value)
{
$this->db->where($field, $value);
if (!$this->db->update($tbl_name, $post)) {
log_message('error', print_r($this->db->error(), true));
}
//echo $this->db->last_query(); die;
return $value;
//echo $this->db->last_query(); die;
}
public function updatePaymentinfo($tbl_name='', $post, $cond= '')
{
if(!empty($cond)){
foreach($cond as $key=>$val) {
$this->db->where($key, $val);
}
}
if (!$this->db->update($tbl_name, $post)) {
log_message('error', print_r($this->db->error(), true));
}
return $value;
//echo $this->db->last_query(); die;
}
/*
* Function: getAllbookingRecords
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getAllbookingRecords($id='', $condition = '')
{
$this->db->select('tbl_user_registration.*,tbl_booking_confirmation.id as bid,tbl_booking_confirmation.test_id, tbl_booking_confirmation.slot_id, tbl_booking_confirmation.slot_date, tbl_booking_confirmation.payment_method, tbl_booking_confirmation.ip_address,order_id,tbl_booking_confirmation.address,tbl_booking_confirmation.pincode');
$this->db->join('tbl_user_registration', 'tbl_user_registration.id = tbl_booking_confirmation.user_id');
if($id>0){
$this->db->where('tbl_booking_confirmation.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->like($key, $val);
}
}
$this->db->where('tbl_booking_confirmation.is_deleted', '0');
$query = $this->db->get('tbl_booking_confirmation');
//echo $this->db->last_query();die;
if($id>0){
return $query->row_array();
} else {
return $query->result_array();
}
}
/*
* Function: getSingleEventDetails
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getSingleEventDetails($id='', $condition = '')
{
$this->db->select('tbl_event_master.*, tbl_schools.school_name,tbl_event_date_time.start_date,tbl_event_date_time.start_time, tbl_event_date_time.end_date,tbl_event_date_time.end_time,tbl_event_date_time.time_zone,tbl_event_location_details.venue_name,tbl_event_organizer_contactinfo.contact_name,tbl_event_organizer_contactinfo.phone,tbl_event_organizer_contactinfo.email,tbl_event_organizer_contactinfo.website_url');
$this->db->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$this->db->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
$this->db->join('tbl_event_organizer_contactinfo', 'tbl_event_organizer_contactinfo.event_id = tbl_event_master.id', 'left');
$this->db->join('tbl_event_location_details', 'tbl_event_location_details.event_id = tbl_event_master.id', 'left');
if($id>0){
$this->db->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->like($key, $val);
}
}
$this->db->where('tbl_event_master.is_deleted', '0');
$this->db->where('tbl_event_master.status', '4');
$query = $this->db->get('tbl_event_master');
//echo $this->db->last_query();die;
return $query->row_array();
}
/*
* Function : getAllCategoryList
*/
public function getAllCategoryList()
{
$this->db->select("count(tbl_event_master.id) as total, tbl_category.category_name ");
$this->db->join('tbl_event_master', 'tbl_event_master.categories = tbl_category.id', 'left');
$this->db->where('tbl_category.is_deleted', '0');
$this->db->where('tbl_category.status', '1');
$this->db->group_by('category_name');
$this->db->having('count(tbl_event_master.id)>', 0);
$this->db->limit('20');
$query = $this->db->get('tbl_category');
//echo $this->db->last_query();die;
return $query->result_array();
}
/*
* Function : getAllTagList
*/
public function getAllTagList()
{
$this->db->select('count(tbl_event_master.id) as total, tbl_tags.tag_name');
$this->db->join('tbl_event_master', 'tbl_event_master.tags = tbl_tags.id', 'left');
$this->db->where('tbl_tags.is_deleted', '0');
$this->db->where('tbl_tags.status', '1');
$this->db->group_by('tag_name');
$this->db->having('count(tbl_event_master.id)>', 0);
$this->db->limit('20');
$query = $this->db->get('tbl_tags');
//echo $this->db->last_query();die;
return $query->result_array();
}
/*
* Function : send_email_pepipost
*/
function send_email_pepipost($to_emails, $subject, $message, $fromname='', $fromemail='', $replyto='')
{
$fromname=$fromname?$fromname:'Sharda Hospital';
$fromemail=$fromemail?$fromemail:'enquiry@shardahospital.org'; //'info@shardauniversity.com';
$replyto=$replyto?$replyto:'enquiry@shardahospital.org'; //'info@shardauniversity.com';
if(!$to_emails){
return;
}
if(is_string($to_emails)){
$to_emails=explode(",", $to_emails);
}
foreach($to_emails as $to){
$d=array (
'personalizations' => array (0 => array ('recipient' => $to)),
'from' => array ('fromEmail' => $fromemail, 'fromName' => $fromname),
'replyToId'=>$replyto,
'subject' => $subject,
'content' => $message,
);
$email_jason_data=json_encode($d);
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => "https://api.pepipost.com/v2/sendEmail",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => $email_jason_data,
CURLOPT_HTTPHEADER => array(
//"api_key: c77184012dcf9bd5cd1886b4e0a2bb89",
"api_key: aab3f77715e90569034f0c6e5d912714",
"content-type: application/json"
),
));
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
//echo "cURL Error #:" . $err;
} else {
//echo $response;
}
}
}
/*
* Function : import_user
*
*/
public function import_user($userDataArray, $logged_in)
{
//echo "<pre>"; print_r($logged_in);exit;
$counter = 0;
foreach($userDataArray as $key => $row){
if($key != 0 && $row['0']!='')
{
echo "<pre>";print_r($row);
$employee_id= $row['0'];
$first_name= $row['1'];
$first_name= str_replace("`",''',$first_name);
$first_name= str_replace("'",'',$first_name);
$first_name= str_replace("‘",''',$first_name);
$first_name= str_replace("’",''',$first_name);
$first_name= str_replace("“",'"',$first_name);
$first_name= str_replace("‘",''',$first_name);
$first_name= str_replace("’",''',$first_name);
$first_name= str_replace("â€",'"',$first_name);
$first_name= str_replace("'","'",$first_name);
$first_name= str_replace("\n","<br>",$first_name);
$contact_no = $row['2'];
$email = $row['3'];
$gender = $row['4'];
$dob = date('Y-m-d',strtotime($row['5']));
$other_member = '1';
$age = getAge($dob);
$user_id = $logged_in['user_id'];
$address = $logged_in['address'];
$insert_data = array(
'aadhar_number' => $employee_id,
'full_name' => $first_name,
'contact_number' => $contact_no,
'account_type' => '2',
'email_id' => $email,
'gender' => $gender,
'id_proof' => 'Company i-Card',
'user_id' => $user_id,
'dob' => $dob,
'age' => $age,
'status' => '3',
'is_deleted' => '0',
'createdon' => date('Y-m-d H:i:s'),
'other_member' => $other_member,
'address' => $address
);
$usersRow = $this->getSingleRecord('tbl_user_registration', $col = ' * ', array('email_id'=>$email, 'contact_number'=>$contact_no));
if(empty($usersRow['email_id'])) {
$this->saveinfo($tbl_name='tbl_user_registration', $insert_data);
$counter++;
}
}
}
return $counter;
}
public function sendSMTPCommonEmail($to, $subject, $message, $cc='')
{
$CI =& get_instance();
$CI->load->library('email');
$mail=$CI->email;
$mail->clear();
$from_email = 'asset.complaint@shardahospital.org';
$from_name = 'Sharda Hospital';
$config['charset'] = 'utf-8';
$config['wordwrap'] = TRUE;
$config['mailtype'] = 'html';
$config['protocol'] = "smtp";
$config['smtp_host'] = 'ssl://smtp.gmail.com';
$config['smtp_user'] = 'asset.complaint@shardahospital.org';
$config['smtp_pass'] = '$harda@asset123';
$config['smtp_port'] = '465';
$config['_auth_smtp'] = TRUE;
$config['newline'] = "\r\n";
$config['crlf'] = "\r\n";
$mail->initialize($config);
$mail->from($from_email, $from_name);
$mail->to($to);
if($cc){
$mail->cc($cc);
}
$mail->reply_to($from_email, $from_name);
$mail->subject($subject);
$mail->message($message);
return $mail->send();
}
/*
* Function: getAllQuestions
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getAllQuestions($condition = '', $conditionLike = '')
{
$this->db->select('*');
$this->db->join('tbl_questions_master', 'tbl_questions_master.id = tbl_checklist_question.question_id', 'left');
if(!empty($conditionLike)){
foreach($conditionLike as $key=>$val){
$this->db->like($key, $val);
}
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->where($key, $val);
}
}
$this->db->where('tbl_checklist_question.is_deleted', '0');
$this->db->where('tbl_checklist_question.status', '1');
$query = $this->db->get('tbl_checklist_question');
//echo $this->db->last_query();die;
return $query->result_array();
}
}
Kontol Shell Bypass