ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/helpers/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/helpers/site_helper.php |
<?php
/** Constrants **/
define('SITE_NAME', 'LMS Admin Panel');
define('VERSION', time());
define('USR_SESSION_NAME', 'ILmsAdmin');
/*if($_COOKIE['db_year']==='PrevToPrev'){
$up_dir_name="uploads_2020";
}else{
$up_dir_name="uploads";
}*/
$up_dir_name="uploads";
define('URL', base_url());
define('UP_URL', URL.$up_dir_name.'/');
define('THEME_URL', URL."theme/");
define('UP_PATH', FCPATH.$up_dir_name.DIRECTORY_SEPARATOR);
define('URLF', str_replace('api/', '', base_url()));
define('UP_URLF', URLF.$up_dir_name.'/');
define('UP_PATHF', str_replace('api'.DIRECTORY_SEPARATOR, '', FCPATH).$up_dir_name.DIRECTORY_SEPARATOR);
define('PATHF', str_replace('api'.DIRECTORY_SEPARATOR, '', FCPATH));
define('CURRENT_URL', 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']);
define('CURRENCY', 'Rs.');
define('SUAT_SLOT_BOOK_URL', 'https://slotbooking.sharda.ac.in/');
//define('SEND_GRID_KEY', "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");
//define('SEND_GRID_KEY', "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");
define('SEND_GRID_KEY', "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");
/** Functions */
function create_pdf($html_data, $filename="", $action='D', $page_type="A4") {
error_reporting(0);
ini_set('memory_limit', '1024M');
set_time_limit(0);
require_once '../mpdf/mpdf.php';
$mypdf = new mPDF('utf-8', $page_type);
$mypdf->packTableData = true;
$mypdf->WriteHTML($html_data);
$mypdf->Output($filename, $action);
}
function download_csv($data, $h, $keys, $filename='export'){
$filename=$filename.".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=[];
foreach($keys as $k){
$res[]=$r[$k];
}
fputcsv($f, $res);
}
fclose($f);
}
die;
}
function num_to_words_kwd($n){
/** Invented and written by Satyendra :) **/
$n=trim($n);
if(!strlen($n)){
return;
}
if($n===0 or $n==='0'){
return 'Zero';
}
$n=explode(".", $n);
$numbers=array();
$numbers[]=intval($n[0]);
$point=isset($n[1])?intval(substr($n[1].'00', 0,3)):0;
if($point){
$numbers[]=$point;
}
$words=array('0' => '', '1' => 'one', '2' => 'two', '3' => 'three', '4' => 'four', '5' => 'five', '6' => 'six', '7' => 'seven', '8' => 'eight', '9' => 'nine', '10' => 'ten', '11' => 'eleven', '12' => 'twelve', '13' => 'thirteen', '14' => 'fourteen', '15' => 'fifteen', '16' => 'sixteen', '17' => 'seventeen', '18' => 'eighteen', '19' => 'nineteen', '20' => 'twenty', '30' => 'thirty', '40' => 'forty', '50' => 'fifty','60' => 'sixty', '70' => 'seventy', '80' => 'eighty', '90' => 'ninety');
$res=array();
foreach($numbers as $number){
$str1=array();
$seg=array_chunk(array_reverse(str_split($number)), 3);
$num_arr=array();
foreach($seg as $r){
$num_arr[]=implode('', array_reverse($r));
}
foreach($num_arr as $i=>$v){
$num=intval($v);
if($num<20){
$str1[$i][]=$words[$num];
}else{
$d=1;
while($num>0){
if($d<=10){
if($num%10){$str1[$i][]=$words[($num%10)*$d];}
}else if($d==100){
$str1[$i][]=$words[$num%10].' hundred';
}
$num=intval($num/10);
$d=$d*10;
}
}
$rev=array_reverse($str1[$i]);
if(intval($v)>=20){
$last2=intval(substr($number, -2, 2));
if($last2<20 and $last2>10){
unset($rev[count($rev)-1]);
unset($rev[count($rev)-1]);
$rev[]=$words[$last2];
}
}
$str1[$i]=trim(implode(' ', $rev)).($i>1?' million':($i>0?' thousand':''));
}
$res[]=trim(implode(' ', array_reverse($str1)));
}
$rs=trim(ucfirst($res[0]));
if(strlen($rs)){
$rs=$rs.' KWD';
}
if(isset($res[1])){
if(strlen($rs)){
$rs=$rs.' and '.trim($res[1]).' FILS';
}else{
$rs=trim($res[1]).' FILS';
}
}
return $rs;
}
function zero_format_no($str, $len=5){
return str_pad($str, $len, '0', STR_PAD_LEFT);
}
function generate_otp(){
return rand(111111, 999999);
}
function encryptField($v, $type){
if($type=='MOB'){
$v="xxxxxxxxx";
}else if($type=='EMAIL'){
$v="xxxx@xxx.com";
}else if($type=='TXNID'){
$v="xxxxxxx0000xxxxx0000";
}
return $v;
}
function months($m=''){
$rs=['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];
if($m){
return $rs[$m-1];
}
return $rs;
}
function generate_login_url($lpage, $mob=''){
$lpage=rtrim($lpage, "/");
if($mob){
$url=$lpage.'/dashboard/auto-login/'.md5('app007'.$mob).'/0';
}else{
$url=$lpage.'/dashboard/login';
}
return $url;
}
function generate_payment_link($lpage, $mob, $app_id, $adm_user_id=0){
$lpage=rtrim($lpage, "/");
$paytmurl=URLF.'student-panel/api/pay/load_paytm_form/'.$app_id.'/0/0/'.$adm_user_id;
$url=$lpage.'/dashboard/auto-login/'.md5('app007'.$mob).'/'.encode($paytmurl);
return $url;
}
function tempTags(){
return array(
'OTP',
'NAME',
'EMAIL',
'PASSWORD',
'MOBILE_NO',
'SYSTEM_ID',
'LOGIN_URL',
'PROGRAM_NAME',
'PLAN_NAME',
'STEP_COMPLETED',
'TXN_AMT',
'TXN_MODE',
'TXN_STATUS',
'TXN_ID',
'TXN_DATE',
'RECEIPT_DOWNLOAD_URL',
);
}
function campaign_temp_tags(){
return [
'NAME',
'EMAIL',
'MOBILE_NO',
'STATE',
'LOGIN_URL',
'SYSTEM_ID',
'PROGRAM_NAME',
'PLAN_NAME',
'STEP_COMPLETED',
'APPLICATION_NO'
];
}
function campaign_temp_tags_adv(){
$tags=[
'NAME',
'EMAIL',
'MOBILE_NO',
'STATE',
'LOGIN_URL',
'SYSTEM_ID',
'PROGRAM_NAME',
'PLAN_NAME',
'STEP_COMPLETED',
'APPLICATION_NO',
'SCHOOL_NAME',
'SCHOOL_WEBSITE',
'COUNSELLOR_NAME',
'COUNSELLOR_MOB',
];
for($i=1; $i<=6; $i++){
$tags[]='YEAR_'.$i.'_FEE';
}
for($i=1; $i<=12; $i++){
$tags[]='SEMESTER_'.$i.'_FEE';
}
return $tags;
}
function campain_tag_value($str, $d, $udtl=[]){
if(!$udtl){
$udtl=[];
}
$a=campaign_temp_tags_adv();
foreach($a as $i=>$r){
$a[$i]='%'.$a[$i].'%';
}
$b=[$d['name'], $d['email'], $d['mob'], $d['state'], generate_login_url($d['lpage'], $d['mob']), $d['application_no'], $d['program'], $d['plan'], $d['step_completed'], $d['ps_app_no']];
$b[]=$d['school_name'];
$b[]=$d['school_website'];
$b[]=$udtl['name'];
$b[]=$udtl['mobile'];
//pr($d);
for($i=1; $i<=6; $i++){
$n=$d['plan_dtl']['fee_year_wise'][$i-1];
$b[]='Rs. '.$n;
}
for($i=1; $i<=12; $i++){
$n=$d['plan_dtl']['fee_semester_wise'][$i-1];
$b[]='Rs. '.$n;
}
return str_replace($a, $b, $str);
}
function leadFields(){
$a=array(
'lpage'=>'Landing Page',
'name'=>'Name',
'email'=>'Email',
'mob'=>'Mobile No.',
'mob2'=>'Alternate Mobile No.',
'dob'=>'Date of Birth',
'gender'=>'Gender',
'father_name'=>'Father Name',
'state'=>'State',
'stateCode'=>'State Code',
'city'=>'City',
'pincode'=>'Pincode',
'address'=>'Address',
'identity_proof'=>'Identity Proof',
'identity_proof_no'=>'Identity Proof No',
'profile_pic'=>'Profile Pic',
'cat'=>'Applicant Category',
'religion'=>'Religion',
'verified_by'=>'Verified By',
'utm_source'=>'UTM Source',
'utm_campaign'=>'UTM Campaign',
'utm_medium'=>'UTM Medium',
'utm_term'=>'UTM Term',
'utm_content'=>'UTM Content',
'utm_keyword'=>'UTM Keyword',
'utm_placement'=>'UTM Placement',
'academicDtl'=>'Academic Details',
'leadCreated'=>'Lead Created Date',
'leadUpdated'=>'Lead Updated Date',
'step2date'=>'Lead Step2 Date',
'step3date'=>'Lead Step3 Date',
'step_completed'=>'Step Completed',
'application_no'=>'System ID',
'programDtl'=>'Applied Program Details',
'payment_status'=>'Payment Status',
'payment_mode'=>'Payment Mode',
'pay_order_id'=>'Payment Order ID',
'txn_id'=>'Payment TXN ID',
'fullTransDtl'=>'Full Transaction Details',
);
return $a;
}
function filterLeadData($data, $lvOpt, $fullDtl=FALSE){
if($data && !isset($data[0])){
$result[0]=$data;
}else{
$result=$data;
}
$fields=$lvOpt['fields'];
foreach($result as &$r){
if($lvOpt['encrypt_mob']){
$r['mob']=encryptField($r['mob'], 'MOB');
}
if($lvOpt['encrypt_email']){
$r['email']=encryptField($r['email'], 'EMAIL');
}
if($lvOpt['encrypt_txnid']){
$r['txn_id']=encryptField($r['txn_id'], 'TXNID');
}
if($fields){
if(!in_array('lpage', $fields)) $r['lpage']='<NO>';
if(!in_array('utm_source', $fields)) $r['utm_source']='<NO>';
if(!in_array('name', $fields)) $r['name']='<NO>';
if(!in_array('email', $fields)) $r['email']='<NO>';
if(!in_array('mob', $fields)) $r['mob']='<NO>';
if(!in_array('city', $fields)) $r['city']='<NO>';
if(!in_array('pincode', $fields)) $r['pincode']='<NO>';
if(!in_array('state', $fields)) $r['state']='<NO>';
if(!in_array('address', $fields)) $r['address']='<NO>';
if(!in_array('verified_by', $fields)) $r['verified_by']='<NO>';
if(!in_array('leadCreated', $fields)) $r['leadCreated']='<NO>';
if(!in_array('leadUpdated', $fields)) $r['leadUpdated']='<NO>';
if(!in_array('step2date', $fields)) $r['step2date']='<NO>';
if(!in_array('step3date', $fields)) $r['step3date']='<NO>';
if(!in_array('step_completed', $fields)) $r['step_completed']='<NO>';
if(!in_array('application_no', $fields)) $r['application_no']='<NO>';
if(!in_array('programDtl', $fields)) $r['programDtl']='<NO>';
if(!in_array('payment_status', $fields)) {$r['payment_status']='<NO>'; $r['payment_status_text']='<NO>'; $r['payment_mode']='<NO>';}
if(!in_array('pay_order_id', $fields)) $r['pay_order_id']='<NO>';
if(!in_array('txn_id', $fields)) $r['txn_id']='<NO>';
if($fullDtl){
if(!in_array('mob2', $fields)) $r['mob2']='<NO>';
if(!in_array('dob', $fields)) $r['dob']='<NO>';
if(!in_array('gender', $fields)) $r['gender']='<NO>';
if(!in_array('father_name', $fields)) $r['father_name']='<NO>';
if(!in_array('stateCode', $fields)) $r['stateCode']='<NO>';
if(!in_array('identity_proof', $fields)) $r['identity_proof']='<NO>';
if(!in_array('identity_proof_no', $fields)) $r['identity_proof_no']='<NO>';
if(!in_array('profile_pic', $fields)) $r['profile_pic']='<NO>';
if(!in_array('cat', $fields)) $r['cat']='<NO>';
if(!in_array('religion', $fields)) $r['religion']='<NO>';
if(!in_array('utm_source', $fields)) $r['utm_source']='<NO>';
if(!in_array('utm_campaign', $fields)) $r['utm_campaign']='<NO>';
if(!in_array('utm_medium', $fields)) $r['utm_medium']='<NO>';
if(!in_array('utm_term', $fields)) $r['utm_term']='<NO>';
if(!in_array('utm_content', $fields)) $r['utm_content']='<NO>';
if(!in_array('utm_keyword', $fields)) $r['utm_keyword']='<NO>';
if(!in_array('utm_placement', $fields)) $r['utm_placement']='<NO>';
if(!in_array('academicDtl', $fields)) $r['academicDtl']='<NO>';
if(!in_array('fullTransDtl', $fields)) {$r['fullTransDtl']='<NO>'; if(isset($r['payTrans'])){$r['payTrans']=[];}};
}
}
}
return $result;
}
/** CSV */
function download_psleads_csv($data){
$filename="people-soft-leads-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
$h=[];
foreach($data[0] as $k=>$v){
$h[]=$k;
}
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=[];
foreach($r as $k=>$v){
if(ctype_digit($v) && substr($v, 0,1)=='0'){
$v='#'.$v;
}
$res[]=$v;
}
fputcsv($f, $res);
}
fclose($f);
die;
}
}
function download_scheduled_visits_csv($data){
$filename="scheduled-visits-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
$h=array('NAME', 'EMAIL', 'MOBILE', 'DOB', 'FATHER NAME', 'ACADEMIC CAREER', 'PROGRAM', 'SPECIALIZATION', 'STEP COMPLETED', 'ADDRESS', 'CITY', 'STATE', 'PINCODE', 'COUNCELING CENTER', 'APPOINTMENT DATE');
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=array(
$r['name'], $r['email'], $r['mob'], $r['dob'], $r['father_name'], $r['ac'], $r['program'], $r['plan'], $r['step_completed'],
$r['address'], $r['city'], $r['state'], $r['pincode'], $r['center'], $r['appoint_date'],
);
fputcsv($f, $res);
}
fclose($f);
die;
}
}
function download_campus_visits_csv($data){
$filename="campus-visits-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
$h=array('SYSTEM ID', 'NAME', 'EMAIL', 'MOBILE', 'DOB', 'FATHER NAME', 'ACADEMIC CAREER', 'PROGRAM', 'SPECIALIZATION', 'STEP COMPLETED', 'ADDRESS', 'CITY', 'STATE', 'PINCODE', 'CAMPUS', 'VISIT DATE', 'VISIT TIME', 'BOOKING DATE', 'FOLLOWUP STATUS');
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=array(
$r['application_no'], $r['name'], $r['email'], $r['mob'], $r['dob'], $r['father_name'], $r['ac'], $r['program'], $r['plan'], $r['step_completed'],
$r['address'], $r['city'], $r['state'], $r['pincode'], $r['campus'], $r['visit_date'], $r['visit_time'], $r['created'], $r['followup_status'],
);
fputcsv($f, $res);
}
fclose($f);
die;
}
}
function leadsKeysLabelsStep0(){
return array(
'leadCreated'=>'CREATED DATE',
'name'=>'NAME',
'email'=>'EMAIL',
'mob'=>'MOBILE',
'neet_roll_no'=>'NEET ROLL NO',
'neet_marks'=>'NEET MARKS',
'neet_all_india_rank'=>'NEET ALL INDIA RANK',
'program_type'=>'PROGRAM TYPE',
'ac'=>'ACADEMIC CAREER',
'ac_code'=>'CAREER CODE',
'program'=>'PROGRAM',
'prgCode'=>'PROGRAM CODE',
'plan'=>'PLAN',
'planCode'=>'PLAN CODE',
'state'=>'STATE',
'stateCode'=>'STATE CODE',
'step_completed'=>'STEP COMPLETED',
'lpage'=>'LANDING PAGE',
'utm_source'=>'UTM SOURCE',
'utm_campaign'=>'UTM CAMPAIGN',
'utm_medium'=>'UTM MEDIUM',
'utm_term'=>'UTM TERM',
'utm_content'=>'UTM CONTENT',
'utm_keyword'=>'UTM KEYWORD',
'utm_placement'=>'UTM PLACEMENT',
);
}
function leadsKeysLabels(){
return array(
'application_no'=>'SYSTEM ID',
'name'=>'NAME',
'email'=>'EMAIL',
'mob'=>'MOBILE',
'neet_roll_no'=>'NEET ROLL NO',
'neet_marks'=>'NEET MARKS',
'neet_all_india_rank'=>'NEET ALL INDIA RANK',
'program_type'=>'PROGRAM TYPE',
'ac'=>'ACADEMIC CAREER',
'ac_code'=>'CAREER CODE',
'discipline'=>'DISCIPLINE',
'program'=>'PROGRAM',
'prgCode'=>'PROGRAM CODE',
'plan'=>'PLAN',
'planCode'=>'PLAN CODE',
'school'=>'SCHOOL',
'school_code'=>'SCHOOL CODE',
'mob2'=>'ALT MOBILE',
'dob'=>'DOB',
'gender'=>'GENDER',
'city'=>'CITY',
'state'=>'STATE',
'stateCode'=>'STATE CODE',
'pincode'=>'PINCODE',
'father_name'=>'FATHER NAME',
'cat'=>'SOCIAL CATEGORY',
'religion'=>'RELIGION',
'verified_by'=>'VERIFIED BY',
'board_10th'=>'10TH BOARD',
'marking_scheme_10'=>'10TH MARKING SCHEME',
'marks_10th'=>'10TH MARKS',
'passing_year_10th'=>'10TH PASSING YEAR',
'board_12th'=>'12TH BOARD',
'marking_scheme_12'=>'12TH MARKING SCHEME',
'marks_12th'=>'12TH MARKS',
'passing_year_12th'=>'12TH PASSING YEAR',
'board_dip'=>'DIPLOMA BOARD',
'marking_scheme_dip'=>'DIPLOMA MARKING SCHEME',
'marks_dip'=>'DIPLOMA MARKS',
'passing_year_dip'=>'DIPLOMA PASSING YEAR',
'university_ug'=>'UG UNIVERSITY',
'marking_scheme_ug'=>'UG MARKING SCHEME',
'marks_ug'=>'UG MARKS',
'passing_year_ug'=>'UG PASSING YEAR',
'university_pg'=>'PG UNIVERSITY',
'marking_scheme_pg'=>'PG MARKING SCHEME',
'marks_pg'=>'PG MARKS',
'passing_year_pg'=>'PG PASSING YEAR',
'step_completed'=>'STEP COMPLETED',
'payment_status_text'=>'PAYMENT STATUS',
'payment_mode'=>'PAYMENT MODE',
'pay_order_id'=>'PAYMENT ORDER ID',
'txn_id'=>'TXN ID',
'txn_status'=>'TXN STATUS',
'respmsg'=>'PAYTM RESPONSE MESSAGE',
'txn_amt'=>'TXN AMOUNT',
'lpage'=>'LANDING PAGE',
'utm_group'=>'UTM GROUP',
'utm_source'=>'UTM SOURCE',
'utm_campaign'=>'UTM CAMPAIGN',
'utm_medium'=>'UTM MEDIUM',
'utm_term'=>'UTM TERM',
'utm_content'=>'UTM CONTENT',
'utm_keyword'=>'UTM KEYWORD',
'utm_placement'=>'UTM PLACEMENT',
'leadCreated'=>'CREATED DATE (STEP 1)',
'step2date'=>'STEP 2 DATE',
'step3date'=>'STEP 3 DATE',
'followup_count_all'=>'REMARKS COUNT(ALL)',
'followup_count'=>'REMARKS COUNT (ONLY FOLLOWUP)',
'followup_title'=>'FOLLOWUP',
'subremarks'=>'FOLLOWUP SUB-REMARKS',
'feedback'=>'FOLLOWUP COMMENT',
// 'followup_by'=>'LAST FOLLOW-UP BY',
/* 'email_count'=>'NO OF EMAILS SENT',
'iall'=>'NO OF ISSUES',
'iclose'=>'NO OF ISSUES CLOSED', */
'isdead'=>'IS DEAD',
'ps_app_no'=>'APPLICATION NUMBER',
'ps_app_status'=>'APPLICATION STATUS',
'ps_status'=>'ADMISSION STATUS',
'ps_paid_status'=>'ADM PAID STATUS',
'login_url'=>'LOGIN URL',
'campus'=>'CAMPUS',
'suat_status'=>'SUAT STATUS',
'slot_booking_date'=>'SLOT BOOKING DATE',
'suat_score'=>'SUAT SCORE',
'per_12th'=>'PERCENT 12TH',
'newsletter_subscribed'=>'NEWSLETTER SUBSCRIBED',
'superbot_disposition'=>'SUPERBOT DISPOSITION',
'is_campus_offline'=>'IS CAMPUS OFFLINE',
'net'=>'NET',
'gate'=>'GATE',
'slet'=>'SLET',
'mphil'=>'MPHIL',
'other_entrance_exam_dtl'=>'OTHER ENTRANCE',
);
}
function download_leads_csv($data, $keysLabels){
$filename="leads-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
if(!$data[0]['is_medical']){
unset($keysLabels['neet_roll_no'], $keysLabels['neet_marks'], $keysLabels['neet_all_india_rank']);
}
$h=[];
foreach($keysLabels as $k=>$lbl){
$h[]=$lbl;
}
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=[];
foreach($keysLabels as $k=>$lbl){
if(ctype_digit($r[$k]) && substr($r[$k], 0,1)=='0'){
$r[$k]='#'.$r[$k];
}
$res[]=$r[$k];
}
fputcsv($f, $res);
}
fclose($f);
die;
}
}
function download_online_payments_csv($data){
$filename="online-payments-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
$h=array('NAME', 'EMAIL', 'MOBILE', 'SYSTEM ID', 'PAYMENT ORDER ID', 'TXN ID', 'TXN DATE', 'TXN STATUS', 'RESP MSG', 'PAYMENT MODE', 'BANK TXN ID', 'TXN AMOUNT');
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=array(
$r['name'], $r['email'], $r['mob'], $r['application_no'], $r['pay_order_id'], '#'.$r['txn_id'], $r['txn_date'], $r['txn_status'], $r['respmsg'],
$r['bank_name'].($r['payment_mode']?' ['.$r['payment_mode'].']':''), '#'.$r['bank_txn_id'], $r['txn_amt'],
);
fputcsv($f, $res);
}
fclose($f);
die;
}
}
function download_cash_payments_csv($data){
$filename="cash-payments-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
$h=array('SYSTEM ID', 'NAME', 'MOBILE', 'DATE/TIME', 'RECEIVED BY', 'AMOUNT');
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=array($r['application_no'], $r['name'], $r['mob'], $r['created'], $r['usr'], $r['amount']);
fputcsv($f, $res);
}
fclose($f);
die;
}
}
function download_leads_login_url_csv($data){
$filename="auto-login-urls-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
$h=array('SYSTEM ID', 'NAME', 'MOBILE', 'EMAIL', 'CITY', 'STATE', 'DISCIPLINE', 'PROGRAM', 'PLAN', 'STEP COMPLETED', 'AUTO LOGIN URL', 'LEAD CREATED DATE');
fputcsv($f, $h);
foreach($data as $i=>$r){
$res=array($r['application_no'], $r['name'], $r['mob'], $r['email'], $r['city'], $r['state'], $r['discipline'], $r['program'], $r['plan'], $r['step_completed'], $r['login_url'], $r['leadCreated']);
fputcsv($f, $res);
}
fclose($f);
die;
}
}
function download_leads_paid_monthly_daily_csv($data, $head1, $filename){
$filename=$filename."-".currentDT().".csv";
header('Content-Type: application/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename="'.$filename.'";');
$f=fopen('php://output', 'w');
if($data){
$head=[$head1];
foreach($data['head'] as $h){
$head[]=strtoupper($h['head_name'].' LEADS');
$head[]=strtoupper($h['head_name'].' PAID');
}
fputcsv($f, $head);
foreach($data['result'] as $s=>$r){
$res=[$s];
foreach($data['head'] as $h){
$res[]=$r[$h['head']][0]['leads'];
$res[]=$r[$h['head']][0]['paid'];
}
fputcsv($f, $res);
}
$res=['TOTAL'];
foreach($data['head'] as $h){
$res[]=$data['total'][$h['head']]['leads'];
$res[]=$data['total'][$h['head']]['paid'];
}
fputcsv($f, $res);
fclose($f);
die;
}
}
function send_campaign_email_old($data, $fromname="Sharda University", $fromemail="info@shardauniversity.com"){
if(ENVIRONMENT=='development'){
//return TRUE;
}
//SUsocial@2019
$key="c77184012dcf9bd5cd1886b4e0a2bb89"; //pepipostkey
require_once("sendgrid/sendgrid-php.php");
$email = new \SendGrid\Mail\Mail();
$email->setFrom($fromemail, $fromname);
$subject="Test Pepi";
$message="Test Message";
$to="sat.web1989@gmail.com";
$email->setSubject($subject);
$email->addTo($to);
$email->addContent("text/html", $message);
$sendgrid = new \SendGrid($key, ['host'=>'https://sgapi.pepipost.com']);
try {
$response = $sendgrid->send($email);
pr($response);
return $response->statusCode()==202;
} catch (Exception $e) {
echo 'Caught exception: '. $e->getMessage() ."\n";
}
}
function send_sms($mob, $msg=''){
if(ENVIRONMENT=='development'){
//return TRUE;
$mob="9958808167";
}
//$mob='91'.$mob;
$msg=urlencode($msg);
$ch = curl_init();
curl_setopt($ch,CURLOPT_URL, "http://bulkpush.mytoday.com/BulkSms/SingleMsgApi");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, "feedid=363901&username=9015129267&password=wgtpt&To=".$mob."&Text=".$msg."&time=&senderid=shardacom_trans");
$buffer = curl_exec($ch);
$err = curl_error($ch);
//pr($err);
curl_close($ch);
return $buffer;
}
function sendWhatsAppText($mob, $msg, $instance_id='', $media_url=''){
if(ENVIRONMENT=='development'){
$mob="919958808167";
}
$apiDomain="https://cloudwaapi.com";
$accessToken='64897985b3113';
if(!$instance_id){
return;
}
$mob=str_replace("+", "", $mob);
$msg=urlencode($msg);
$type="text";
if($media_url){
$type="media";
}
$apiUrl=$apiDomain."/api/send?number=$mob&type=$type&message=$msg&instance_id=$instance_id&access_token=$accessToken";
if($media_url){
$filename=end(explode("/", $media_url));
$apiUrl=$apiUrl."&media_url=".urlencode($media_url)."&filename=".$filename;
}
$arrContextOptions=array(
"ssl"=>array(
"verify_peer"=>false,
"verify_peer_name"=>false,
),
);
$res=@file_get_contents($apiUrl, false, stream_context_create($arrContextOptions));
return $res;
}
function send_campaign_email($data, $fromname="", $fromemail="", $replyto=""){
$fromname=$fromname?$fromname:'Sharda University';
$fromemail=$fromemail?$fromemail:'info@shardauniversity.com';
$replyto=$replyto?$replyto:'info@shardauniversity.com';
foreach($data as $d){
if(!$d['email']){
continue;
}
$d=array (
'personalizations' => array (0 => array ('recipient' => $d['email'])),
'from' => array ('fromEmail' => $fromemail, 'fromName' => $fromname),
'replyToId'=>$replyto,
'subject' => $d['subject'],
'content' => $d['msg'],
);
$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",
"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 init_before_background_process(){
ob_start();
header("Connection: close\r\n");
header('Content-Encoding: none\r\n');
ignore_user_abort(true);
}
function init_background_process(){
$size = ob_get_length();
header("Content-Length: ". $size . "\r\n");
ob_end_flush();
flush();
}
function getBrowser() {
$u_agent = $_SERVER['HTTP_USER_AGENT'];
$bname = 'Unknown';
$platform = 'Unknown';
$version= "";
//First get the platform?
if (preg_match('/linux/i', $u_agent)) {
$platform = 'Linux';
}elseif (preg_match('/macintosh|mac os x/i', $u_agent)) {
$platform = 'Mac';
}elseif (preg_match('/windows|win32/i', $u_agent)) {
$platform = 'Windows';
}
// Next get the name of the useragent yes seperately and for good reason
if(preg_match('/MSIE/i',$u_agent) && !preg_match('/Opera/i',$u_agent)){
$bname = 'Internet Explorer';
$ub = "MSIE";
}elseif(preg_match('/Firefox/i',$u_agent)){
$bname = 'Mozilla Firefox';
$ub = "Firefox";
}elseif(preg_match('/OPR/i',$u_agent)){
$bname = 'Opera';
$ub = "Opera";
}elseif(preg_match('/Chrome/i',$u_agent) && !preg_match('/Edge/i',$u_agent)){
$bname = 'Google Chrome';
$ub = "Chrome";
}elseif(preg_match('/Safari/i',$u_agent) && !preg_match('/Edge/i',$u_agent)){
$bname = 'Apple Safari';
$ub = "Safari";
}elseif(preg_match('/Netscape/i',$u_agent)){
$bname = 'Netscape';
$ub = "Netscape";
}elseif(preg_match('/Edge/i',$u_agent)){
$bname = 'Edge';
$ub = "Edge";
}elseif(preg_match('/Trident/i',$u_agent)){
$bname = 'Internet Explorer';
$ub = "MSIE";
}
// finally get the correct version number
$known = array('Version', $ub, 'other');
$pattern = '#(?<browser>' . join('|', $known) . ')[/ ]+(?<version>[0-9.|a-zA-Z.]*)#';
if (!preg_match_all($pattern, $u_agent, $matches)) {
// we have no matching number just continue
}
// see how many we have
$i = count($matches['browser']);
if ($i != 1) {
//we will have two since we are not using 'other' argument yet
//see if version is before or after the name
if (strripos($u_agent,"Version") < strripos($u_agent,$ub)){
$version= $matches['version'][0];
}else {
$version= $matches['version'][1];
}
}else {
$version= $matches['version'][0];
}
// check if we have a number
if ($version==null || $version=="") {$version="?";}
return array(
'userAgent' => $u_agent,
'name' => $bname,
'version' => $version,
'platform' => $platform,
'pattern' => $pattern
);
}
function upload_img($name,$dir,$CI){
if(!is_dir($dir)){
mkdir($dir, 0777, true);
}
$config=array(
'upload_path'=>$dir,
'allowed_types'=>'jpg|jpeg|png',
'max_size'=>'10240',
'max_filename'=>80,
'file_ext_tolower'=>true,
);
$CI->upload->initialize($config);
if($CI->upload->do_upload($name)){
return $CI->upload->data('file_name');
}else{
throw new Exception(strip_tags($CI->upload->display_errors()));
}
}
function upload_img_pdf($name,$dir,$CI){
if(!is_dir($dir)){
mkdir($dir, 0777, true);
}
$config=array(
'upload_path'=>$dir,
'allowed_types'=>'jpg|jpeg|png|pdf',
'max_size'=>'10240',
'max_filename'=>80,
'file_ext_tolower'=>true,
);
$CI->upload->initialize($config);
if($CI->upload->do_upload($name)){
return $CI->upload->data('file_name');
}else{
throw new Exception(strip_tags($CI->upload->display_errors()));
}
}
//EOF
Kontol Shell Bypass