page_data = globalfunc::getMessage($parent, $parent->lang, 'support'); if (count($parent->params) == 0) { //$this->topicsfunc($parent); } else { $qry_params = explode("?", $parent->params[0]); $parameter_val = strtolower($qry_params[0]); switch ($parameter_val) { case "topic": case "content": case "registereduser": case "assessment": case "dmsemployee": case "dmsmanager": case "dmsdealer": case "dmssales": case "dmstarget": case "dmsrewardpoints": case "lastaccess": case "customerexperience": case "enquiry": case "activesmpin": case "loginlog": case "dealerenquiryinactive": $this->$parameter_val($parent); break; default: $this->topicsfunc($parent); break; } } $parent->response(array('response' => 'failed', 'message' => 'PAGE NOT FOUND'), 404); } /* /////////////////////////////// TOPICS //////////////////////////////////////////////// */ private function topic($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; echo '

HYPER-M - TOPIC LIST

' . ''; $query_category = $parent->selectQuery(TABLE_CATEGORY, "`cateid`, `catename`", "1=1 ORDER BY cateid ", ""); if ($query_category['nr']) { $sno = 1; $s3 = awsfileserver::connectS3(); foreach ($query_category['result'] as $res_cat) { $user_cond = " AND cateid='" . $res_cat->cateid . "' "; $getuser_topics_arr = $parent->selectQuery(TABLE_ASSET_TOPIC, "*", " status='1' AND is_deleted='0' " . $user_cond . " ORDER BY position ASC, assettopicid ASC " . $limit_cond, ""); if ($getuser_topics_arr['nr']) { //CONNECT S3 foreach ($getuser_topics_arr['result'] as $res) { $res->image_url = TRAININGIMAGE_URL; if ($res->image) { $res->image_url = awsfileserver::getS3FileUrl($s3, S3_BUCKET, S3_TOPICS_URL . $res->image); } $user_type = ($res->user_type == '0') ? "Normal" : "Super Bike"; //$data_arr[]=$res; echo ''; } } } } echo '

#	Category	Category id	Topic	Topic id	User type	Topic image
' . $sno++ . '	' . $res_cat->catename . '	' . $res_cat->cateid . '	' . $res->topicname . '	' . $res->assettopicid . '	' . $user_type . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// TOPICS CONTENT LIST //////////////////////////////////////////////// */ private function content($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); echo '

HYPER-M - CONTENT LIST

' . ''; $query_category = $parent->selectQuery(TABLE_CATEGORY, "`cateid`, `catename`", "1=1 ORDER BY cateid ", ""); if ($query_category['nr']) { $sno = 0; $s3 = awsfileserver::connectS3(); foreach ($query_category['result'] as $res_cat) { $user_cond = " AND cateid='" . $res_cat->cateid . "' "; $getuser_topics_arr = $parent->selectQuery(TABLE_ASSET_TOPIC, "*", " status='1' AND is_deleted='0' " . $user_cond . " ORDER BY position ASC, assettopicid ASC "); if ($getuser_topics_arr['nr']) { //CONNECT S3 foreach ($getuser_topics_arr['result'] as $res) { $res->image_url = TRAININGIMAGE_URL; if ($res->image) { $res->image_url = awsfileserver::getS3FileUrl($s3, S3_BUCKET, S3_TOPICS_URL . $res->image); } $usercond = " AND assettopicid='" . $res->assettopicid . "' "; $orderby_cond = ($res->listorder == '1') ? "ORDER BY uploaddate DESC,contentid ASC " : "ORDER BY uploaddate ASC,contentid ASC "; $getuser_content_arr = $parent->selectQuery(TABLE_ASSET_CONTENT, "*", " status='1' AND is_deleted='0' " . $usercond . " " . $orderby_cond, ""); if ($getuser_content_arr['nr']) { foreach ($getuser_content_arr['result'] as $res_con) { $res_con->content_files = $this->getContentFiles($parent, $s3, $res_con->contentid); if (count($res_con->content_files) > 0) { $table_value = '

#	Category	Category id	Topic	Topic id	Content id	Topic image	Content title	Content description	Content file urls

'; foreach ($res_con->content_files as $res_file) { $m = 0; $table_value .= ''; } $table_value .= '

#	Language	Thumb nail	Content
' . ++$m . '	' . $res_file->language_title . '		Download

'; } echo '' . ++$sno . '' . $res_cat->catename . '' . $res_cat->cateid . '' . $res->topicname . '' . $res->assettopicid . '' . $res_con->contentid . '

' . $res_con->title . '' . $res_con->description . '' . $table_value . ''; } } } } } } echo '';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// TOPIC CONTENT //////////////////////////////////////////////// */ private function getContentFiles($parent, $s3, $contentid) { $data_arr = array(); //GET FILES ONLY ONE FILE $getuser_contentfiles_arr = $parent->selectQuery(TABLE_ASSET_FILE . " as f JOIN " . TABLE_MASTER_LANGUAGE . " as l ON l.language_id=f.language_id", " f.`language_id`, f.`filepath`,f.filetypeid, f.`thumbpath`, f.`filetypeid`, f.`filetype`, f.`filesize`, f.`filequality`, l.`language_code`, l. `language_title`", " f.contentid='" . $contentid . "'", ""); if ($getuser_contentfiles_arr['nr']) { foreach ($getuser_contentfiles_arr['result'] as $tkey => $res) { //S3 FILE URL $fileurl = ''; if ($res->filepath != '') { $url = awsfileserver::getS3FileUrl($s3, S3_BUCKET, S3_TOPICS_URL . $res->filepath); //PDF ISSUE FIX FOR WEB DEVICE $url = (strtolower($parent->device_type) == 'web' && $res->filetypeid == '1') ? projectfunc::pdfUrlStr($parent, $url) : $url; $fileurl = $url; } $getuser_contentfiles_arr['result'][$tkey]->file_url = $fileurl; //S3 THUMBIMAGE URL $thumb_fileurl = ''; if ($res->thumbpath != '') { $thumb_fileurl = awsfileserver::getS3FileUrl($s3, S3_BUCKET, S3_TOPICS_URL . $res->thumbpath); } $getuser_contentfiles_arr['result'][$tkey]->thumb_fileurl = $thumb_fileurl; } $data_arr = $getuser_contentfiles_arr['result']; } return $data_arr; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// REGISTERED USER //////////////////////////////////////////////// */ private function registereduser($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; $cond = ''; //FILTER $filter_arr = globalfunc::getFilterValues($parent, $parent->params[0]); if (count($filter_arr) > 0) { //smpin if (isset($filter_arr['role']) && $filter_arr['role'] != '') { $cond = " AND u.role='" . $filter_arr['role'] . "'"; } } $query_group = $parent->selectQuery(TABLE_USER . " u JOIN " . TABLE_ROLE . " r ON u.role=r.id LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code", "COUNT(u.userid) ucount , r.rolename ", "u.is_deleted=0 AND u.role>2 " . $cond . " GROUP BY u.role", ""); echo '

HYPER-M - REGISTERED USER LIST

' . ''; if ($query_group['nr']) { foreach ($query_group['result'] as $res) { echo ''; } } echo '

ROLE	TOTAL REGISTER
' . $res->rolename . '	' . $res->ucount . '

' . ''; $query_user = $parent->selectQuery(TABLE_USER . " u JOIN " . TABLE_ROLE . " r ON u.role=r.id LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code", "u.smpin,u.emp_code,u.fname, u.`lname`,u.segment, u.`emailid`, u.`mobileno`,u.created_on,r.rolename,u.dealer_code,d.dealer_name,d.city,d.zone,d.`zm_name`, d.`rm_name`, d.`am_name`,u.userid", "u.is_deleted=0 AND u.role>2 " . $cond . " ORDER BY u.created_on ", ""); if ($query_user['nr']) { $sno = 1; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { $dealer_code = ($res_user->dealer_code != '') ? $res_user->dealer_code : ''; $dealer_data = ($res_user->dealer_code != '') ? $res_user->dealer_name : ''; $segment = ''; switch ($res_user->segment) { case '0':$segment = 'Student Learner'; break; case '1':$segment = 'Parents/Guardian'; break; case '2':$segment = 'Instructor'; break; } echo ''; } } echo '

#	USERID	ROLE	SMPIN	EMP CODE	NAME	Segment	DEALER CODE	DEALER	Zone	City	ZM	RM	AM	MOBILE	EMAIL	REGISTERED DATE
' . $sno++ . '	' . $res_user->userid . '	' . $res_user->rolename . '	' . $res_user->smpin . '	' . $res_user->emp_code . '	' . $res_user->fname . " " . $res_user->lname . '	' . $segment . '	' . $dealer_code . '	' . $dealer_data . '	' . $res_user->zone . '	' . $res_user->city . '	' . $res_user->zm_name . '	' . $res_user->rm_name . '	' . $res_user->am_name . '	' . $res_user->mobileno . '	' . $res_user->emailid . '	' . date('d-m-Y h:i A ', strtotime($res_user->created_on)) . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// ASSESSMENT //////////////////////////////////////////////// */ private function assessment($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; echo '

HYPER-M - ASSESSMENT LIST

' . ''; //SELECT a.assessmentname,au.highscore,u.smpin, u.fname, u.`lname`, u.`mobileno`,u.dealer_code,d.dealer_name,d.city,d.zone FROM `tbl__assessmentuser` au JOIN tbl__assessment a On a.assessmentid=au.assessmentid JOIN tbl__user u On au.userid=u.userid JOIN tbl__role r ON u.role=r.id LEFT JOIN tbl__dms_dealer d ON d.dealer_code=u.dealer_code WHERE a.assettypeid=1 ORDER BY a.assessmentid ASC $query_res = $parent->selectQuery(TABLE_ASSESSMENT_USER . " au JOIN " . TABLE_ASSESSMENT . " a On a.assessmentid=au.assessmentid JOIN " . TABLE_USER . " u On au.userid=u.userid JOIN " . TABLE_ROLE . " r ON u.role=r.id LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code ", "a.assessmentname,au.highscore,au.modified_on,u.smpin, u.fname, u.`lname`, u.`mobileno`,u.dealer_code,d.dealer_name,d.city,d.zone", "a.assettypeid=1 ORDER BY a.assessmentid ASC,au.highscore DESC,au.modified_on ASC ", ""); if ($query_res['nr']) { $sno = 1; //$s3=awsfileserver::connectS3(); foreach ($query_res['result'] as $res) { $dealer_code = ($res_user->dealer_code != '') ? $res_user->dealer_code : ''; echo ''; } } echo '

#	ASSESSMENT	SCORE	ATTENDED ON	SMPIN	NAME	MOBILE	DEALER CODE	DEALER	CITY	ZONE
' . $sno++ . '	' . $res->assessmentname . '	' . $res->highscore . '	' . date('d-m-Y h:i A', strtotime($res->modified_on)) . '	' . $res->modified_on . '	' . $res->smpin . '	' . $res->fname . " " . $res->lname . '	' . $res->mobileno . '	' . $dealer_code . '	' . $res->dealer_name . '	' . $res->city . '	' . $res->zone . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// dmsemployee //////////////////////////////////////////////// */ private function dmsemployee($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; $cond = ''; //FILTER $filter_arr = globalfunc::getFilterValues($parent, $parent->params[0]); if (count($filter_arr) > 0) { //smpin if (isset($filter_arr['smpin']) && $filter_arr['smpin'] != '') { $cond .= " AND u.smpin LIKE '%" . escape_str($filter_arr['smpin']) . "%' "; } //emp_code if (isset($filter_arr['emp_code']) && $filter_arr['emp_code'] != '') { $cond .= " AND u.emp_code LIKE '%" . escape_str($filter_arr['emp_code']) . "%' "; } //fname if (isset($filter_arr['fname']) && $filter_arr['fname'] != '') { $cond .= " AND u.fname LIKE '%" . escape_str($filter_arr['fname']) . "%' "; } //lname if (isset($filter_arr['lname']) && $filter_arr['lname'] != '') { $cond .= " AND u.lname LIKE '%" . escape_str($filter_arr['lname']) . "%' "; } //dealer_code if (isset($filter_arr['dealer_code']) && $filter_arr['dealer_code'] != '') { $cond .= " AND u.dealer_code LIKE '%" . escape_str($filter_arr['dealer_code']) . "%' "; } //role if (isset($filter_arr['role']) && $filter_arr['role'] != '') { $cond .= " AND u.role LIKE '%" . escape_str($filter_arr['role']) . "%' "; } //role if (isset($filter_arr['mobile']) && $filter_arr['mobile'] != '') { $cond .= " AND u.mobile LIKE '%" . escape_str($filter_arr['mobile']) . "%' "; } //city if (isset($filter_arr['city']) && $filter_arr['city'] != '') { $cond .= " AND d.city LIKE '%" . escape_str($filter_arr['city']) . "%' "; } //zone if (isset($filter_arr['zone']) && $filter_arr['zone'] != '') { $cond .= " AND d.zone LIKE '%" . escape_str($filter_arr['zone']) . "%' "; } } $query_group = $parent->selectQuery(DMS_EMPLOYEE, "COUNT(id) ucount ", "status=1", ""); echo '

HYPER-M - EMPLOYEE MASTER DATA

' . ''; if ($query_group['nr']) { foreach ($query_group['result'] as $res) { echo ''; } } echo '

TOTAL COUNT
' . $res->ucount . '

' . ' '; $query_user = $parent->selectQuery(DMS_EMPLOYEE . " u LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code", "u.`smpin`, u.`emp_code`, u.`fname`,u. `lname`, u.segment,u.`dealer_code`,u. `role`, u.`emailid`, u.`mobile`,u.is_current,d.dealer_name,d.city,d.zone,u.created_on,u.modified_on", "u.status='1' " . $cond, ""); if ($query_user['nr']) { $sno = 0; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { if ($sno == 0) { $arr = array_keys((array) $res_user); //print_r(array_keys($a)); exit; echo ''; foreach ($arr as $head) { echo ''; $sno++; } echo ''; foreach ($res_user as $val) { echo ''; } echo ''; } } echo '

#	' . $head . ''; } echo '
' . $sno++ . '	' . $val . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// dmsmanager //////////////////////////////////////////////// */ private function dmsmanager($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; $query_group = $parent->selectQuery(DMS_HOUSER, "COUNT(id) ucount ", "status=1", ""); $cond = ''; //FILTER $filter_arr = globalfunc::getFilterValues($parent, $parent->params[0]); if (count($filter_arr) > 0) { //emp_code if (isset($filter_arr['emp_code']) && $filter_arr['emp_code'] != '') { $cond .= " AND emp_code LIKE '%" . escape_str($filter_arr['emp_code']) . "%' "; } //fname if (isset($filter_arr['fname']) && $filter_arr['fname'] != '') { $cond .= " AND fname LIKE '%" . escape_str($filter_arr['fname']) . "%' "; } //lname if (isset($filter_arr['lname']) && $filter_arr['lname'] != '') { $cond .= " AND lname LIKE '%" . escape_str($filter_arr['lname']) . "%' "; } //role if (isset($filter_arr['role']) && $filter_arr['role'] != '') { $cond .= " AND role LIKE '%" . escape_str($filter_arr['role']) . "%' "; } //role if (isset($filter_arr['mobile']) && $filter_arr['mobile'] != '') { $cond .= " AND mobile LIKE '%" . escape_str($filter_arr['mobile']) . "%' "; } //zone if (isset($filter_arr['zone']) && $filter_arr['zone'] != '') { $cond .= " AND zone LIKE '%" . escape_str($filter_arr['zone']) . "%' "; } } echo '

HYPER-M - MANAGER MASTER DATA

' . ''; if ($query_group['nr']) { foreach ($query_group['result'] as $res) { echo ''; } } echo '

TOTAL COUNT
' . $res->ucount . '

' . ' '; $query_user = $parent->selectQuery(DMS_HOUSER, "`emp_code`, `fname`, `lname`, `role`, `emailid`, `mobile`, `dealer_code`, `zone`, `created_on`, `modified_on`", "status='1'" . $cond, ""); if ($query_user['nr']) { $sno = 0; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { if ($sno == 0) { $arr = array_keys((array) $res_user); //print_r(array_keys($a)); exit; echo ''; foreach ($arr as $head) { echo ''; $sno++; } echo ''; foreach ($res_user as $val) { echo ''; } echo ''; } } echo '

#	' . $head . ''; } echo '
' . $sno++ . '	' . $val . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// dmsdealer //////////////////////////////////////////////// */ private function dmsdealer($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; $query_group = $parent->selectQuery(DMS_DEALER, "COUNT(id) ucount ", "status=1 AND is_deleted='0'", ""); $cond = ''; //FILTER $filter_arr = globalfunc::getFilterValues($parent, $parent->params[0]); if (count($filter_arr) > 0) { //dealer_code if (isset($filter_arr['dealer_code']) && $filter_arr['dealer_code'] != '') { $cond .= " AND dealer_code LIKE '%" . escape_str($filter_arr['dealer_code']) . "%' "; } //dealer_name if (isset($filter_arr['dealer_name']) && $filter_arr['dealer_name'] != '') { $cond .= " AND dealer_name LIKE '%" . escape_str($filter_arr['dealer_name']) . "%' "; } //city if (isset($filter_arr['city']) && $filter_arr['city'] != '') { $cond .= " AND city LIKE '%" . escape_str($filter_arr['lname']) . "%' "; } //state if (isset($filter_arr['state']) && $filter_arr['state'] != '') { $cond .= " AND state LIKE '%" . escape_str($filter_arr['state']) . "%' "; } //mobile if (isset($filter_arr['mobile']) && $filter_arr['mobile'] != '') { $cond .= " AND mobile LIKE '%" . escape_str($filter_arr['mobile']) . "%' "; } //zone if (isset($filter_arr['zone']) && $filter_arr['zone'] != '') { $cond .= " AND zone LIKE '%" . escape_str($filter_arr['zone']) . "%' "; } //zm_name if (isset($filter_arr['zm_name']) && $filter_arr['zm_name'] != '') { $cond .= " AND zm_name LIKE '%" . escape_str($filter_arr['zm_name']) . "%' "; } //rm_name if (isset($filter_arr['rm_name']) && $filter_arr['rm_name'] != '') { $cond .= " AND rm_name LIKE '%" . escape_str($filter_arr['rm_name']) . "%' "; } //am_name if (isset($filter_arr['am_name']) && $filter_arr['am_name'] != '') { $cond .= " AND am_name LIKE '%" . escape_str($filter_arr['am_name']) . "%' "; } //zm_email if (isset($filter_arr['zm_email']) && $filter_arr['zm_email'] != '') { $cond .= " AND zm_email LIKE '%" . escape_str($filter_arr['zm_email']) . "%' "; } //rm_email if (isset($filter_arr['rm_email']) && $filter_arr['rm_email'] != '') { $cond .= " AND rm_email LIKE '%" . escape_str($filter_arr['rm_email']) . "%' "; } //am_email if (isset($filter_arr['am_email']) && $filter_arr['am_email'] != '') { $cond .= " AND am_email LIKE '%" . escape_str($filter_arr['am_email']) . "%' "; } //zm_mobile if (isset($filter_arr['zm_mobile']) && $filter_arr['zm_mobile'] != '') { $cond .= " AND zm_mobile LIKE '%" . escape_str($filter_arr['zm_mobile']) . "%' "; } //rm_mobile if (isset($filter_arr['rm_mobile']) && $filter_arr['rm_mobile'] != '') { $cond .= " AND rm_mobile LIKE '%" . escape_str($filter_arr['rm_mobile']) . "%' "; } //zm_mobile if (isset($filter_arr['am_mobile']) && $filter_arr['am_mobile'] != '') { $cond .= " AND am_mobile LIKE '%" . escape_str($filter_arr['am_mobile']) . "%' "; } } echo '

HYPER-M - DEALER DATA

' . ''; if ($query_group['nr']) { foreach ($query_group['result'] as $res) { echo ''; } } echo '

TOTAL COUNT
' . $res->ucount . '

' . ' '; $query_user = $parent->selectQuery(DMS_DEALER, " `dealer_code`, `dealer_name`,address,email,phone, `city`, `state`, `zone`, `zm_name`, `rm_name`, `am_name`, `zm_email`, `rm_email`, `am_email`, `zm_mobile`, `rm_mobile`, `am_mobile` ", "status='1' AND is_deleted=0" . $cond, ""); if ($query_user['nr']) { $sno = 0; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { if ($sno == 0) { $arr = array_keys((array) $res_user); //print_r(array_keys($a)); exit; echo ''; foreach ($arr as $head) { echo ''; $sno++; } echo ''; foreach ($res_user as $val) { echo ''; } echo ''; } } echo '

#	' . $head . ''; } echo '
' . $sno++ . '	' . $val . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// dmssales //////////////////////////////////////////////// */ private function dmssales($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; $cond = ''; //print_r($parent->params);exit; $filter_arr = globalfunc::getFilterValues($parent, $parent->params[0]); //print_r( $filter_arr); if (isset($filter_arr['year']) && $filter_arr['year'] != '' && isset($filter_arr['month']) && $filter_arr['month'] != '') { $cond = " AND sale_date>='" . date('Y-m-d', strtotime($filter_arr['year'] . "-" . $filter_arr['month'] . "-01")) . "' AND sale_date<='" . date('Y-m-t', strtotime($filter_arr['year'] . "-" . $filter_arr['month'] . "-01")) . "'"; } if (isset($filter_arr['model']) && $filter_arr['model'] != '') { $cond .= " AND model LIKE '%" . escape_str($filter_arr['model']) . "%'"; } if (isset($filter_arr['smpin']) && $filter_arr['smpin'] != '') { $cond .= " AND smpin LIKE '%" . escape_str($filter_arr['smpin']) . "%'"; } echo '

HYPER-M - DSE SALES DATA

'; echo '

' . ' '; $query_user = $parent->selectQuery(DMS_EMPLOYEE_SALES, " `smpin`, `model`, `sale_date`, `sales_count`, `created_on`, `modified_on` ", "1=1 " . $cond, ""); if ($query_user['nr']) { $sno = 0; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { if ($sno == 0) { $arr = array_keys((array) $res_user); //print_r(array_keys($a)); exit; echo ''; foreach ($arr as $head) { echo ''; $sno++; } echo ''; foreach ($res_user as $val) { echo ''; } echo ''; } } echo '

#	' . $head . ''; } echo '
' . $sno++ . '	' . $val . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// dmstarget //////////////////////////////////////////////// */ private function dmstarget($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; $cond = ''; //print_r($parent->params);exit; $filter_arr = globalfunc::getFilterValues($parent, $parent->params[0]); //print_r( $filter_arr); if (isset($filter_arr['year']) && $filter_arr['year'] != '' && isset($filter_arr['month']) && $filter_arr['month'] != '') { $cond = " AND sale_month>='" . date('Y-m-d', strtotime($filter_arr['year'] . "-" . $filter_arr['month'] . "-01")) . "' AND sale_month<='" . date('Y-m-t', strtotime($filter_arr['year'] . "-" . $filter_arr['month'] . "-01")) . "'"; } if (isset($filter_arr['model']) && $filter_arr['model'] != '') { $cond .= " AND model LIKE '%" . escape_str($filter_arr['model']) . "%'"; } if (isset($filter_arr['smpin']) && $filter_arr['smpin'] != '') { $cond .= " AND smpin LIKE '%" . escape_str($filter_arr['smpin']) . "%'"; } echo '

HYPER-M - DSE TARGET DATA

'; echo '

' . ' '; $query_user = $parent->selectQuery(TABLE_USER_SALETARGET, " `smpin`, `model`, `sale_month`, `target`, `created_on`, `modified_on` ", "1=1 " . $cond, ""); if ($query_user['nr']) { $sno = 0; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { if ($sno == 0) { $arr = array_keys((array) $res_user); //print_r(array_keys($a)); exit; echo ''; foreach ($arr as $head) { echo ''; $sno++; } echo ''; foreach ($res_user as $val) { echo ''; } echo ''; } } echo '

#	' . $head . ''; } echo '
' . $sno++ . '	' . $val . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// dmsrewardpoints //////////////////////////////////////////////// */ private function dmsrewardpoints($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; $cond = ''; //FILTER $filter_arr = globalfunc::getFilterValues($parent, $parent->params[0]); if (count($filter_arr) > 0) { //smpin if (isset($filter_arr['smpin']) && $filter_arr['smpin'] != '') { $cond .= " AND u.smpin LIKE '%" . escape_str($filter_arr['smpin']) . "%' "; } //emp_code if (isset($filter_arr['emp_code']) && $filter_arr['emp_code'] != '') { $cond .= " AND u.emp_code LIKE '%" . escape_str($filter_arr['emp_code']) . "%' "; } //fname if (isset($filter_arr['fname']) && $filter_arr['fname'] != '') { $cond .= " AND u.fname LIKE '%" . escape_str($filter_arr['fname']) . "%' "; } //lname if (isset($filter_arr['lname']) && $filter_arr['lname'] != '') { $cond .= " AND u.lname LIKE '%" . escape_str($filter_arr['lname']) . "%' "; } //dealer_code if (isset($filter_arr['dealer_code']) && $filter_arr['dealer_code'] != '') { $cond .= " AND u.dealer_code LIKE '%" . escape_str($filter_arr['dealer_code']) . "%' "; } //role if (isset($filter_arr['role']) && $filter_arr['role'] != '') { $cond .= " AND u.role LIKE '%" . escape_str($filter_arr['role']) . "%' "; } //role if (isset($filter_arr['mobile']) && $filter_arr['mobile'] != '') { $cond .= " AND u.mobile LIKE '%" . escape_str($filter_arr['mobile']) . "%' "; } //city if (isset($filter_arr['city']) && $filter_arr['city'] != '') { $cond .= " AND d.city LIKE '%" . escape_str($filter_arr['city']) . "%' "; } //zone if (isset($filter_arr['zone']) && $filter_arr['zone'] != '') { $cond .= " AND d.zone LIKE '%" . escape_str($filter_arr['zone']) . "%' "; } } $query_group = $parent->selectQuery(DMS_EMPLOYEE, "COUNT(id) ucount ", "status=1", ""); echo '

HYPER-M - EMPLOYEE MASTER DATA

' . ''; if ($query_group['nr']) { foreach ($query_group['result'] as $res) { echo ''; } } echo '

TOTAL COUNT
' . $res->ucount . '

' . ' '; $query_user = $parent->selectQuery(DMS_EMPLOYEE . " u JOIN " . TABLE_USER . " as user ON user.smpin=u.smpin AND user.role>7 AND user.role<14 LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code LEFT JOIN " . TABLE_USER_EPOINTS . " p ON u.smpin=p.smpin", "u.`smpin`, u.`emp_code`, u.`fname`,u. `lname`,p.points, u.`dealer_code`,u. `role`, u.`emailid`, u.`mobile`,d.dealer_name,d.city,d.zone,u.created_on,u.modified_on", "u.status='1' " . $cond . " ORDER BY p.points DESC ", ""); if ($query_user['nr']) { $sno = 0; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { if ($sno == 0) { $arr = array_keys((array) $res_user); //print_r(array_keys($a)); exit; echo ''; foreach ($arr as $head) { echo ''; $sno++; } echo ''; foreach ($res_user as $val) { echo ''; } echo ''; } } echo '

#	' . $head . ''; } echo '
' . $sno++ . '	' . $val . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// LAST ACCESS USER //////////////////////////////////////////////// */ private function lastaccess($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); $data_arr = array(); $limit_str = globalfunc::setPageLimit($parent, $parent->params[0]); $limit_cond = ($limit_str) ? " LIMIT " . $limit_str : ''; // $query_group=$parent->selectQuery(TABLE_USER." u JOIN ".TABLE_ROLE." r ON u.role=r.id LEFT JOIN ".DMS_DEALER." d ON d.dealer_code=u.dealer_code" ,"COUNT(u.userid) ucount , r.rolename ","u.is_deleted=0 AND u.role>7 AND u.role<14 GROUP BY u.role",""); echo '

HYPER-M - REGISTERED USER LIST

' . ''; $query_user = $parent->selectQuery(TABLE_USER . " u LEFT JOIN " . TABLE_USER_LOG . " l ON u.userid=l.userid JOIN " . TABLE_ROLE . " r ON u.role=r.id LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code", "u.smpin,u.emp_code,u.fname, u.`lname`, u.`emailid`, u.`mobileno`,u.created_on,r.rolename,u.dealer_code,d.dealer_name,d.city,d.zone,d.`zm_name`, d.`rm_name`, d.`am_name`,MAX(l.created_on) as last_access", "u.is_deleted=0 AND u.role>7 AND u.role<14 GROUP BY u.userid ORDER BY last_access DESC", ""); if ($query_user['nr']) { $sno = 1; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $res_user) { $dealer_code = ($res_user->dealer_code != '') ? $res_user->dealer_code : ''; $dealer_data = ($res_user->dealer_code != '') ? $res_user->dealer_name : ''; //,
'.$res_user->city.',
'.$res_user->zone $last_access = ($res_user->last_access) ? date('d-m-Y h:i A ', strtotime($res_user->last_access)) : ''; echo ''; } } echo '

#	ROLE	SMPIN	EMP CODE	NAME	DEALER CODE	DEALER	Zone	City	ZM	RM	AM	MOBILE	EMAIL	REGISTERED DATE	LAST ACCESS DATE
' . $sno++ . '	' . $res_user->rolename . '	' . $res_user->smpin . '	' . $res_user->emp_code . '	' . $res_user->fname . " " . $res_user->lname . '	' . $dealer_code . '	' . $dealer_data . '	' . $res_user->zone . '	' . $res_user->city . '	' . $res_user->zm_name . '	' . $res_user->rm_name . '	' . $res_user->am_name . '	' . $res_user->mobileno . '	' . $res_user->emailid . '	' . date('d-m-Y h:i A ', strtotime($res_user->created_on)) . '	' . $last_access . '

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ /* /////////////////////////////// CUSTOMER EXPERIENCE //////////////////////////////////////////////// */ private function customerexperience($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 1); echo '

HYPER-M - CUSTOMER EXPERIENCE LIST

' . ''; // SELECT FROM tbl__user_customerexp cust LEFT JOIN tbl__ex_enquiry enq ON enq.customerid=cust.id LEFT JOIN tbl__ex_model vm ON vm.model_id=enq.model_id LEFT JOIN tbl__ex_modelvariant vv ON vv.model_id=enq.model_id INNER JOIN tbl__user usr ON usr.userid=cust.userid INNER JOIN tbl__dms_dealer dlr ON dlr.dealer_code=usr.dealer_code WHERE dlr.dealer_code='97105' $query_user = $parent->selectQuery(TABLE__CUSTOMEREXP . " cust LEFT JOIN " . TABLE_EXPLORE_ENQUIRY . " enq ON enq.customerid=cust.id LEFT JOIN " . TABLE_COMPARE_MODEL . " vm ON vm.model_id=enq.model_id LEFT JOIN " . TABLE_MODEL_VARIANT . " vv ON vv.model_id=enq.model_id INNER JOIN " . TABLE_USER . " usr ON usr.userid=cust.userid INNER JOIN " . DMS_DEALER . " dlr ON dlr.dealer_code=usr.dealer_code", "CONCAT(CONCAT(cust.salutation, ' ', cust.firstname), ' ', cust.lastname) customer_name, cust.mobile customer_mobile, cust.email customer_email, vm.model_name, vv.title varient, usr.dealer_code, dlr.dealer_name, dlr.am_name area_manager, dlr.rm_name regional_manager, dlr.zm_name zone_manager, cust.created_on customer_created, enq.created_on enquiry_on, IF(ISNULL(enq.created_on),'Not Done', 'DONE') enquiry_status ", "1=1 ORDER BY cust.created_on ASC", ""); if ($query_user['nr']) { $sno = 1; //$s3=awsfileserver::connectS3(); foreach ($query_user['result'] as $Key => $res_user) { if ($Key == 0) { echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } } echo '

#	" . $key . "
" . ($Key + 1) . "	" . $res . "

';exit; } /* //////////////////////////////////////////////////////////////////////////////////////////// */ private function activesmpin($parent) { globalfunc::checkMethodType($parent, array('GET')); globalfunc::checkParamCount($parent, 2); $smpin = escape_str($parent->params[1]); //USER TABLE $query_arr = $parent->selectQuery(TABLE_USER . " u LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code", "u.userid, u.`smpin`, u.`fname`, u.`lname`, u.`emailid`,u. `mobileno`,u.`dealer_code`, d.`dealer_name`, d.`city`, d.`state`, d.`zone`", "u.is_deleted=0 AND u.status!=1 AND u.role>7 AND role!=14 AND u.smpin='" . $smpin . "'", "1"); if ($query_arr['nr'] > 0) { $updatequery = $parent->executeQuery("UPDATE " . TABLE_USER . " SET status='1' WHERE smpin='" . $smpin . "' AND userid='" . $query_arr['result'][0]->userid . "'"); echo '

HYPER-M - USER DETAILS

User data Activated

' . ''; foreach ($query_arr['result'] as $Key => $res_user) { if ($Key == 0) { echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } echo '

#	" . $key . "
" . ($Key + 1) . "	" . $res . "

';exit; } else { //USER TABLE $query_arr = $parent->selectQuery(TABLE_USER . " u LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code", "u.userid, u.`smpin`, u.`fname`, u.`lname`, u.`emailid`,u. `mobileno`,u.`dealer_code`, d.`dealer_name`, d.`city`, d.`state`, d.`zone`,u.is_deleted,u.status,u.inactivated_on,u.created_on,u.modified_on", " u.role>7 AND role!=14 AND u.smpin='" . $smpin . "'", "1"); echo '

HYPER-M - USER DETAILS

'; echo "

User not inactive please check database.

"; if ($query_arr['nr'] > 0) { echo "

User table

"; echo ''; foreach ($query_arr['result'] as $Key => $res_user) { if ($Key == 0) { echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } echo '

#	" . $key . "
" . ($Key + 1) . "	" . $res . "

'; } else { echo "

User table data not found

"; } //EMPLOLYEE TABLE $query_arr = $parent->selectQuery(DMS_EMPLOYEE . " u LEFT JOIN " . DMS_DEALER . " d ON d.dealer_code=u.dealer_code", "u.*, d.`dealer_name`, d.`city`, d.`state`, d.`zone` ", " u.smpin='" . $smpin . "'", "1"); if ($query_arr['nr'] > 0) { echo ''; echo "

Employee table

"; foreach ($query_arr['result'] as $Key => $res_user) { if ($Key == 0) { echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } echo ""; foreach ($res_user as $key => $res) { echo ""; } echo ""; } echo '

#	" . $key . "
" . ($Key + 1) . "	" . $res . "

'; } else { echo "

Emplolyee table data not found

"; } echo '';exit; } } private function loginlog($parent) { globalfunc::checkMethodType($parent, array('GET')); $query_arr = $parent->selectQuery(TABLE_USER, "userid,CONCAT(fname,lname) as name,emp_code", " role=5 ", ""); echo '

HYPER-M - LOGIN DETAILS

'; $month = "10"; $year = "2019"; $start_date = $year . "-" . $month . "-01"; $start_time = strtotime($start_date); $end_time = strtotime("+1 month", $start_time); for ($i = $start_time; $i < $end_time; $i += 86400) { $list[] = date('Y-m-d', $i); } //print_r($list); echo ''; foreach ($list as $res) { echo ''; } echo ''; if ($query_arr['nr'] > 0) { foreach ($query_arr['result'] as $res_val) { echo ''; foreach ($list as $res) { $log_arr = $parent->selectQuery(TABLE_USER_LOG, "MAX(created_on)as tdate", " userid='" . $res_val->userid . "' AND date_format(created_on,'%Y-%m-%d')='" . $res . "'", "1"); $date_str = ($log_arr['nr'] > 0 && $log_arr['result'][0]->tdate != '') ? date('h:i A', strtotime($log_arr['result'][0]->tdate)) : ''; echo ''; } echo ''; } } echo '

Name	EMP CODE	' . date('d-m-Y', strtotime($res)) . '
' . $res_val->name . '	' . $res_val->emp_code . '	' . $date_str . '

';exit; } private function dealerenquiryinactive($parent) { globalfunc::checkParamCount($parent, 2); if (IS_LIVE_SERVER) { $parent->response(array('response' => 'failed', 'message' => 'PAGE NOT FOUND'), 404); } echo $dealer_code = escape_str($parent->params[1]); if ($dealer_code) { $parent->executeQuery(" UPDATE " . DMS_DEALER . " SET is_enquirymodule='0' WHERE dealer_code='" . $dealer_code . "'"); } $parent->response(array('response' => 'success', 'message' => "SUCCESS"), 200); } }