110 lines
2.7 KiB
PHP
Executable File
110 lines
2.7 KiB
PHP
Executable File
<?php
|
|
/*
|
|
* Created by Visual Code studio
|
|
* User: Subaram
|
|
* Date: 15/1/18
|
|
* Time: 10:05 AM
|
|
*/
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Center_model extends CI_Model {
|
|
|
|
|
|
/*
|
|
* Add center details
|
|
* created by subaramkumar
|
|
*/
|
|
|
|
public function addCenter($arrayDetails=null)
|
|
{
|
|
|
|
$this->db->select('CenterCode');
|
|
$this->db->where('CenterCode', $arrayDetails['CenterCode']);
|
|
if($this->db->get(CENTER)->first_row()){
|
|
$result['centerStatus'] = false;
|
|
$result['message'] = "This center Code is already exist!";
|
|
} else {
|
|
$this->db->insert(CENTER, $arrayDetails);
|
|
if ($this->db->affected_rows() == '1') {
|
|
|
|
$result['centerStatus'] = true;
|
|
$result['message'] = "Successfully center details added";
|
|
} else {
|
|
$result['centerStatus'] = false;
|
|
$result['message'] = "Something went wrong.please try again";
|
|
}
|
|
}
|
|
return $result;
|
|
|
|
}
|
|
|
|
|
|
/*
|
|
* Get center details
|
|
* created by srk
|
|
*/
|
|
|
|
|
|
|
|
public function getCenter()
|
|
{
|
|
$this->db->select('*');
|
|
$this->db->order_by('CreatedOn','DESC');
|
|
$centerDetails = $this->db->get(CENTER);
|
|
// print_r($centerDetails);
|
|
// die;
|
|
|
|
if($centerDetails->result()){
|
|
|
|
$result['centerStatus'] = true;
|
|
$result['details'] = $centerDetails->result();
|
|
}
|
|
else {
|
|
$result['centerStatus'] = false;
|
|
$result['message'] = "No records found!";
|
|
}
|
|
|
|
return $result;
|
|
|
|
}
|
|
|
|
/*
|
|
* update Center details
|
|
* created by Srk
|
|
*/
|
|
public function updateCenter($arrayDetails=null,$CenterID=null)
|
|
{
|
|
|
|
$this->db->select('CenterCode');
|
|
$this->db->where('CenterCode',$arrayDetails['CenterCode']);
|
|
//$this->db->where('SubjectCode !=', $arrayDetails['SubjectCode']);
|
|
$this->db->where('CenterCode !=',$arrayDetails['CenterCode']);
|
|
if($this->db->get(CENTER)->first_row()){
|
|
$result['centerStatus']=false;
|
|
$result['message']= " This Center code already exist";
|
|
}
|
|
else{
|
|
$this->db->where('CenterID',$CenterID);
|
|
$updateStatus=$this->db->update(CENTER, $arrayDetails);
|
|
if($updateStatus){
|
|
|
|
$result['centerStatus'] = true;
|
|
$result['message'] = "Successfully Center details updated";
|
|
}
|
|
|
|
else {
|
|
$result['centerStatus'] = false;
|
|
$result['message'] = "Something went wrong.please try again";
|
|
|
|
}
|
|
}
|
|
|
|
|
|
return $result;
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
} |