public function addAction()
{
$this->view->messages = $this->_flashMessenger->getMessages();
$this->_helper->layout->disableLayout();
$formData = array();
$formErrors = array();
$formData = $this->getRequest()->getPost();
if ($this->getRequest()->isPost() && isset($formData['add_author']) && $formData['add_author'] == 'Add Author') {
$formData = $this->getRequest()->getPost();
if (!isset($formData['first_name']) || trim($formData['first_name']) == "") {
$formErrors['first_name'] = "Please enter first name";
}
if (!isset($formData['last_name']) || trim($formData['last_name']) == "") {
$formErrors['last_name'] = "Please enter last name";
}
if (isset($formData['emailid']) && trim($formData['emailid']) != "") {
if (!CommonFunctions::isValidEmail($formData['emailid'])) {
if (!array_key_exists('emailid', $formErrors)) {
$formErrors['emailid'] = "Please enter valid email";
}
}
}
if ($formData['emailid'] != '') {
if ($this->modelAuthor->isExist('emailid="' . $formData['emailid'] . '" and parent_id!="0"')) {
if (!array_key_exists('emailid', $formErrors)) {
$formErrors['emailid'] = "Email already exist";
}
}
}
if (count($formErrors) == 0) {
if ($this->getRequest()->isPost()) {
$activationCode = CommonFunctions::generateGUID();
$add_time = date('Y-m-d H:i:s');
//$formData['password']=CommonFunctions::getRandomNumberPassword(8);
$enc_password = md5($formData['password']);
$formData['parent_publisher_id'] = !empty($this->sessPublisherInfo->id) ? $this->sessPublisherInfo->id : 0;
$username_array = explode("@", $formData['emailid']);
$formData['username'] = $username_array[0];
$authorData = array('user_type' => 'author', 'parent_id' => $formData['parent_publisher_id'], 'username' => $formData['username'], 'emailid' => $formData['emailid'], 'password' => $enc_password, 'first_name' => $formData['first_name'], 'last_name' => $formData['last_name'], 'phone' => $formData['phone'], 'profile_status' => '1', 'updated_date' => date("Y-m-d H:i:s"), 'add_time' => $add_time);
$lastId = $this->modelAuthor->insert($authorData);
if ($lastId > 0) {
$this->_flashMessenger->addMessage('<div class="div-success">Author Added successfully</div>');
$this->_redirect('publisher/author/index/tab_ajax/author/');
}
}
} else {
$this->view->errorMessage = '<div class="div-error">Please enter required fields to register.</div>';
}
} else {
$formData['user_type'] = "";
$formData['first_name'] = "";
$formData['last_name'] = "";
$formData['emailid'] = "";
$formData['password'] = "";
}
$this->view->formData = $formData;
$this->view->formErrors = $formErrors;
}
public function createAction()
{
$this->view->messages = $this->_flashMessenger->getMessages();
$this->_helper->layout->disableLayout();
$formData = array();
$formErrors = array();
$formData = $this->getRequest()->getPost();
//print_r($formData);exit;
if ($this->getRequest()->isPost() && isset($formData['create_group']) && $formData['create_group'] == 'Create') {
if (!isset($formData['user_type']) || trim($formData['user_type']) == "") {
$formErrors['user_type'] = "Please select user type ";
}
if (!isset($formData['first_name']) || trim($formData['first_name']) == "") {
$formErrors['first_name'] = "Please enter first name";
}
if (!isset($formData['last_name']) || trim($formData['last_name']) == "") {
$formErrors['last_name'] = "Please enter last name";
}
if (!isset($formData['emailid']) || trim($formData['emailid']) == "") {
$formErrors['emailid'] = "Please enter email";
}
/*if(!(isset($formData['password'])) || trim($formData['password'])=="")
{
$formErrors['password']="******";
}
*/
if (!CommonFunctions::isValidEmail($formData['emailid'])) {
if (!array_key_exists('emailid', $formErrors)) {
$formErrors['emailid'] = "Please enter valid email";
}
}
/*if($this->modelGroup->isExist('username="******"'))
{
if(!(array_key_exists('username',$formErrors)))
{
$formErrors['username']="******";
}
}
*/
if ($this->modelPublisher->isExist('emailid="' . $formData['emailid'] . '"') || $this->modelCompany->isExist('user_email="' . $formData['emailid'] . '"')) {
if (!array_key_exists('emailid', $formErrors)) {
$formErrors['emailid'] = "Email already exist";
}
}
if (count($formErrors) == 0) {
if ($this->getRequest()->isPost()) {
$activationCode = CommonFunctions::generateGUID();
$add_time = date('Y-m-d H:i:s');
$formData['password'] = CommonFunctions::getRandomNumberPassword(8);
$formData['publisher_author_id'] = !empty($this->parentPublisherId) ? $this->parentPublisherId : 0;
$username_array = explode("@", $formData['emailid']);
$formData['username'] = $username_array[0];
$groupUserData = array('parent_id' => $formData['publisher_author_id'], 'user_type' => $formData['user_type'], 'username' => $formData['username'], 'emailid' => $formData['emailid'], 'password' => $formData['password'], 'first_name' => $formData['first_name'], 'last_name' => $formData['last_name'], 'phone' => $formData['phone'], 'profile_status' => '1', 'updated_date' => date("Y-m-d H:i:s"), 'add_time' => $add_time);
$lastId = $this->modelPublisher->insert($groupUserData);
//$lastId=$this->modelGroup->insert($groupUserData);
if ($lastId > 0) {
$mailhost = SMTP_SERVER;
$mailconfig = array('ssl' => SMTP_SSL, 'port' => SMTP_PORT, 'auth' => SMTP_AUTH, 'username' => SMTP_USERNAME, 'password' => SMTP_PASSWORD);
$transport = new Zend_Mail_Transport_Smtp($mailhost, $mailconfig);
Zend_Mail::setDefaultTransport($transport);
$message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Electronic Vendor Ltd</title>
<style type="text/css">
body{
margin:0;
padding:0px;
}
#container{
width:700px;
margin:0 auto;
}
#header{
width:700px;
float:left;
padding:40px 0 10px 0;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
text-align:center;
font-size:11px;
}
#header a{
color:#3A3B3F;
font-weight:bold;
text-decoration:none;
}
#header a:hover{
color:#40BBE3;
}
#logopart
{
border:0px solid red;
width:698px;
height:140px;
background-color:#1B75BB;
margin-left:0px;
}
#content{
width:698px;
float:left;
padding:0px 0px 10px 0px;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
border:1px solid #D6D6D6;
font-size:12px;
}
#content p{
margin:0px 20px;
padding:0px 0 20px 0;
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color:#3A3B3F;
}
#content p.logo{
margin:0px;
padding:15px 0 0 20px;
height:77px
}
#content p.title{
margin:0px;
font-size:20px;
font-family:Arial, Helvetica, sans-serif;
border-bottom:3px solid #D6D6D6;
padding:0px 0 13px 0;
margin:25px 20px 14px 20px;
color:#3A3B3F;
}
#content p a{
color:#40BBE3;
text-decoration:none;
}
#content p a:hover{
color:#3A3B3F;
text-decoration:underline;
}
#content h2{
margin:0px;
padding:0 0 14px 0;
font-size:14px;
font-family:Arial, Helvetica, sans-serif;
font-weight:bold;
}
#footer{
width:700px;
float:left;
}
#footer p{
margin:0 0 0 0;
padding:0 0 0 0;
font-family:Arial, Helvetica, sans-serif;
font-size:11px;
color:#78797E;
}
#footer p.disclamer{
margin: 0 0 0 0;
padding:16px 6px 10px 6px;
text-align: justify;
border-bottom:1px solid #3A3B3F;
color:#78797E;
}
#footer p.notice{
margin: 0 0 15px 0;
padding:16px 6px 10px 6px;
text-align: justify;
color:#78797E;
}
</style>
</head>
<body>
<div id="container">
<div id="header"></div>
<div id="content">
<div id="logopart">
<p class="logo"><a href="' . SVN_URL . '" target="_blank">
Electronic Vendor Ltd
</a></p>
</div>
<p class="title">Group User Registration Email</p>
<p>Your login details given below :</p>
<p>Username: ' . $formData['username'] . '</p>
<p>Password: ' . $formData['password'] . '</p>
<BR />
<p> </p>
</div>
<div id="footer"> </div>
</div>
</body>
</html>';
$mail = new Zend_Mail();
$mail->addTo($formData['emailid']);
$mail->setSubject("Group User Registration Email");
$mail->setBodyHtml($message);
$mail->setFrom(SETFROM, SETNAME);
if ($mail->send()) {
$this->_flashMessenger->addMessage('<div class="div-success">Group created successfully</div>');
} else {
$this->view->errorMessage = '<div class="div-error">Mail could not be sent. Try again later.</div>';
}
$this->_redirect('publisher/group/index/tab_ajax/group/');
}
}
} else {
$this->view->errorMessage = '<div class="div-error">Please enter required fields to register.</div>';
}
} else {
$formData['user_type'] = "";
$formData['first_name'] = "";
$formData['last_name'] = "";
$formData['emailid'] = "";
$formData['password'] = "";
}
$this->view->formData = $formData;
$this->view->formErrors = $formErrors;
}
public function indexAction()
{
$this->view->messages = $this->_flashMessenger->getMessages();
$formData = array();
$formErrors = array();
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
//print_r($formData);exit;
//=====================START FORM VALIDATION===================================
if (!isset($formData['first_name']) || trim($formData['first_name']) == "") {
$formErrors['first_name'] = "Please enter your first name";
}
if (!isset($formData['last_name']) || trim($formData['last_name']) == "") {
$formErrors['last_name'] = "Please enter your last name";
}
if (!isset($formData['user_email']) || trim($formData['user_email']) == "") {
$formErrors['user_email'] = "Please enter your email";
}
if (!isset($formData['user_password']) || trim($formData['user_password']) == "") {
$formErrors['user_password'] = "******";
}
/*if(!(isset($formData['verify_user_password'])) || trim($formData['verify_user_password'])=="")
{
$formErrors['verify_user_password']="******";
}
if($formData['user_password']!=$formData['verify_user_password'])
{
$formErrors['verify_user_password']="******";
}
*/
if (!isset($formData['agree']) || trim($formData['agree']) == "") {
$formErrors['agree'] = "Please check agree";
}
if (!CommonFunctions::isValidEmail($formData['user_email'])) {
if (!array_key_exists('user_email', $formErrors)) {
$formErrors['user_email'] = "Please enter valid email";
}
}
if ($this->modelCompany->isExist('user_email="' . $formData['user_email'] . '"') || $this->modelPublisher->isExist('emailid="' . $formData['user_email'] . '"') || $this->modelGroup->isExist('emailid="' . $formData['user_email'] . '"') || $this->modelMember->isExist('emailid="' . $formData['user_email'] . '"')) {
if (!array_key_exists('user_email', $formErrors)) {
$formErrors['user_email'] = "Email already exist";
}
}
//=====================END FORM VALIDATION===================================
if (count($formErrors) == 0) {
//$sessionPost = new Zend_Session_Namespace('step1Post');
//$sessionPost->formData=$formData;
//$this->_redirect('company/register/step2');
$activationCode = CommonFunctions::generateGUID();
$username_array = explode("@", $formData['user_email']);
$formData['username'] = $username_array[0];
$companyData = array('first_name' => $formData['first_name'], 'last_name' => $formData['last_name'], 'account_type' => 1, 'user_name' => $formData['username'], 'user_email' => $formData['user_email'], 'user_password' => $formData['user_password'], 'country' => $formData['country'], 'added_date' => date("Y-m-d H:i:s"), 'updated_date' => date("Y-m-d H:i:s"), 'activation_code' => $activationCode, 'status' => '0');
$lastId = $this->modelCompany->insert($companyData);
if ($lastId > 0) {
$mailhost = SMTP_SERVER;
$mailconfig = array('ssl' => SMTP_SSL, 'port' => SMTP_PORT, 'auth' => SMTP_AUTH, 'username' => SMTP_USERNAME, 'password' => SMTP_PASSWORD);
$transport = new Zend_Mail_Transport_Smtp($mailhost, $mailconfig);
Zend_Mail::setDefaultTransport($transport);
$message = '<!DOCTYPE html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1.0">
<title>Evendor</title>
</head>
<body style="font-family: \'Calibri\', arial;">
<div id="container" style="width:80%; margin:0 auto;">
<header id="heder">
<div style="padding:15px 0px; background:#000000;"><a href="' . $this->view->serverUrl() . $this->view->baseUrl() . '/" target="_blank"><img src="' . $this->view->serverUrl() . $this->view->baseUrl() . '/public/css/default/images/logo.png" style="border:none;" alt="E-Vendor"></a></div>
</header>
<div style="background:#656565; padding:15px; min-height:200px;">
<aside>
<p style="color:#FFBF00; font-weight:bold;">User Registration Email</p>
<p style="color:#ffffff; font-weight:bold;">Your login details given below :</p>
<p style="color:#ffffff;"><label style="color:#FFBF00; font-weight:bold; display:inline-block; width:100px;">Username:</label>' . $formData['user_email'] . '</p>
<p style="color:#ffffff;"><label style="color:#FFBF00; font-weight:bold; display:inline-block; width:100px;">Password:</label>' . $formData['user_password'] . '</p>
<BR />
<p style="color:#ffffff;">Activate your account by using given below link :</p>
<BR />
<p style="color:#ffffff;"><a href="' . $this->view->serverUrl() . $this->view->baseUrl() . '/company/register/verification/' . $activationCode . '">Account Activation Link</a></p>
<br>
<p> </p>
</aside>
</div>
<div style="background:#000000; text-align:center; color:#FFFFFF; font-size:14px; padding:15px;">
<br>
© Copyright ' . date("Y") . ' All Rights Reserved By Electronic Vendor Ltd.
</div>
</div>
</body>
</html>';
$mail = new Zend_Mail();
$mail->addTo($formData['user_email']);
$mail->setSubject("Company Registration Email");
$mail->setBodyHtml($message);
$mail->setFrom(SETFROM, SETNAME);
if ($mail->send()) {
$this->_redirect('company/register/thanks');
} else {
$this->view->errorMessage = '<div class="div-error">Mail could not be sent. Try again later.</div>';
}
}
} else {
$this->view->errorMessage = '<div class="div-error">Please enter required fieild to register.</div>';
}
}
$this->view->formData = $formData;
$this->view->formErrors = $formErrors;
}
public function postAction()
{
// Database Object
$db = Zend_Registry::get('db');
$formData = $this->getRequest()->getPost();
//print_r($formData);
//exit;
if (is_array($formData)) {
if (get_magic_quotes_gpc()) {
$json_data = stripslashes($formData['jsondata']);
} else {
$json_data = $formData['jsondata'];
}
/********** Json Object Array ************************/
$jsonObj = json_decode($json_data);
$jsonObj = $jsonObj[0];
/********** Json Object Array ************************/
/********** Json Array ********************/
//$jsonArray = json_decode($json_data,true);
/********** Json Array *******************/
switch ($jsonObj->apicall) {
case "UserRegistration":
$Errorresponse = "";
if (!isset($jsonObj->FirstName) || trim($jsonObj->FirstName) == "" || !isset($jsonObj->LastName) || trim($jsonObj->LastName) == "" || !isset($jsonObj->EmailId) || trim($jsonObj->EmailId) == "" || !isset($jsonObj->Password) || trim($jsonObj->Password) == "") {
$Errorresponse = '[{"ParameterMissing":{';
if (!isset($jsonObj->FirstName) || trim($jsonObj->FirstName) == "") {
$Errorresponse .= '"FirstName":"Please Enter First Name",';
}
if (!isset($jsonObj->LastName) || trim($jsonObj->LastName) == "") {
$Errorresponse .= '"LastName":"Please Enter Last Name",';
}
if (!isset($jsonObj->EmailId) || trim($jsonObj->EmailId) == "") {
$Errorresponse .= '"EmailId":"Please Enter Email Id",';
}
if (!isset($jsonObj->Password) || trim($jsonObj->Password) == "") {
$Errorresponse .= '"Password":"******",';
}
//if(!(isset($jsonObj->Country)) || trim($jsonObj->Country)=="")
//{
//$Errorresponse.='"Country":"Please Select A Country"';
//}
$Errorresponse .= '}}]';
}
if (!empty($Errorresponse)) {
//echo $Errorresponse;
$response = '{
"Message":"All fields are compulsory.",
"error":"true"
}';
echo $response;
} else {
$sql = 'SELECT * FROM pclive_companies where user_email="' . $jsonObj->EmailId . '"';
$result = $db->query($sql);
$record = $result->FetchAll();
$sql1 = 'SELECT * FROM pclive_users where emailid="' . $jsonObj->EmailId . '"';
$result1 = $db->query($sql1);
$record1 = $result1->FetchAll();
if (count($record) > 0 || count($record1) > 0) {
$response = '{
"Message":"Email Id already exists",
"error":"true"
}';
echo $response;
} else {
$user_name = explode("@", $jsonObj->EmailId);
$user_name = $user_name[0];
$activationCode = CommonFunctions::generateGUID();
$sql = "INSERT INTO pclive_companies (parent_id,group_id,first_name,last_name,account_type,user_name,user_email,user_password,country,status,added_date,updated_date,activation_code)VALUES('0','0','" . $jsonObj->FirstName . "','" . $jsonObj->LastName . "','2','{$user_name}','" . $jsonObj->EmailId . "','" . md5($jsonObj->Password) . "','226','0', NOW(),NOW(),'" . $activationCode . "')";
$result = $db->query($sql);
if ($result) {
$apikeysql = 'SELECT * FROM pclive_apikeys ORDER BY RAND() LIMIT 0,1';
$apikeyresult = $db->query($apikeysql);
$apikeyrecord = $apikeyresult->FetchAll();
if (count($apikeyrecord) == 1) {
$response = '{
"Message":"You have registered successfully.\\n Your account activation url is sent to your email.",
"error":"false"
}';
$mailhost = SMTP_SERVER;
$mailconfig = array('ssl' => SMTP_SSL, 'port' => SMTP_PORT, 'auth' => SMTP_AUTH, 'username' => SMTP_USERNAME, 'password' => SMTP_PASSWORD);
$transport = new Zend_Mail_Transport_Smtp($mailhost, $mailconfig);
Zend_Mail::setDefaultTransport($transport);
$message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Electronic Vendor Ltd</title>
</head>
<body>
<p>Your login details given below :<br></p>
<p>Username: ' . $jsonObj->EmailId . '</p>
<BR />
<p style="color:#ffffff;">Activate your account by using given below link :</p>
<BR />
<p style="color:#ffffff;"><a href="' . $this->view->serverUrl() . $this->view->baseUrl() . '/user/register/verification/' . $activationCode . '">Account Activation Link</a></p>
<br>
<p> </p>
</body>
</html>';
$mail = new Zend_Mail();
$mail->addTo($jsonObj->EmailId);
$mail->setSubject("Registration Email");
$mail->setBodyHtml($message);
$mail->setFrom(SETFROM, SETNAME);
if ($mail->send()) {
//$response ='{"Message":"Success", "Error":"False" }';
//echo $response;
}
}
echo $response;
} else {
$response = '{
"Message":"Registration failed, please try later again.",
"error":"true"
}';
echo $response;
}
}
// Check Email Exists
}
break;
case "UserLogin":
if (isset($jsonObj->EmailId) && !empty($jsonObj->EmailId) && isset($jsonObj->Password)) {
$sql = 'SELECT * FROM pclive_companies where user_email="' . $jsonObj->EmailId . '" AND user_password="******" AND status=1 and account_type!=1';
$result = $db->query($sql);
$record = $result->FetchAll();
/*
$sql2 = 'SELECT * FROM pclive_users where emailid="'.$jsonObj->EmailId.'" AND password="******"';
$result2 = $db->query($sql2);
$record2 = $result2->FetchAll();
*/
if (count($record) > 0) {
$apikeysql = 'SELECT * FROM pclive_apikeys ORDER BY RAND() LIMIT 0,1';
$apikeyresult = $db->query($apikeysql);
$apikeyrecord = $apikeyresult->FetchAll();
if (count($apikeyrecord) == 1) {
/*$response = '[{"LoginResponse":{
"Message":"Success",
"apikey":"'.$apikeyrecord[0]['apikey'].'"
}}]';*/
$sql1 = "SELECT * FROM pclive_country where id='" . $record[0]['country'] . "' ";
$result1 = $db->query($sql1);
$record1 = $result1->FetchAll();
$response = '{
"Message":"Success",
"apikey":"' . $apikeyrecord[0]['apikey'] . '",
"userid":"' . $record[0]['id'] . '",
"UserType":"user",
"countryid":"' . $record[0]['country'] . '",
"Country" : "' . $record1[0]['country'] . '",
"FirstName" : "' . $record[0]['first_name'] . '",
"LastName" : "' . $record[0]['last_name'] . '","Username":"******","Userpassword":"******","error":"false"
}';
//have to check fo device id
//if count<3 then onsert
$devicesql = 'SELECT * FROM pclive_deviceID where user_publisher_id="' . $record[0]['id'] . '" and table_name="pclive_companies"';
$deviceresult = $db->query($devicesql);
$devicerecord = $deviceresult->FetchAll();
$devicesqln = 'SELECT * FROM pclive_deviceID where user_publisher_id="' . $record[0]['id'] . '" and table_name="pclive_companies" and device_id="' . $jsonObj->DeviceId . '"';
$deviceresultn = $db->query($devicesqln);
$devicerecordn = $deviceresultn->FetchAll();
if (count($devicerecordn) == 0) {
if (count($devicerecord) < 3) {
//check with deviceID only, if exists then delete first
$devicesqlnew = 'delete FROM pclive_deviceID where device_id="' . $jsonObj->DeviceId . '" and table_name="pclive_companies"';
$deviceresultnew = $db->query($devicesqlnew);
//$devicerecordnew = $deviceresultnew->FetchAll();
$devicesqlinsert = 'insert into pclive_deviceID set user_publisher_id="' . $record[0]['id'] . '", table_name="pclive_companies",device_id="' . $jsonObj->DeviceId . '",reg_id="' . $jsonObj->reg_id . '", os_type="' . $jsonObj->os_type . '"';
$deviceinsertresult = $db->query($devicesqlinsert);
//insert
} else {
//can not login with this device id
$response = '{
"Message":"You can not log in on more than 3 devices. Please log in on our website to manage your devices",
"apikey":"",
"error":"true"
}';
}
}
}
echo $response;
} else {
/* $response = '[{"LoginResponse":{
"Error":"Invalid User Id or Password"
}}]';*/
$response = '{
"Message":"Invalid username or password.",
"apikey":"",
"error":"true"
}';
echo $response;
}
} else {
/*$response = '[{"LoginResponse":{
"Error":"User Id does not exist"
}}]';*/
$response = '{
"Message":"User Id does not exist.",
"apikey":"",
"error":"true"
}';
echo $response;
}
break;
case "UserLoginIphone":
if (isset($jsonObj->EmailId) && !empty($jsonObj->EmailId) && isset($jsonObj->Password)) {
$sql = 'SELECT * FROM pclive_companies where user_email="' . $jsonObj->EmailId . '" AND user_password="******" AND parent_id="0" and status=1 AND account_type<>"3"';
$result = $db->query($sql);
$record = $result->FetchAll();
if (count($record) > 0) {
$apikeysql = 'SELECT * FROM pclive_apikeys ORDER BY RAND() LIMIT 0,1';
$apikeyresult = $db->query($apikeysql);
$apikeyrecord = $apikeyresult->FetchAll();
if (count($apikeyrecord) == 1) {
/*$response = '[{"LoginResponse":{
"Message":"Success",
"apikey":"'.$apikeyrecord[0]['apikey'].'"
}}]';*/
$response = '{
"Message":"Success",
"apikey":"' . $apikeyrecord[0]['apikey'] . '",
"userid":"' . $record[0]['id'] . '",
"countryid":"' . $record[0]['country'] . '","Username":"******","Userpassword":"******","error":"false"
}';
}
echo $response;
} else {
/* $response = '[{"LoginResponse":{
"Error":"Invalid User Id or Password"
}}]';*/
$response = '{
"Message":"Unsuccess",
"apikey":"",
"error":"Invalid User Id or Password"
}';
echo $response;
}
} else {
/*$response = '[{"LoginResponse":{
"Error":"User Id does not exist"
}}]';*/
$response = '{
"Message":"Unsuccess",
"apikey":"",
"error":"User Id does not exist"
}';
echo $response;
}
break;
case "UserDetail":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
$sql = 'SELECT * FROM pclive_companies where id="' . $jsonObj->id . '" AND parent_id="0" AND account_type<>"3"';
$result = $db->query($sql);
$record = $result->FetchAll();
if (count($record) > 0) {
if ($record[0]['account_type'] == 1) {
$record[0]['account_type'] = "Company";
} elseif ($record[0]['account_type'] == 2) {
$record[0]['account_type'] = "Individual";
} else {
$record[0]['account_type'] = $record[0]['account_type'];
}
$sql1 = "SELECT * FROM pclive_country where id='" . $record[0]['country'] . "' ";
$result1 = $db->query($sql1);
$record1 = $result1->FetchAll();
$response = '[{"UserDetail":{
"UserType" : "' . $record[0]['account_type'] . '",
"UserEmail" : "' . $record[0]['user_email'] . '",
"FirstName" : "' . $record[0]['first_name'] . '",
"LastName" : "' . $record[0]['last_name'] . '",
"Countryid" : "' . $record[0]['country'] . '",
"Countryname" : "' . $record1[0]['country'] . '",
"JoinTime" : "' . $record[0]['added_date'] . '"
}}]';
echo $response;
} else {
$response = '[{"Error":{"Message":"Invalid User Id."}}]';
echo $response;
}
} else {
$response = '[{"Error":{"Message":"User Id does not exist"}}]';
echo $response;
}
break;
case "UserDetailIphone":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
//$sql = 'SELECT * FROM pclive_companies where id="'.$jsonObj->id.'" AND parent_id="0" AND account_type<>"3"';
$sql = 'SELECT * FROM pclive_companies where id="' . $jsonObj->id . '" AND status=1 and account_type!=1';
$result = $db->query($sql);
$record = $result->FetchAll();
if (count($record) > 0) {
if ($record[0]['account_type'] == 1) {
$record[0]['account_type'] = "Company";
} elseif ($record[0]['account_type'] == 2) {
$record[0]['account_type'] = "Individual";
} else {
$record[0]['account_type'] = $record[0]['account_type'];
}
$sql1 = "SELECT * FROM pclive_country where id='" . $record[0]['country'] . "' ";
$result1 = $db->query($sql1);
$record1 = $result1->FetchAll();
$response = '{"UserDetail":{
"UserType" : "' . $record[0]['account_type'] . '",
"Username" : "' . $record[0]['user_email'] . '",
"FirstName" : "' . $record[0]['first_name'] . '",
"LastName" : "' . $record[0]['last_name'] . '",
"countryid" : "' . $record[0]['country'] . '",
"Country" : "' . $record1[0]['country'] . '",
"country_flag_url" :"http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/public/uploads/users/' . $record1[0]['country_flag'] . '",
"JoinTime" : "' . $record[0]['added_date'] . '"
},"Message" : "Success",
"error" : "false" }';
echo $response;
} else {
$response = '{"Message":"User detail not found","error":"true"}';
echo $response;
}
} else {
$response = '{"Message":"User detail not found","error":"true"}';
echo $response;
}
break;
case "UserSubscriptions":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
$sql = "SELECT s.id,s.product_id,s.store_id,s.status,s.added_date,s.updated_date, p.product_type,p.publisher_id,p.author_id,p.title,p.parent_brand_id,p.edition_id,p.description,p.isbn_number,p.publisher,p.total_pages,p.cat_id,p.file_name,p.file_size, pp.country_id,pp.language_id,pp.price FROM pclive_company_subscriptions as s INNER JOIN pclive_products as p ON s.product_id=p.id INNER JOIN pclive_product_prices as pp ON s.product_id=pp.product_id WHERE s.company_id<>0 AND s.company_id='{$jsonObj->id}' AND s.store_id=pp.country_id ORDER BY s.id ASC";
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response = array();
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
$publisher_info_qry = 'SELECT first_name,last_name,emailid,publisher,country,phone from pclive_users where id="' . $Parray['publisher_id'] . '"';
$publisher_info_result = $db->query($publisher_info_qry);
$publisher_info_record = $publisher_info_result->FetchAll();
$publisher_info = $publisher_info_record[0];
if (!empty($Parray['parent_brand_id'])) {
$parent_brand_id_qry = 'SELECT title from pclive_products where id="' . $Parray['parent_brand_id'] . '"';
$brand_info_result = $db->query($parent_brand_id_qry);
$brand_info_record = $brand_info_result->FetchAll();
$brand_info = $brand_info_record[0];
$parent_brand_title_qry = 'SELECT brand from pclive_brands where id="' . $brand_info['title'] . '"';
$parent_brand_info_result = $db->query($parent_brand_title_qry);
$parent_brand_info_record = $parent_brand_info_result->FetchAll();
$parent_brand_info = $parent_brand_info_record[0];
}
$store_info_qry = 'SELECT country from pclive_country where id="' . $Parray['store_id'] . '"';
$store_info_result = $db->query($store_info_qry);
$store_info_record = $store_info_result->FetchAll();
$store_info = $store_info_record[0];
$genre_info_qry = 'SELECT genre from pclive_genres where id="' . $Parray['product_type'] . '"';
$genre_info_result = $db->query($genre_info_qry);
$genre_info_record = $genre_info_result->FetchAll();
$genre_info = $genre_info_record[0];
$cat_info_qry = 'SELECT category_name from pclive_categories where id="' . $Parray['cat_id'] . '"';
$cat_info_result = $db->query($cat_info_qry);
$cat_info_record = $cat_info_result->FetchAll();
$cat_info = $cat_info_record[0];
$lan_info_qry = 'SELECT language_name from pclive_product_language where id="' . $Parray['language_id'] . '"';
$lan_info_result = $db->query($lan_info_qry);
$lan_info_record = $lan_info_result->FetchAll();
$lan_info = $lan_info_record[0];
if (strtolower(trim($cat_info['category_name'])) == strtolower(trim('eBook')) || strtolower(trim($cat_info['category_name'])) == strtolower(trim('eBooks'))) {
$author_info_qry = 'SELECT first_name,last_name,emailid,phone from pclive_users where id="' . $Parray['author_id'] . '"';
$author_info_result = $db->query($author_info_qry);
$author_info_record = $author_info_result->FetchAll();
$author_info = $author_info_record[0];
} else {
$edition_info_qry = 'SELECT edition from pclive_editions where id="' . $Parray['edition_id'] . '"';
$edition_info_result = $db->query($edition_info_qry);
$edition_info_record = $edition_info_result->FetchAll();
$edition_info = $edition_info_record[0];
}
$response['Bookshelve'][$key]['ProductId'] = $Parray['product_id'];
if (!empty($parent_brand_info)) {
$title = $Parray['title'] . "(" . ucfirst($parent_brand_info['brand']) . ")";
} else {
$title = $Parray['title'];
}
$response['Bookshelve'][$key]['Title'] = $title;
//$thumbnail='<img src="'.$this->view->serverUrl().$this->view->baseUrl()."/".USER_UPLOAD_DIR.$book_thumb_info['image_name_thumb'].'" height="208" width="166">';
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
$response['Bookshelve'][$key]['ProductThumbnail'] = $thumbnail_path;
//$response['Bookshelve'][$key]['ProductThumbnail']=$thumbnail;
$response['Bookshelve'][$key]['StoreName'] = $store_info['country'];
//$response['Bookshelve'][$key]['StoreId']=$Parray['store_id'];
$response['Bookshelve'][$key]['Category'] = $cat_info['category_name'];
if (isset($edition_info) && !empty($edition_info)) {
$response['Bookshelve'][$key]['Edition'] = $edition_info['edition'];
}
$response['Bookshelve'][$key]['Genre'] = $genre_info['genre'];
$response['Bookshelve'][$key]['Language'] = $lan_info['language_name'];
$response['Bookshelve'][$key]['Price'] = $Parray['price'];
//$response['Bookshelve'][$key]['TotalDownloads']=$Parray['total_downloads'];
$response['Bookshelve'][$key]['PublisherInfo'] = $publisher_info;
if (isset($author_info) && !empty($author_info)) {
$response['Bookshelve'][$key]['AuthorInfo'] = $author_info;
}
$response['Bookshelve'][$key]['Edition'] = $edition_info['edition'];
$response['Bookshelve'][$key]['AddedDate'] = $Parray['added_date'];
$response['Bookshelve'][$key]['UpdatedDate'] = $Parray['updated_date'];
}
/*echo"<pre>";
print_r($response);
*/
$response = json_encode($response);
echo stripslashes($response);
} else {
$response = '[{"Error":{"Message":"No Records Found."}}]';
echo $response;
}
} else {
$response = '[{"Error":{"Message":"User Id does not exist"}}]';
echo $response;
}
break;
case "GetLibrary":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.cat_id ASC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.cat_id ASC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Library'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Library'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Library'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Library'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Library'][$key]['author_name'] = "";
} else {
$response['Library'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Library'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Library'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Library'][$key]['rating'] = $rs[0];
}
} else {
$response['Library'][$key]['rating'] = 0;
}
$response['Library'][$key]['books_status'] = "Yes";
}
/*echo"<pre>";
print_r($response);
*/
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
} else {
$response['Library'][0]['books_status'] = "No";
}
//$response='{"Library":[{"id":"","product_type":"","publisher_id":"","author_id":"","title":"","edition_id":"","description":"","isbn_number":"","publisher":"","total_pages":"","cat_id":"","parent_brand_id":"","file_name":"","file_size":"","status":"","is_featured":"","admin_approve":"","publish_time":"","add_time":"","best_seller":"","category_name":"","genre":"","product_id":"","country_id":"","language_id":"","price":"","ProductThumbnail":"","Producturl":"","publisher_name":"","author_name":""}],"Allcategories":[{"id":"","parent_id":"","genre":"","added_date":"","updated_date":"","status":""}]}';
/*echo "<pre>";
print_r($response);
exit;*/
//$response = json_encode($response);
//$response = str_replace("\\", '',$response);
//$response = stripslashes(json_encode($response, JSON_HEX_APOS));
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
//echo stripslashes($response);
break;
case "GetNewarrivalsIphone":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.cat_id ASC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.cat_id ASC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Library'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
$response['Library'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Library'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Library'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Library'][$key]['author_name'] = "";
} else {
$response['Library'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Library'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Library'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Library'][$key]['rating'] = $rs[0];
}
} else {
$response['Library'][$key]['rating'] = 0;
}
$response['Library'][$key]['books_status'] = "Yes";
}
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
} else {
$response['Library'][0]['books_status'] = "No";
}
//$response = stripslashes(json_encode($response, JSON_HEX_APOS));
//echo $response;
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.id DESC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.id DESC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.id DESC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Newarrivals'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
$response['Newarrivals'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Newarrivals'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Newarrivals'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Newarrivals'][$key]['author_name'] = "";
} else {
$response['Newarrivals'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Newarrivals'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Newarrivals'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Newarrivals'][$key]['rating'] = $rs[0];
}
} else {
$response['Newarrivals'][$key]['rating'] = 0;
}
$response['Newarrivals'][$key]['books_status'] = "Yes";
}
} else {
$response['Newarrivals'][0]['books_status'] = "No";
}
/*echo "<pre>";
print_r($response);
exit;*/
//$response = json_encode($response);
//$response = str_replace("\\", '',$response);
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
//echo stripslashes($response);
break;
case "GetBestsellersIphone":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.cat_id ASC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.cat_id ASC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Library'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
$response['Library'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Library'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Library'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Library'][$key]['author_name'] = "";
} else {
$response['Library'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Library'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Library'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Library'][$key]['rating'] = $rs[0];
}
} else {
$response['Library'][$key]['rating'] = 0;
}
$response['Library'][$key]['books_status'] = "Yes";
}
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
} else {
$response['Library'][0]['books_status'] = "No";
}
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.best_seller DESC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.best_seller DESC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.best_seller DESC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Bestsellers'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
$response['Bestsellers'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Bestsellers'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Bestsellers'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Bestsellers'][$key]['author_name'] = "";
} else {
$response['Bestsellers'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Bestsellers'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Bestsellers'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Bestsellers'][$key]['rating'] = $rs[0];
}
} else {
$response['Bestsellers'][$key]['rating'] = 0;
}
$response['Bestsellers'][$key]['books_status'] = "Yes";
}
} else {
$response['Bestsellers'][0]['books_status'] = "No";
}
/*echo "<pre>";
print_r($response);
exit;*/
//$response = json_encode($response);
//$response = str_replace("\\", '',$response);
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
//echo stripslashes($response);
break;
case "GetBestsellers":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.best_seller DESC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.best_seller DESC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.best_seller DESC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Bestsellers'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Bestsellers'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Bestsellers'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Bestsellers'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Bestsellers'][$key]['author_name'] = "";
} else {
$response['Bestsellers'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Bestsellers'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Bestsellers'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Bestsellers'][$key]['rating'] = $rs[0];
}
} else {
$response['Bestsellers'][$key]['rating'] = 0;
}
$response['Bestsellers'][$key]['books_status'] = "Yes";
}
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
/*echo"<pre>";
print_r($response);
*/
} else {
$response['Bestsellers'][0]['books_status'] = "No";
}
/*echo "<pre>";
print_r($response);
exit;*/
//$response = json_encode($response);
//$response = str_replace("\\", '',$response);
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
//echo stripslashes($response);
break;
case "GetNewarrivals":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.id DESC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.id DESC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.id DESC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Newarrivals'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Newarrivals'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Newarrivals'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Newarrivals'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Newarrivals'][$key]['author_name'] = "";
} else {
$response['Newarrivals'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Newarrivals'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Newarrivals'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Newarrivals'][$key]['rating'] = $rs[0];
}
} else {
$response['Newarrivals'][$key]['rating'] = 0;
}
$response['Newarrivals'][$key]['books_status'] = "Yes";
}
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
/*echo"<pre>";
print_r($response);
*/
} else {
$response['Newarrivals'][0]['books_status'] = "No";
}
/*echo "<pre>";
print_r($response);
exit;*/
//$response = json_encode($response);
//$response = str_replace("\\", '',$response);
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
//echo stripslashes($response);
break;
case "GetPurchaseHistory":
$main_array = array();
//$sql="SELECT prod.*,c.category_name,g.genre, FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_credit_history hs on prod.id =hs.bookid WHERE hs.userid='$jsonObj->UserId' ORDER BY prod.cat_id ASC";
$sql = "SELECT prod.id, prod.title,prod.description,prod.file_size,prod.publisher_id,prod.author_id,c.category_name, g.genre, hs.price,hs.userid,hs.add_date FROM pclive_products AS prod INNER JOIN pclive_categories c ON c.id = prod.cat_id INNER JOIN pclive_genres g ON prod.product_type = g.id INNER JOIN pclive_credit_history hs ON prod.id = hs.bookid WHERE hs.userid ='{$jsonObj->UserId}' ORDER BY prod.cat_id ASC";
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Purchase'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Purchase'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Purchase'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Purchase'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Purchase'][$key]['author_name'] = "";
} else {
$response['Purchase'][$key]['author_name'] = $author_info['first_name'];
}
$response['Purchase'][$key]['status'] = "Yes";
$amount_qry = "SELECT sum(`amount`) as total FROM pclive_payment_history where user_id='{$jsonObj->UserId}' group by user_id";
$amount_result = $db->query($amount_qry);
$amount_record = $amount_result->FetchAll();
$amount_info = $amount_record[0];
if (count($amount_record) > 0) {
$response['Amount'] = $amount_info['total'];
} else {
$response['Amount'] = 0;
}
}
} else {
//$response['Library']="No books available";
$response['Purchase'][0]['status'] = "No";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetPurchaseHistoryNew":
$main_array = array();
//$sql="SELECT prod.*,c.category_name,g.genre, FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_credit_history hs on prod.id =hs.bookid WHERE hs.userid='$jsonObj->UserId' ORDER BY prod.cat_id ASC";
$sql = "SELECT prod.id, prod.title,prod.description,prod.file_size,prod.publisher_id,prod.author_id,prod.publish_time,c.category_name, g.genre, hs.price,hs.userid,hs.add_date FROM pclive_products AS prod INNER JOIN pclive_categories c ON c.id = prod.cat_id INNER JOIN pclive_genres g ON prod.product_type = g.id INNER JOIN pclive_credit_history hs ON prod.id = hs.bookid WHERE hs.userid ='{$jsonObj->UserId}' ORDER BY prod.cat_id ASC";
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Purchase'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Purchase'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Purchase'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Purchase'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Purchase'][$key]['author_name'] = "";
} else {
$response['Purchase'][$key]['author_name'] = $author_info['first_name'];
}
$response['Purchase'][$key]['status'] = "Yes";
$amount_qry = "SELECT sum(`amount`) as total FROM pclive_payment_history where user_id='{$jsonObj->UserId}' group by user_id";
$amount_result = $db->query($amount_qry);
$amount_record = $amount_result->FetchAll();
$amount_info = $amount_record[0];
if (count($amount_record) > 0) {
$response['Amount'] = $amount_info['total'];
} else {
$response['Amount'] = 0;
}
}
} else {
//$response['Library']="No books available";
$response['Purchase'][0]['status'] = "No";
}
$sql1 = "select * from pclive_payment_history where user_id='{$jsonObj->UserId}'";
$result1 = $db->query($sql1);
$records1 = $result1->FetchAll();
if (count($records1) > 0) {
$response['PurchasePoint'] = $records1;
$credit = 0;
foreach ($records1 as $key => $Parray1) {
$credit += $Parray1['amount'];
}
$sql2 = "SELECT sum( `price` ) AS expense FROM pclive_credit_history where userid='{$jsonObj->UserId}' GROUP BY userid";
$result2 = $db->query($sql2);
$records2 = $result2->FetchAll();
$expense_info = $records2[0];
$balance = $credit - $expense_info['expense'];
$response['Balance'] = $balance;
} else {
//$response['Library']="No books available";
$response['PurchasePoint'][0]['status'] = "No";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetPurchaseHistoryNew1":
$main_array = array();
$TotalTransaction = 0;
if ($jsonObj->type == 'user') {
$sql = "SELECT prod.id, prod.title,prod.description,prod.file_size,prod.publisher_id,prod.author_id, prod.cat_id,prod.file_name,prod.publish_time,c.category_name, g.genre, hs.price,hs.userid,hs.add_date FROM pclive_products AS prod INNER JOIN pclive_categories c ON c.id = prod.cat_id INNER JOIN pclive_genres g ON prod.product_type = g.id INNER JOIN pclive_credit_history hs ON prod.id = hs.bookid INNER JOIN pclive_user_sub_details as chd WHERE hs.order_id=chd.order_id and hs.userid ='" . $jsonObj->UserId . "' and hs.payment_status=1 GROUP BY prod.id ORDER BY hs.credit_id desc";
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Purchase'] = $records;
foreach ($records as $key => $Parray) {
//get store_id from book_id and userid from pclive_credit_history
$retVal1 = array();
$select1 = 'SELECT store_id from pclive_credit_history where bookid="' . $Parray['id'] . '" and userid="' . $Parray['userid'] . '" ';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
$select2 = 'SELECT `currency_sign` from `pclive_currency` INNER JOIN pclive_country ON pclive_currency.`currency_id`= pclive_country.`currency_id` where id="' . $retVal1[0]['store_id'] . '" ';
$currency_result1 = $db->query($select2);
$retVal2 = $currency_result1->FetchAll();
$response['Purchase'][$key]['priceText'] = $retVal2[0]['currency_sign'] . " " . $response['Purchase'][$key]['price'];
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$response['Purchase'][$key]['title'] = $bookbrand_info['brand'];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
/*
$this->modelBooks = new Publisher_Model_DbTable_Books();
$getBrandInfo=$this->modelBooks->getBrandInfo($Parray['title']);
if(!empty($getBrandInfo) && is_numeric($Parray['title']))
{
$bookname=$getBrandInfo['brand'];
}else
{
$bookname=$Parray['title'];
}
if(!empty($Parray['parent_brand_id']) && $Parray['cat_id']!='3')
{
$productInfo=$this->modelBooks->fetchRow('id="'.$Parray['parent_brand_id'].'"');
$getParentBrandInfo=$this->modelBooks->getBrandInfo($productInfo->title);
if(!empty($getParentBrandInfo))
{
$bookname=$getParentBrandInfo['brand'].'-'.$bookname;
}
//$all=getPublicationIdsByCategoryName();
}
$response['Purchase'][$key]['title']=$bookname;
$bookname= str_replace(" ","",$bookname);
*/
$response['Purchase'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Purchase'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['id'] . "/bookname/" . $bookname;
$response['Purchase'][$key]['publish_time'] = $Parray['publish_time'] . " 00:00:00";
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Purchase'][$key]['publisher_name'] = $pub_info['publisher'];
$response['Purchase'][$key]['publisher'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Purchase'][$key]['author_name'] = "";
} else {
$response['Purchase'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
$response['Purchase'][$key]['status'] = "Yes";
//calculate total purchase
$TotalTransaction += $Parray['price'];
}
$response['TotalTransaction'] = $TotalTransaction;
} else {
$response['TotalTransaction'] = "0";
}
//$response['Library']="No books available";
//$response['Purchase'][0]['status']="No";
$sql1 = "select * from pclive_payment_history where user_id='{$jsonObj->UserId}'";
$result1 = $db->query($sql1);
$records1 = $result1->FetchAll();
if (count($records1) > 0) {
$response['PurchasePoint'] = $records1;
$credit = 0;
foreach ($records1 as $key => $Parray1) {
$credit += $Parray1['amount'];
}
$sql2 = "SELECT sum( `price` ) AS expense FROM pclive_credit_history where userid='{$jsonObj->UserId}' and payment_status=1 GROUP BY userid";
$result2 = $db->query($sql2);
$records2 = $result2->FetchAll();
$expense_info = $records2[0];
$balance = $credit - $expense_info['expense'];
$response['Balance'] = $balance;
$amount_qry = "SELECT sum(`amount`) as total FROM pclive_payment_history where user_id='{$jsonObj->UserId}' group by user_id";
$amount_result = $db->query($amount_qry);
$amount_record = $amount_result->FetchAll();
$amount_info = $amount_record[0];
if (count($amount_record) > 0) {
$response['TotalPurchase'] = $amount_info['total'];
} else {
$response['TotalPurchase'] = 0;
}
} else {
}
//$response['Library']="No books available";
//$response['PurchasePoint'][0]['status']="No";
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
} else {
//echo ">>>>there";
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.cat_id ASC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.cat_id ASC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and prod.publisher_id='{$jsonObj->UserId}' group by prod.id ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Purchase'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
$retVal = array();
$select = 'SELECT * from pclive_country where id="' . $Parray['country_id'] . '"';
$country_result = $db->query($select);
$retVal = $country_result->FetchAll();
$response['Purchase'][$key]['country_name'] = $retVal[0]['country'];
//echo ">>>>>".$retVal['currency_id'];
$retVal1 = array();
$select1 = 'SELECT * from pclive_currency where currency_id="' . $retVal[0]['currency_id'] . '"';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
$response['Purchase'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Purchase'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Purchase'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Purchase'][$key]['author_name'] = "";
} else {
$response['Purchase'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
// get symbol with price $retVal1[0]['currency_sign'];
$response['Purchase'][$key]['priceText'] = $retVal1[0]['currency_sign'] . " " . $response['Purchase'][$key]['price'];
}
$response['Message'] = "Success.";
$response['error'] = "false";
} else {
//$response = '[{"Error": {"Message":"No New Arrivals Found.","error":"true"}}]';
$response['Message'] = "No Books in library.";
$response['error'] = "true";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
}
break;
case "GetPurchasePoint":
$main_array = array();
$sql = "select * from pclive_payment_history where user_id='{$jsonObj->UserId}'";
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['PurchasePoint'] = $records;
$credit = 0;
foreach ($records as $key => $Parray) {
$credit += $Parray['amount'];
}
$sql1 = "SELECT sum( `price` ) AS expense FROM pclive_credit_history where userid='{$jsonObj->UserId}' and payment_status=1 GROUP BY userid";
$result1 = $db->query($sql1);
$records1 = $result1->FetchAll();
$expense_info = $records1[0];
$balance = $credit - $expense_info['expense'];
$response['Balance'] = $balance;
} else {
//$response['Library']="No books available";
$response['PurchasePoint'][0]['status'] = "No";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetFeatured":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.product_type*1 ASC";
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 ORDER BY prod.product_type*1 ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Featured'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Featured'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Featured'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Featured'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Featured'][$key]['author_name'] = "";
} else {
$response['Featured'][$key]['author_name'] = $author_info['first_name'];
}
}
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "Categories":
$get_all_categories = "select * from pclive_categories where status='1'";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
$response = json_encode($response);
echo $response;
break;
case "GetCountries":
$get_all_countries = "select * from pclive_country where status='1' order by country";
$res_all_countries = $db->query($get_all_countries);
$data_countries = $res_all_countries->FetchAll();
$response['Allcountries'] = $data_countries;
$response = json_encode($response);
echo $response;
break;
case "GetStores_old":
$get_all_countries = "select id, country as store,country_flag from pclive_country where is_store_status='1' and is_store=1 and id!=248 order by country";
$res_all_countries = $db->query($get_all_countries);
$data_countries = $res_all_countries->FetchAll();
$response['Allstores'] = $data_countries;
foreach ($data_countries as $key => $Parray) {
//echo ">>>".$key;
//$response['Allstores'][$key]['id']=$Parray['id'];
$response['Allstores'][$key]['country_flag_url'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/public/uploads/users/" . $Parray['country_flag'];
}
$get_all_countries1 = "select id, country as store,country_flag from pclive_country where is_store_status='1' and is_store=1 and id=248 order by country";
$res_all_countries1 = $db->query($get_all_countries1);
$data_countries1 = $res_all_countries1->FetchAll();
$response['Allstores'] = $data_countries1;
foreach ($data_countries1 as $key1 => $Parray) {
//echo ">>>".$key;
//$response['Allstores'][$key]['id']=$Parray['id'];
$response['Allstores'][$key + 1]['id'] = $Parray['id'];
$response['Allstores'][$key + 1]['store'] = $Parray['store'];
$response['Allstores'][$key + 1]['country_flag'] = $Parray['country_flag'];
$response['Allstores'][$key + 1]['country_flag_url'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/public/uploads/users/" . $Parray['country_flag'];
}
$response = stripslashes(json_encode($response));
echo $response;
break;
case "GetStores":
$get_all_countries = "select id, country as store,country_flag from pclive_country where is_store_status='1' and is_store=1 order by country";
$res_all_countries = $db->query($get_all_countries);
$data_countries = $res_all_countries->FetchAll();
$response['Allstores'] = $data_countries;
foreach ($data_countries as $key => $Parray) {
//echo ">>>".$key;
if ($Parray['id'] != 248) {
$response['Allstores'][$key]['id'] = $Parray['id'];
$response['Allstores'][$key]['store'] = $Parray['store'];
$response['Allstores'][$key]['country_flag'] = $Parray['country_flag'];
$response['Allstores'][$key]['country_flag_url'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/public/uploads/users/" . $Parray['country_flag'];
} else {
$response['Allstores'][$key]['id'] = '';
$response['Allstores'][$key]['store'] = '';
$response['Allstores'][$key]['country_flag'] = '';
$response['Allstores'][$key]['country_flag_url'] = '';
$tempid = $Parray['id'];
$tempstore = $Parray['store'];
$tempcountry_flag = $Parray['country_flag'];
}
}
$response['Allstores'][$key + 1]['id'] = $tempid;
$response['Allstores'][$key + 1]['store'] = $tempstore;
$response['Allstores'][$key + 1]['country_flag'] = $tempcountry_flag;
$response['Allstores'][$key + 1]['country_flag_url'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/public/uploads/users/" . $tempcountry_flag;
$response = stripslashes(json_encode($response));
echo $response;
break;
case "StoreDownloads":
if (!empty($jsonObj->userid) && $jsonObj->userid > 0) {
if (!empty($jsonObj->bookid) && $jsonObj->bookid > 0 || !empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$chk_review = $db->query("select * from pclive_credit_history where userid='" . $jsonObj->userid . "' and bookid='" . $jsonObj->bookid . "'");
$records_review = $chk_review->FetchAll();
$chk_parent_id = $db->query("select parent_brand_id from pclive_products where id='" . $jsonObj->bookid . "'");
$records_partent = $chk_parent_id->FetchAll();
if ($records_partent[0]['parent_brand_id'] > 0) {
$chk_issue_downloaded = $db->query("select * from pclive_user_sub_details where user_id='" . $jsonObj->userid . "' and publication_id='" . $records_partent[0]['parent_brand_id'] . "'");
$records_issue_downloaded = $chk_issue_downloaded->FetchAll();
/*if($records_issue_downloaded[0]['issue_type']>0)
{
if($records_issue_downloaded[0]['issue_ids']!='')
{
$issids = explode(",",$records_issue_downloaded[0]['issue_ids']);
if(!(@in_array($jsonObj->bookid,$issids)))
{
$remaining_downloads = $records_issue_downloaded[0]['number_of_issues']-$records_issue_downloaded[0]['number_of_downloaded'];
$issue_ids = $records_issue_downloaded[0]['issue_ids'].",".$jsonObj->bookid;
//$db->query("update pclive_user_sub_details set number_of_downloaded=number_of_downloaded+1,issue_ids='".$issue_ids."',remaining_downloads='".$remaining_downloads."' where user_id='".$jsonObj->userid."' and publication_id='".$records_partent[0]['parent_brand_id']."'");
}
}
else
{
$remaining_downloads = $records_issue_downloaded[0]['number_of_issues']-1;
$issue_ids = $jsonObj->bookid;
//$db->query("update pclive_user_sub_details set number_of_downloaded=number_of_downloaded+1,issue_ids='".$issue_ids."',remaining_downloads='".$remaining_downloads."' where user_id='".$jsonObj->userid."' and publication_id='".$records_partent[0]['parent_brand_id']."'");
}
}
else
{
//$db->query("update pclive_user_sub_details set number_of_downloaded=number_of_downloaded+1 where user_id='".$jsonObj->userid."' and publication_id='".$records_partent[0]['parent_brand_id']."'");
}*/
} else {
//$remaining_downloads = $records_issue_downloaded[0]['number_of_issues']-1;
// $issue_ids = $jsonObj->bookid;
//$db->query("update pclive_user_sub_details set number_of_downloaded=number_of_downloaded+1 where user_id='".$jsonObj->userid."' and publication_id='".$records_partent[0]['parent_brand_id']."'");
}
/*
if(count($records_review)==0)
{
$get_prname = $db->query("select * from pclive_products where id='".$jsonObj->bookid."'");
$records_prname = $get_prname->FetchAll();
//$sql="insert into pclive_credit_history set userid='".$jsonObj->userid."',bookid='".$jsonObj->bookid."',price='".$jsonObj->price."',book_name='".$records_prname[0]['title']."', store_id='".$jsonObj->StoreId."', add_date=now()";
//$result = $db->query($sql);
//$sql1="update pclive_products set best_seller=best_seller+1 where id=".$jsonObj->bookid."";
//$result1 = $db->query($sql1);
$response = '{"BookResponse":{
"error":"false","Message":"Successfully purchased."
}}';
echo $response;
}
else
{
$sql1="update pclive_products set no_download=no_download+1 where id=".$jsonObj->bookid."";
$result1 = $db->query($sql1);
$response = '{"BookResponse":{"Message":"You have already purchased.", "error":"true"}}';
echo $response;
}
*/
$sql1 = "update pclive_products set no_download=no_download+1 where id=" . $jsonObj->bookid . "";
$result1 = $db->query($sql1);
} else {
$response = '{"BookResponse":{"Message":"Bookid or store does not exist.", "error":"true"}}';
echo $response;
}
} else {
$response = '{"BookResponse":{"Message":"Userid does not exist.", "error":"true"}}';
echo $response;
}
break;
case "ReviewRating":
if (!empty($jsonObj->userid) && $jsonObj->userid > 0) {
if (!empty($jsonObj->bookid) && $jsonObj->bookid > 0) {
$chk_review = $db->query("select * from pclive_review where userid='" . $jsonObj->userid . "' and productid='" . $jsonObj->bookid . "'");
$records_review = $chk_review->FetchAll();
if (count($records_review) == 0) {
$sql = "insert into pclive_review set userid='" . $jsonObj->userid . "',rating='" . $jsonObj->rating . "',comments='" . $jsonObj->comments . "',productid='" . $jsonObj->bookid . "',add_time=now()";
$result = $db->query($sql);
$response = '[{"Error":{"Message":"You have rated succesfully."}}]';
echo $response;
} else {
$sql = "update pclive_review set rating='" . $jsonObj->rating . "', comments='" . $jsonObj->comments . "',add_time=now() where userid='" . $jsonObj->userid . "' and productid='" . $jsonObj->bookid . "' ";
$result = $db->query($sql);
$response = '[{"Error":{"Message":"You have rated succesfully."}}]';
//$response = '[{"Error":{"Message":"You have already given your review for this book."}}]';
echo $response;
}
} else {
$response = '[{"Error":{"Message":"Book does not exists."}}]';
echo $response;
}
} else {
$response = '[{"Error":{"Message":"User Id does not exist"}}]';
echo $response;
}
break;
case "ReviewRatingIphone":
if (!empty($jsonObj->userid) && $jsonObj->userid > 0) {
//echo ">>>>>".$jsonObj->comments;
//exit();
if (!empty($jsonObj->bookId) && $jsonObj->bookId > 0) {
$chk_review = $db->query("select * from pclive_review where userid='" . $jsonObj->userid . "' and productid='" . $jsonObj->bookId . "'");
$records_review = $chk_review->FetchAll();
if (count($records_review) == 0) {
$sql = "insert into pclive_review set userid='" . $jsonObj->userid . "',rating='" . urldecode($jsonObj->rating) . "',comments='" . str_replace("%0A", "\n", $jsonObj->comments) . "',productid='" . $jsonObj->bookId . "',add_time=now()";
$result = $db->query($sql);
$response = '{"Message":"You have rated succesfully.", "error":"false" }';
echo $response;
} else {
$sql = "update pclive_review set rating='" . $jsonObj->rating . "', comments='" . urldecode($jsonObj->comments) . "',add_time=now() where userid='" . $jsonObj->userid . "' and productid='" . $jsonObj->bookId . "' ";
$result = $db->query($sql);
$response = '{"Message":"You have rated succesfully.", "error":"false" }';
//$response = '[{"Error":{"Message":"You have already given your review for this book."}}]';
echo $response;
}
} else {
$response = '{"Message":"Book does not exists.", "error":"true" }';
echo $response;
}
} else {
$response = '{"Message":"User Id does not exist.", "error":"true" }';
echo $response;
}
break;
case "UserUpdate":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
$Errorresponse = "";
if (!isset($jsonObj->FirstName) || trim($jsonObj->FirstName) == "" || !isset($jsonObj->LastName) || trim($jsonObj->LastName) == "" || !isset($jsonObj->Country) || trim($jsonObj->Country) == "") {
$Errorresponse = '[{"ParameterMissing":{';
if (!isset($jsonObj->FirstName) || trim($jsonObj->FirstName) == "") {
//$Errorresponse.='"FirstName":"Please Enter First Name",';
$Errorresponse .= '{"Message":"Unsuccess", "Error":"Please Enter First Name" }';
}
if (!isset($jsonObj->LastName) || trim($jsonObj->LastName) == "") {
//$Errorresponse.='"LastName":"Please Enter Last Name",';
$Errorresponse .= '{"Message":"Unsuccess", "Error":"Please Enter Last Name" }';
}
if (!isset($jsonObj->Country) || trim($jsonObj->Country) == "") {
//$Errorresponse.='"Country":"Please Select A Country"';
$Errorresponse .= '{"Message":"Unsuccess", "Error":"Please Select A Country" }';
}
$Errorresponse .= '}}]';
}
if (!empty($Errorresponse)) {
echo $Errorresponse;
} else {
//if($jsonObj->Acounttype=="")
//$jsonObj->Acounttype=2;
$sql = "UPDATE pclive_companies SET first_name='{$jsonObj->FirstName}', last_name='{$jsonObj->LastName}', country='{$jsonObj->Country}' where id='{$jsonObj->id}'";
$result = $db->query($sql);
if ($result) {
$response .= '{"Message":"Success", "UpdationResponse":"Record Updated Successfully" }';
echo $response;
} else {
$response .= '{"Message":"Unsuccess", "UpdationResponse":"Record cannot be modified" }';
echo $response;
}
}
} else {
$response .= '{"Message":"Unsuccess", "Error":"User Id does not exist" }';
echo $response;
}
break;
/*
case "UserUpdateIphone":
if(!empty($jsonObj->id) && $jsonObj->id>0)
{
$Errorresponse="";
if(!(isset($jsonObj->FirstName)) || trim($jsonObj->FirstName)=="" || !(isset($jsonObj->LastName)) || trim($jsonObj->LastName)=="" || !(isset($jsonObj->Country)) || trim($jsonObj->Country)=="")
{
$Errorresponse='[{"ParameterMissing":{';
if(!(isset($jsonObj->FirstName)) || trim($jsonObj->FirstName)=="")
{
//$Errorresponse.='"FirstName":"Please Enter First Name",';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Please Enter First Name" }';
}
if(!(isset($jsonObj->LastName)) || trim($jsonObj->LastName)=="")
{
//$Errorresponse.='"LastName":"Please Enter Last Name",';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Please Enter Last Name" }';
}
if(!(isset($jsonObj->Country)) || trim($jsonObj->Country)=="")
{
//$Errorresponse.='"Country":"Please Select A Country"';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Please Select A Country" }';
}
$Errorresponse.='}}]';
}
if(!empty($Errorresponse))
{
echo $Errorresponse;
}
else
{
$countrrep=str_replace(" ", "",$jsonObj->Country);
//$sqlcountry="select id from pclive_country where country='".$jsonObj->Country."'";
$sqlcountry="select id FROM pclive_country
WHERE replace( country, ' ', '' ) = '".$countrrep."' ";
$resultcountry = $db->query($sqlcountry);
$data_country = $resultcountry->FetchAll();
//$sqlcountry="select id from pclive_country where country='".$jsonObj->Country."'";
$userinfo="select * FROM pclive_companies where id='$jsonObj->id'";
$resultuserinfo = $db->query($userinfo);
$data_userinfo = $resultuserinfo->FetchAll();
//if($jsonObj->Acounttype=="")
//$jsonObj->Acounttype=2;
$sql = "UPDATE pclive_companies SET first_name='$jsonObj->FirstName', last_name='$jsonObj->LastName', country='".$data_country[0]['id']."' where id='$jsonObj->id'";
$result = $db->query($sql);
if($result)
{
$response.='{"Message":"Success", "UpdationResponse":"Record Updated Successfully" ,"UpdatedCountry":"'.$data_country[0]['id'].'","Userid":"'.$data_userinfo[0]['id'].'","Username":"******","Userpassword":"******"}';
echo $response;
}
else
{
$response.='{"Message":"Unsuccess", "UpdationResponse":"Record cannot be modified" }';
echo $response;
}
}
}
else
{
$response.='{"Message":"Unsuccess", "Error":"User Id does not exist" }';
echo $response;
}
break;
*/
/*
case "UserUpdateIphone":
if(!empty($jsonObj->id) && $jsonObj->id>0)
{
$Errorresponse="";
if(!(isset($jsonObj->FirstName)) || trim($jsonObj->FirstName)=="" || !(isset($jsonObj->LastName)) || trim($jsonObj->LastName)=="" || !(isset($jsonObj->Country)) || trim($jsonObj->Country)=="")
{
$Errorresponse='[{"ParameterMissing":{';
if(!(isset($jsonObj->FirstName)) || trim($jsonObj->FirstName)=="")
{
//$Errorresponse.='"FirstName":"Please Enter First Name",';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Please Enter First Name" }';
}
if(!(isset($jsonObj->LastName)) || trim($jsonObj->LastName)=="")
{
//$Errorresponse.='"LastName":"Please Enter Last Name",';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Please Enter Last Name" }';
}
if(!(isset($jsonObj->Country)) || trim($jsonObj->Country)=="")
{
//$Errorresponse.='"Country":"Please Select A Country"';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Please Select A Country" }';
}
$Errorresponse.='}}]';
}
if(!empty($Errorresponse))
{
echo $Errorresponse;
}
else
{
$countrrep=str_replace(" ", "",$jsonObj->Country);
//$sqlcountry="select id from pclive_country where country='".$jsonObj->Country."'";
$sqlcountry="select id FROM pclive_country
WHERE replace( country, ' ', '' ) = '".$countrrep."' ";
$resultcountry = $db->query($sqlcountry);
$data_country = $resultcountry->FetchAll();
//$sqlcountry="select id from pclive_country where country='".$jsonObj->Country."'";
$userinfo="select * FROM pclive_companies where id='$jsonObj->id'";
$resultuserinfo = $db->query($userinfo);
$data_userinfo = $resultuserinfo->FetchAll();
//if($jsonObj->Acounttype=="")
//$jsonObj->Acounttype=2;
$sql = "UPDATE pclive_companies SET first_name='$jsonObj->FirstName', last_name='$jsonObj->LastName', country='".$data_country[0]['id']."' where id='$jsonObj->id'";
$result = $db->query($sql);
if($result)
{
$response.='{"Message":"Success", "UpdationResponse":"Record Updated Successfully" ,"UpdatedCountry":"'.$data_country[0]['id'].'","Userid":"'.$data_userinfo[0]['id'].'","Username":"******","Userpassword":"******"}';
echo $response;
}
else
{
$response.='{"Message":"Unsuccess", "UpdationResponse":"Record cannot be modified" }';
echo $response;
}
}
}
else
{
$response.='{"Message":"Unsuccess", "Error":"User Id does not exist" }';
echo $response;
}
break;
*/
case "UserUpdateIphone":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
$Errorresponse = "";
if (!isset($jsonObj->FirstName) || trim($jsonObj->FirstName) == "" || !isset($jsonObj->LastName) || trim($jsonObj->LastName) == "" || !isset($jsonObj->countryid) || trim($jsonObj->countryid) == "") {
$Errorresponse = '[{"ParameterMissing":{';
if (!isset($jsonObj->FirstName) || trim($jsonObj->FirstName) == "") {
//$Errorresponse.='"FirstName":"Please Enter First Name",';
$Errorresponse .= '{"Message":"Please Enter First Name.", "error":"true" }';
}
if (!isset($jsonObj->LastName) || trim($jsonObj->LastName) == "") {
//$Errorresponse.='"LastName":"Please Enter Last Name",';
$Errorresponse .= '{"Message":"Please Enter Last Name.", "error":"true" }';
}
if (!isset($jsonObj->countryid) || trim($jsonObj->countryid) == "") {
//$Errorresponse.='"Country":"Please Select A Country"';
$Errorresponse .= '{"Message":"Please Select A Country.", "error":"true" }';
}
$Errorresponse .= '}}]';
}
if (!empty($Errorresponse)) {
echo $Errorresponse;
} else {
//if($jsonObj->Acounttype=="")
//$jsonObj->Acounttype=2;
$sql = "UPDATE pclive_companies SET first_name='{$jsonObj->FirstName}', last_name='{$jsonObj->LastName}', country='{$jsonObj->countryid}' where id='{$jsonObj->id}'";
$result = $db->query($sql);
if ($result) {
//$response.='{"Message":"Record Updated Successfully.", "error":"false" }';
$sql1 = "SELECT * FROM pclive_country where id='" . $jsonObj->countryid . "' ";
$result1 = $db->query($sql1);
$record1 = $result1->FetchAll();
//$sql = 'SELECT * FROM pclive_companies where id="'.$jsonObj->id.'" AND parent_id="0" AND account_type<>"3"';
$sql = 'SELECT * FROM pclive_companies where id="' . $jsonObj->id . '" AND status=1 and account_type!=1';
$result = $db->query($sql);
$record = $result->FetchAll();
$response = '{
"Message":"Profile updated successfully.",
"userid":"' . $jsonObj->id . '",
"countryid":"' . $jsonObj->countryid . '",
"Country" : "' . $record1[0]['country'] . '",
"FirstName" : "' . $jsonObj->FirstName . '",
"LastName" : "' . $jsonObj->FirstName . '","Username":"******","Userpassword":"******","error":"false"
}';
echo $response;
} else {
$response .= '{"Message":"Request failed. Please try again.", "error":"true" }';
echo $response;
}
}
} else {
$response .= '{"Message":"Request failed. Please try again.", "error":"true" }';
echo $response;
}
break;
case "ChangePwd":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
$Errorresponse = "";
if (!isset($jsonObj->NewPassword) || trim($jsonObj->NewPassword) == "" || !isset($jsonObj->NewConfPassword) || trim($jsonObj->NewConfPassword) == "") {
//$Errorresponse='[{"ParameterMissing":{';
if (!isset($jsonObj->NewPassword) || trim($jsonObj->NewPassword) == "") {
$Errorresponse .= '{"Message":"Unsuccess", "Error":"Please Enter Your New Password" }';
}
if (!isset($jsonObj->NewConfPassword) || trim($jsonObj->NewConfPassword) == "") {
$Errorresponse .= '{"Message":"Unsuccess", "Error":"Please Enter New Confirm Password" }';
}
if ($jsonObj->NewPassword != $jsonObj->NewConfPassword) {
$Errorresponse .= '{"Message":"Unsuccess", "Error":"Confirm Password does not Matched with New Password" }';
}
//$Errorresponse.='}}]';
}
/*
if($jsonObj->OldPassword!="")
{
$sql_oldpwd = "select * from pclive_companies where id='".$jsonObj->id."'";
$res_oldpwd = $db->query($sql_oldpwd);
$data_oldpwd = $res_oldpwd->FetchAll();
if(strcmp($data_oldpwd[0]['user_password'],$jsonObj->OldPassword)!=0)
{
//$Errorresponse.='"CurrentPassword":"******",';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Wrong Current Password" }';
}
}
*/
if (!empty($Errorresponse)) {
echo $Errorresponse;
} else {
$sql = "UPDATE pclive_companies SET user_password='******' where id='" . $jsonObj->id . "'";
$result = $db->query($sql);
$sql_oldpwd = "select * from pclive_companies where id='" . $jsonObj->id . "'";
$res_oldpwd = $db->query($sql_oldpwd);
$data_oldpwd = $res_oldpwd->FetchAll();
if ($result) {
$response .= '{"Message":"Success", "UpdationResponse":"Password changed successfully" ,"UpdatedCountry":"' . $data_oldpwd[0]['country'] . '","Userid":"' . $data_oldpwd[0]['id'] . '","Username":"******","Userpassword":"******"}';
echo $response;
} else {
$response .= '{"Message":"Unsuccess", "Error":"Password cannot be modified" }';
echo $response;
}
}
} else {
$response = '{"Message":{"Unsuccess":"User Id does not exist"}}';
echo $response;
}
break;
case "ChangePwdIphone":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
$Errorresponse = "";
if (!isset($jsonObj->NewPassword) || trim($jsonObj->NewPassword) == "" || !isset($jsonObj->NewConfPassword) || trim($jsonObj->NewConfPassword) == "") {
//$Errorresponse='[{"ParameterMissing":{';
if (!isset($jsonObj->NewPassword) || trim($jsonObj->NewPassword) == "") {
$Errorresponse .= '{"Message":"Request failed. Please try again.", "error":"true" }';
}
if (!isset($jsonObj->NewConfPassword) || trim($jsonObj->NewConfPassword) == "") {
$Errorresponse .= '{"Message":"Request failed. Please try again.", "error":"true" }';
}
if ($jsonObj->NewPassword != $jsonObj->NewConfPassword) {
$Errorresponse .= '{"Message":"Request failed. Please try again.", "error":"true" }';
}
//$Errorresponse.='}}]';
}
/*
if($jsonObj->OldPassword!="")
{
$sql_oldpwd = "select * from pclive_companies where id='".$jsonObj->id."'";
$res_oldpwd = $db->query($sql_oldpwd);
$data_oldpwd = $res_oldpwd->FetchAll();
if(strcmp($data_oldpwd[0]['user_password'],$jsonObj->OldPassword)!=0)
{
//$Errorresponse.='"CurrentPassword":"******",';
$Errorresponse.='{"Message":"Unsuccess", "Error":"Wrong Current Password" }';
}
}
*/
if (!empty($Errorresponse)) {
echo $Errorresponse;
} else {
$sql = "UPDATE pclive_companies SET user_password='******' where id='" . $jsonObj->id . "'";
$result = $db->query($sql);
$sql_oldpwd = "select * from pclive_companies where id='" . $jsonObj->id . "'";
$res_oldpwd = $db->query($sql_oldpwd);
$data_oldpwd = $res_oldpwd->FetchAll();
if ($result) {
$sql1 = "SELECT * FROM pclive_country where id='" . $data_oldpwd[0]['country'] . "' ";
$result1 = $db->query($sql1);
$record1 = $result1->FetchAll();
$response .= '{"Message":"Password changed successfully.", "error":"false", "FirstName":"' . $data_oldpwd[0]['first_name'] . '","LastName":"' . $data_oldpwd[0]['last_name'] . '","countryid":"' . $data_oldpwd[0]['country'] . '","Country":"' . $record1[0]['country'] . '","userid":"' . $data_oldpwd[0]['id'] . '","Username":"******","Userpassword":"******"}';
echo $response;
} else {
$response .= '{"Message":"Request failed. Please try again.", "error":"true" }';
echo $response;
}
}
} else {
$response = '{"Message":"Request failed. Please try again.", "error":"true" }';
echo $response;
}
break;
case "Downloads":
if (!empty($jsonObj->id) && $jsonObj->id > 0) {
$sql = "SELECT s.id,s.product_id,s.store_id,s.total_downloads,s.downloaded_file_size,s.status,s.added_date,s.updated_date, p.product_type,p.publisher_id,p.author_id,p.title,p.file_name,p.file_size,p.parent_brand_id,p.edition_id,p.description,p.isbn_number,p.publisher,p.total_pages,p.cat_id,p.file_name,p.file_size, pp.country_id,pp.language_id,pp.price FROM pclive_company_subscriptions as s INNER JOIN pclive_products as p ON s.product_id=p.id INNER JOIN pclive_product_prices as pp ON s.product_id=pp.product_id WHERE s.company_id<>0 AND s.company_id='{$jsonObj->id}' AND s.store_id=pp.country_id ORDER BY s.id ASC";
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response = array();
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
$publisher_info_qry = 'SELECT first_name,last_name,emailid,publisher,country,phone from pclive_users where id="' . $Parray['publisher_id'] . '"';
$publisher_info_result = $db->query($publisher_info_qry);
$publisher_info_record = $publisher_info_result->FetchAll();
$publisher_info = $publisher_info_record[0];
if (!empty($Parray['parent_brand_id'])) {
$parent_brand_id_qry = 'SELECT title from pclive_products where id="' . $Parray['parent_brand_id'] . '"';
$brand_info_result = $db->query($parent_brand_id_qry);
$brand_info_record = $brand_info_result->FetchAll();
$brand_info = $brand_info_record[0];
$parent_brand_title_qry = 'SELECT brand from pclive_brands where id="' . $brand_info['title'] . '"';
$parent_brand_info_result = $db->query($parent_brand_title_qry);
$parent_brand_info_record = $parent_brand_info_result->FetchAll();
$parent_brand_info = $parent_brand_info_record[0];
}
$store_info_qry = 'SELECT country from pclive_country where id="' . $Parray['store_id'] . '"';
$store_info_result = $db->query($store_info_qry);
$store_info_record = $store_info_result->FetchAll();
$store_info = $store_info_record[0];
$genre_info_qry = 'SELECT genre from pclive_genres where id="' . $Parray['product_type'] . '"';
$genre_info_result = $db->query($genre_info_qry);
$genre_info_record = $genre_info_result->FetchAll();
$genre_info = $genre_info_record[0];
$cat_info_qry = 'SELECT category_name from pclive_categories where id="' . $Parray['cat_id'] . '"';
$cat_info_result = $db->query($cat_info_qry);
$cat_info_record = $cat_info_result->FetchAll();
$cat_info = $cat_info_record[0];
$lan_info_qry = 'SELECT language_name from pclive_product_language where id="' . $Parray['language_id'] . '"';
$lan_info_result = $db->query($lan_info_qry);
$lan_info_record = $lan_info_result->FetchAll();
$lan_info = $lan_info_record[0];
if (strtolower(trim($cat_info['category_name'])) == strtolower(trim('eBook')) || strtolower(trim($cat_info['category_name'])) == strtolower(trim('eBooks'))) {
$author_info_qry = 'SELECT first_name,last_name,emailid,phone from pclive_users where id="' . $Parray['author_id'] . '"';
$author_info_result = $db->query($author_info_qry);
$author_info_record = $author_info_result->FetchAll();
$author_info = $author_info_record[0];
} else {
$edition_info_qry = 'SELECT edition from pclive_editions where id="' . $Parray['edition_id'] . '"';
$edition_info_result = $db->query($edition_info_qry);
$edition_info_record = $edition_info_result->FetchAll();
$edition_info = $edition_info_record[0];
}
$response['Downloads'][$key]['ProductId'] = $Parray['product_id'];
if (!empty($parent_brand_info)) {
$title = $Parray['title'] . "(" . ucfirst($parent_brand_info['brand']) . ")";
} else {
$title = $Parray['title'];
}
$response['Downloads'][$key]['Title'] = $title;
$response['Downloads'][$key]['FileName'] = $Parray['file_name'];
$file_size_array = explode(" ", $Parray['file_size']);
if (strtolower(trim($file_size_array[1])) == strtolower(trim('Mb'))) {
$file_size_array[0] = round($file_size_array[0], 2);
} elseif (strtolower(trim($file_size_array[1])) == strtolower(trim('Kb'))) {
$file_size_array[0] = round($file_size_array[0] / 1024, 2);
} elseif (strtolower(trim($file_size_array[1])) == strtolower(trim('Bytes'))) {
$file_size_array[0] = round($file_size_array[0] / (1024 * 1024), 2);
} else {
$file_size_array[0] = round($file_size_array[0], 2);
}
$response['Downloads'][$key]['FileSize'] = $file_size_array[0];
$response['Downloads'][$key]['DownloadedFileSize'] = $Parray['downloaded_file_size'];
//$thumbnail='<img src="'.$this->view->serverUrl().$this->view->baseUrl()."/".USER_UPLOAD_DIR.$book_thumb_info['image_name_thumb'].'" height="208" width="166">';
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
$response['Downloads'][$key]['ProductThumbnail'] = $thumbnail_path;
//$response['Downloads'][$key]['ProductThumbnail']=$thumbnail;
$response['Downloads'][$key]['StoreName'] = $store_info['country'];
//$response['Downloads'][$key]['StoreId']=$Parray['store_id'];
$response['Downloads'][$key]['Category'] = $cat_info['category_name'];
if (isset($edition_info) && !empty($edition_info)) {
$response['Downloads'][$key]['Edition'] = $edition_info['edition'];
}
$response['Downloads'][$key]['Genre'] = $genre_info['genre'];
$response['Downloads'][$key]['Language'] = $lan_info['language_name'];
$response['Downloads'][$key]['Price'] = $Parray['price'];
$response['Downloads'][$key]['TotalDownloads'] = $Parray['total_downloads'];
$response['Downloads'][$key]['DownloadStatus'] = $Parray['status'];
$response['Downloads'][$key]['PublisherInfo'] = $publisher_info;
if (isset($author_info) && !empty($author_info)) {
$response['Downloads'][$key]['AuthorInfo'] = $author_info;
}
$response['Downloads'][$key]['Edition'] = $edition_info['edition'];
$response['Downloads'][$key]['AddedDate'] = $Parray['added_date'];
$response['Downloads'][$key]['UpdatedDate'] = $Parray['updated_date'];
}
/*echo"<pre>";
print_r($response);
*/
$response = json_encode($response);
echo stripslashes($response);
} else {
$response = '[{"Error":{"Message":"No Records Found."}}]';
echo $response;
}
} else {
$response = '[{"Error":{"Message":"User Id does not exist"}}]';
echo $response;
}
break;
case "ForgotPassword":
$xml = simplexml_load_string($formData['xmldata']);
if ($xml === false) {
$response = '<?xml version="1.0" encoding="utf-8"?>
<Error>
<Message>Error : Invalid XML Format.</Message>
</Error>';
echo $response;
} else {
$sql = 'SELECT * FROM pclive_users where emailid="' . $xml->Email . '"';
$result = $db->query($sql);
$record = $result->FetchAll();
if (count($record) > 0) {
$mailhost = SMTP_SERVER;
$mailconfig = array('ssl' => SMTP_SSL, 'port' => SMTP_PORT, 'auth' => SMTP_AUTH, 'username' => SMTP_USERNAME, 'password' => SMTP_PASSWORD);
$transport = new Zend_Mail_Transport_Smtp($mailhost, $mailconfig);
Zend_Mail::setDefaultTransport($transport);
$message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Electronic Vendor Ltd</title>
<style type="text/css">
body{
margin:0;
padding:0px;
}
#container{
width:700px;
margin:0 auto;
}
#header{
width:700px;
float:left;
padding:40px 0 10px 0;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
text-align:center;
font-size:11px;
}
#header a{
color:#3A3B3F;
font-weight:bold;
text-decoration:none;
}
#header a:hover{
color:#40BBE3;
}
#logopart
{
border:0px solid red;
width:698px;
height:140px;
background-color:#1B75BB;
margin-left:0px;
}
#content{
width:698px;
float:left;
padding:0px 0px 10px 0px;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
border:1px solid #D6D6D6;
font-size:12px;
}
#content p{
margin:0px 20px;
padding:0px 0 20px 0;
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color:#3A3B3F;
}
#content p.logo{
margin:0px;
padding:15px 0 0 20px;
height:77px
}
#content p.title{
margin:0px;
font-size:20px;
font-family:Arial, Helvetica, sans-serif;
border-bottom:3px solid #D6D6D6;
padding:0px 0 13px 0;
margin:25px 20px 14px 20px;
color:#3A3B3F;
}
#content p a{
color:#40BBE3;
text-decoration:none;
}
#content p a:hover{
color:#3A3B3F;
text-decoration:underline;
}
#content h2{
margin:0px;
padding:0 0 14px 0;
font-size:14px;
font-family:Arial, Helvetica, sans-serif;
font-weight:bold;
}
#footer{
width:700px;
float:left;
}
#footer p{
margin:0 0 0 0;
padding:0 0 0 0;
font-family:Arial, Helvetica, sans-serif;
font-size:11px;
color:#78797E;
}
#footer p.disclamer{
margin: 0 0 0 0;
padding:16px 6px 10px 6px;
text-align: justify;
border-bottom:1px solid #3A3B3F;
color:#78797E;
}
#footer p.notice{
margin: 0 0 15px 0;
padding:16px 6px 10px 6px;
text-align: justify;
color:#78797E;
}
</style>
</head>
<body>
<div id="container">
<div id="header"></div>
<div id="content">
<div id="logopart">
<p class="logo"><a href="' . SVN_URL . '" target="_blank">
Online & Offline
</a></p>
</div>
<p class="title">Forgot Password Email</p>
<p>Your login details given below :</p>
<p>Username: ' . $record[0]['username'] . '</p>
<p>Password: ' . $record[0]['password'] . '</p>
<BR />
<br>
<p> </p>
</div>
<div id="footer"> </div>
</div>
</body>
</html>';
$mail = new Zend_Mail();
$mail->addTo($xml->Email);
$mail->setSubject("Forgot Password Email");
$mail->setBodyHtml($message);
$mail->setFrom(SETFROM, SETNAME);
if ($mail->send()) {
$response = '<?xml version="1.0" encoding="utf-8"?>
<Success>
<Message>Message : Password send successfully!. Please check your mail.</Message>
</Success>';
echo $response;
} else {
$response = '<?xml version="1.0" encoding="utf-8"?>
<Error>
<Message>Error : Mail Could not be sent. Try again later!.</Message>
</Error>';
echo $response;
}
} else {
$response = '<?xml version="1.0" encoding="utf-8"?>
<Error>
<Message>Error : No record found.</Message>
</Error>';
echo $response;
}
}
// Validate XML
break;
case "UserForgotPassword":
if (isset($jsonObj->EmailId) && !empty($jsonObj->EmailId)) {
$sql = 'SELECT * FROM pclive_companies where user_email="' . $jsonObj->EmailId . '"';
$result = $db->query($sql);
$record = $result->FetchAll();
$url = 'http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/user/auth/cngpwd/id/';
if (count($record) > 0) {
$mailhost = SMTP_SERVER;
$mailconfig = array('ssl' => SMTP_SSL, 'port' => SMTP_PORT, 'auth' => SMTP_AUTH, 'username' => SMTP_USERNAME, 'password' => SMTP_PASSWORD);
$transport = new Zend_Mail_Transport_Smtp($mailhost, $mailconfig);
Zend_Mail::setDefaultTransport($transport);
$message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Electronic Vendor Ltd</title>
</head>
<body>
<p>To set new password, click on the below link:<br></p>
<p>URL: <a href=' . $url . base64_encode($record[0]['id']) . '/' . mt_rand() . '>' . $url . base64_encode($record[0]['id']) . '/' . mt_rand() . '</a></p>
<BR />
<br>
<p> </p>
</body>
</html>';
$mail = new Zend_Mail();
$mail->addTo($jsonObj->EmailId);
$mail->setSubject("Forgot Password Email");
$mail->setBodyHtml($message);
$mail->setFrom(SETFROM, SETNAME);
if ($mail->send()) {
$response = '{"Message":"Success", "Error":"False" }';
echo $response;
} else {
$response = '{"Message":"Mail Could not be sent. Try again later", "Error":"true" }';
echo $response;
}
} else {
$response = '{"Message":"Please enter a valid user email", "Error":"true"}';
echo $response;
}
// } // Validate XML
}
break;
case "GetAllLibrary":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.cat_id ASC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.cat_id ASC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Library'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Library'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Library'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Library'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Library'][$key]['author_name'] = "";
} else {
$response['Library'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Library'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Library'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Library'][$key]['rating'] = $rs[0];
}
} else {
$response['Library'][$key]['rating'] = 0;
}
$response['Library'][$key]['books_status'] = "Yes";
}
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
} else {
$response['Library'][0]['books_status'] = "No";
}
//$response = stripslashes(json_encode($response, JSON_HEX_APOS));
//echo $response;
//new arrivals
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.id DESC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.id DESC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.id DESC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Newarrivals'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Newarrivals'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Newarrivals'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Newarrivals'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Newarrivals'][$key]['author_name'] = "";
} else {
$response['Newarrivals'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Newarrivals'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Newarrivals'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Newarrivals'][$key]['rating'] = $rs[0];
}
} else {
$response['Newarrivals'][$key]['rating'] = 0;
}
$response['Newarrivals'][$key]['books_status'] = "Yes";
}
} else {
$response['Newarrivals'][0]['books_status'] = "No";
}
//$response = stripslashes(json_encode($response, JSON_HEX_APOS));
//best seller
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.best_seller DESC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.best_seller DESC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.best_seller DESC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Bestsellers'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Bestsellers'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Bestsellers'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Bestsellers'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Bestsellers'][$key]['author_name'] = "";
} else {
$response['Bestsellers'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Bestsellers'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Bestsellers'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Bestsellers'][$key]['rating'] = $rs[0];
}
} else {
$response['Bestsellers'][$key]['rating'] = 0;
}
$response['Bestsellers'][$key]['books_status'] = "Yes";
}
} else {
$response['Bestsellers'][0]['books_status'] = "No";
}
//get featured
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.product_type*1 ASC";
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 ORDER BY prod.product_type*1 ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Featured'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
$response['Featured'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Featured'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Featured'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Featured'][$key]['author_name'] = "";
} else {
$response['Featured'][$key]['author_name'] = $author_info['first_name'];
}
}
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetAllFeaturedLibrary":
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.cat_id ASC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.cat_id ASC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Library'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
$response['Library'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Library'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Library'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Library'][$key]['author_name'] = "";
} else {
$response['Library'][$key]['author_name'] = $author_info['first_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Library'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Library'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Library'][$key]['rating'] = $rs[0];
}
} else {
$response['Library'][$key]['rating'] = 0;
}
$response['Library'][$key]['books_status'] = "Yes";
}
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
$response['Allcategories'] = $data_categories;
} else {
$response['Library'][0]['books_status'] = "No";
}
//$response = stripslashes(json_encode($response, JSON_HEX_APOS));
//echo $response;
//get featured
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.product_type*1 ASC";
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 ORDER BY prod.product_type*1 ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Featured'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
$response['Featured'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Featured'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Featured'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Featured'][$key]['author_name'] = "";
} else {
$response['Featured'][$key]['author_name'] = $author_info['first_name'];
}
}
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetOnlyFeatured":
if ($jsonObj->UserId != '') {
$query_user = "******" . $jsonObj->UserId . "'";
$exe_user = $db->query($query_user);
$result_user = $exe_user->FetchAll();
$array_of_books = array();
$sql_books = "select * from pclive_group_subscriptions where company_id='" . $result_user[0]['parent_id'] . "' and group_id='" . $result_user[0]['group_id'] . "'";
$exe_books = mysql_query($sql_books);
if ($result_user[0]['group_status'] == '1') {
while ($result_books = mysql_fetch_array($exe_books)) {
$array_of_books[] = $result_books['publication_id'];
}
}
$implode_array_of_books = @implode(",", $array_of_books);
}
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 AND storeprice.country_id='{$jsonObj->StoreId}' AND prod.add_time >=DATE( DATE_SUB( NOW( ) , INTERVAL 30 DAY ) ) ORDER BY prod.product_type*1 ASC";
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' and is_featured=1 AND prod.add_time\n>= DATE( DATE_SUB( NOW( ) , INTERVAL 30 DAY ) ) ORDER BY prod.product_type*1 ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Featured'] = $records;
$ii = 0;
foreach ($records as $key => $Parray) {
//echo $Parray['id']." : - book array";
//echo $result_books[$ii]['publication_id']." : - subscription array";
$retVal = array();
$select = 'SELECT * from pclive_country where id="' . $Parray['country_id'] . '"';
$country_result = $db->query($select);
$retVal = $country_result->FetchAll();
$response['Featured'][$key]['country_name'] = $retVal[0]['country'];
//echo ">>>>>".$retVal['currency_id'];
$retVal1 = array();
$select1 = 'SELECT * from pclive_currency where currency_id="' . $retVal[0]['currency_id'] . '"';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
// get symbol with price $retVal1[0]['currency_sign'];
$response['Featured'][$key]['priceText'] = $retVal1[0]['currency_sign'] . " " . $response['Featured'][$key]['price'];
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$response['Featured'][$key]['title'] = $bookbrand_info['brand'];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
/*
$this->modelBooks = new Publisher_Model_DbTable_Books();
$getBrandInfo=$this->modelBooks->getBrandInfo($Parray['title']);
if(!empty($getBrandInfo) && is_numeric($Parray['title']))
{
$bookname=$getBrandInfo['brand'];
}else
{
$bookname=$Parray['title'];
}
if(!empty($Parray['parent_brand_id']) && $Parray['cat_id']!='3')
{
$productInfo=$this->modelBooks->fetchRow('id="'.$Parray['parent_brand_id'].'"');
$getParentBrandInfo=$this->modelBooks->getBrandInfo($productInfo->title);
if(!empty($getParentBrandInfo))
{
$bookname=$getParentBrandInfo['brand'].'-'.$bookname;
}
//$all=getPublicationIdsByCategoryName();
}
$response['Featured'][$key]['title']=$bookname;
$bookname= str_replace(" ","",$bookname);
*/
$response['Featured'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Featured'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
$response['Featured'][$key]['publish_time'] = $Parray['publish_time'] . " 00:00:00";
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
//$response['Featured'][$key]['publisher_name']=$pub_info['first_name']." ".$pub_info['last_name'];
//$response['Featured'][$key]['publisher']=$pub_info['first_name']." ".$pub_info['last_name'];
$response['Featured'][$key]['publisher_name'] = $pub_info['publisher'];
$response['Featured'][$key]['publisher'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Featured'][$key]['author_name'] = "";
} else {
$response['Featured'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Featured'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Featured'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Featured'][$key]['rating'] = $rs[0];
}
} else {
$response['Featured'][$key]['rating'] = 0;
}
$response['Featured'][$key]['books_status'] = "Yes";
$group_name = '';
$query_product_pub = "select parent_brand_id from pclive_products where id= '" . $Parray['id'] . "'";
$rs_product_pub = $db->query($query_product_pub);
$result_product_pub = $rs_product_pub->FetchAll();
if ($result_product_pub[0]['parent_brand_id'] > 0) {
$sql_issue = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and publication_id='" . $result_product_pub[0]['parent_brand_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_issue = $db->query($sql_issue);
$result_issue = $rs_issue->fetchAll();
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_issue[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Featured'][$key]['is_free'] = "true";
$response['Featured'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
if (count($result_issue) > 0) {
$response['Featured'][$key]['is_free'] = "purchased";
$response['Featured'][$key]['group_name'] = $group_name;
/*if($result_issue[0]['subs_type']>0 && $result_issue[0]['remaining_downloads']>0)
{
$start_date = explode(" ",$result_issue[0]['start_date']);
//$start_date ='2014-05-11';
$start_date = $start_date[0];
$query_subscribe_product = "select id from pclive_products where parent_brand_id= '".$result_issue[0]['publication_id']."' and date_format(add_time,'%Y-%m-%d')>'".$start_date[0]."'";
$rs_subscribe_product = $db->query($query_subscribe_product);
$result_subscribe_product = $rs_subscribe_product->FetchAll();
if(count($result_subscribe_product)>0 )
{
$response['Featured'][$key]['is_free']="purchased";
$response['Featured'][$key]['group_name']=$group_name;
}
else
{
$response['Featured'][$key]['is_free']="false";
$response['Featured'][$key]['group_name']=$group_name;
}
}
elseif($result_issue[0]['remaining_downloads']>0)
{
$response['Featured'][$key]['is_free']="purchased";
$response['Featured'][$key]['group_name']=$group_name;
}
else
{
$response['Featured'][$key]['is_free']="false";
$response['Featured'][$key]['group_name']=$group_name;
} */
} else {
$response['Featured'][$key]['is_free'] = "false";
$response['Featured'][$key]['group_name'] = $group_name;
}
} else {
//$sql_pub = "select * from pclive_credit_history";
//$query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
//$rs_pur_book = $db->query($query_pur_book);
// $result_book= $rs_pur_book->fetchAll();
$query_pur_book = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and chd.product_id='" . $Parray['product_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_book = $db->query($query_pur_book);
$result_book = $rs_book->fetchAll();
if (count($result_book) > 0) {
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_book[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Featured'][$key]['is_free'] = "true";
$response['Featured'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
$response['Featured'][$key]['is_free'] = "purchased";
$response['Featured'][$key]['group_name'] = $group_name;
} else {
if ($Parray['price'] == 0 || $Parray['price'] == '') {
$response['Featured'][$key]['is_free'] = "free";
$response['Featured'][$key]['group_name'] = $group_name;
} else {
$response['Featured'][$key]['is_free'] = "false";
$response['Featured'][$key]['group_name'] = $group_name;
}
}
}
/* if(in_array($Parray['id'],$array_of_books))
{
$get_group_name = mysql_query("select * from pclive_company_groups where id= '".$result_user[0]['group_id']."'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Featured'][$key]['is_free']="true";
$response['Featured'][$key]['group_name']= $result_group_name['group_name'];
}
else
{
$query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
$rs_pur_book = $db->query($query_pur_book);
$result_book= $rs_pur_book->FetchAll();
if(count($result_book)>0)
{
$response['Featured'][$key]['is_free']="purchased";
}
else if($Parray['price']==0 || $Parray['price']=='')
{
$response['Featured'][$key]['is_free']="free";
}
else
{
$response['Featured'][$key]['is_free']="false";
}
$response['Featured'][$key]['group_name']= "";
}*/
$ii++;
}
$response['Message'] = "Success.";
$response['error'] = "false";
} else {
//$response = '{"Message":"No Featured Books found","apikey":"","error":"true"}';
$response['Message'] = "No Featured Books found.";
$response['error'] = "true";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetOnlyBestSeller":
if ($jsonObj->UserId != '') {
$query_user = "******" . $jsonObj->UserId . "'";
$exe_user = $db->query($query_user);
$result_user = $exe_user->FetchAll();
$array_of_books = array();
$sql_books = "select * from pclive_group_subscriptions where company_id='" . $result_user[0]['parent_id'] . "' and group_id='" . $result_user[0]['group_id'] . "'";
$exe_books = mysql_query($sql_books);
if ($result_user[0]['group_status'] == '1') {
while ($result_books = mysql_fetch_array($exe_books)) {
$array_of_books[] = $result_books['publication_id'];
}
}
$implode_array_of_books = @implode(",", $array_of_books);
}
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' AND prod.add_time >= DATE( DATE_SUB( NOW( ) , INTERVAL 30 DAY ) ) AND DATE( NOW( ) ) ORDER BY prod.best_seller DESC";
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' AND prod.add_time >= DATE( DATE_SUB( NOW( ) , INTERVAL 30 DAY ) ) AND DATE( NOW( ) ) ORDER BY prod.best_seller DESC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['BestSeller'] = $records;
foreach ($records as $key => $Parray) {
$retVal = array();
$select = 'SELECT * from pclive_country where id="' . $Parray['country_id'] . '"';
$country_result = $db->query($select);
$retVal = $country_result->FetchAll();
//echo ">>>>>".$retVal['currency_id'];
$response['BestSeller'][$key]['country_name'] = $retVal[0]['country'];
$retVal1 = array();
$select1 = 'SELECT * from pclive_currency where currency_id="' . $retVal[0]['currency_id'] . '"';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
// get symbol with price $retVal1[0]['currency_sign'];
$response['BestSeller'][$key]['priceText'] = $retVal1[0]['currency_sign'] . " " . $response['BestSeller'][$key]['price'];
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$response['BestSeller'][$key]['title'] = $bookbrand_info['brand'];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
/*
$this->modelBooks = new Publisher_Model_DbTable_Books();
$getBrandInfo=$this->modelBooks->getBrandInfo($Parray['title']);
if(!empty($getBrandInfo) && is_numeric($Parray['title']))
{
$bookname=$getBrandInfo['brand'];
}else
{
$bookname=$Parray['title'];
}
if(!empty($Parray['parent_brand_id']) && $Parray['cat_id']!='3')
{
$productInfo=$this->modelBooks->fetchRow('id="'.$Parray['parent_brand_id'].'"');
$getParentBrandInfo=$this->modelBooks->getBrandInfo($productInfo->title);
if(!empty($getParentBrandInfo))
{
$bookname=$getParentBrandInfo['brand'].'-'.$bookname;
}
//$all=getPublicationIdsByCategoryName();
}
$response['BestSeller'][$key]['title']=$bookname;
$bookname= str_replace(" ","",$bookname);
*/
$response['BestSeller'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['BestSeller'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
$response['BestSeller'][$key]['publish_time'] = $Parray['publish_time'] . " 00:00:00";
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
//$response['BestSeller'][$key]['publisher_name']=$pub_info['publisher'];
$response['BestSeller'][$key]['publisher_name'] = $pub_info['publisher'];
$response['BestSeller'][$key]['publisher'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['BestSeller'][$key]['author_name'] = "";
} else {
$response['BestSeller'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['BestSeller'][$key]['rating'] = $rs[0] + 1;
} else {
$response['BestSeller'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['BestSeller'][$key]['rating'] = $rs[0];
}
} else {
$response['BestSeller'][$key]['rating'] = 0;
}
$response['BestSeller'][$key]['books_status'] = "Yes";
$group_name = '';
$query_product_pub = "select parent_brand_id from pclive_products where id= '" . $Parray['id'] . "'";
$rs_product_pub = $db->query($query_product_pub);
$result_product_pub = $rs_product_pub->FetchAll();
if ($result_product_pub[0]['parent_brand_id'] > 0) {
$sql_issue = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and publication_id='" . $result_product_pub[0]['parent_brand_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_issue = $db->query($sql_issue);
$result_issue = $rs_issue->fetchAll();
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_issue[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['BestSeller'][$key]['is_free'] = "true";
$response['BestSeller'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
if (count($result_issue) > 0) {
$response['BestSeller'][$key]['is_free'] = "purchased";
$response['BestSeller'][$key]['group_name'] = $group_name;
/*if($result_issue[0]['subs_type']>0 && $result_issue[0]['remaining_downloads']>0)
{
$start_date = explode(" ",$result_issue[0]['start_date']);
//$start_date ='2014-05-11';
$start_date = $start_date[0];
$query_subscribe_product = "select id from pclive_products where parent_brand_id= '".$result_issue[0]['publication_id']."' and date_format(add_time,'%Y-%m-%d')>'".$start_date[0]."'";
$rs_subscribe_product = $db->query($query_subscribe_product);
$result_subscribe_product = $rs_subscribe_product->FetchAll();
if(count($result_subscribe_product)>0 )
{
$response['BestSeller'][$key]['is_free']="purchased";
$response['BestSeller'][$key]['group_name']=$group_name;
}
else
{
$response['BestSeller'][$key]['is_free']="false";
$response['BestSeller'][$key]['group_name']=$group_name;
}
}
elseif($result_issue[0]['remaining_downloads']>0)
{
$response['BestSeller'][$key]['is_free']="purchased";
$response['BestSeller'][$key]['group_name']=$group_name;
}
else
{
$response['BestSeller'][$key]['is_free']="false";
$response['BestSeller'][$key]['group_name']=$group_name;
}*/
} else {
$response['BestSeller'][$key]['is_free'] = "false";
$response['BestSeller'][$key]['group_name'] = $group_name;
}
} else {
//$sql_pub = "select * from pclive_credit_history";
//$query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
//$rs_pur_book = $db->query($query_pur_book);
//$result_book= $rs_pur_book->fetchAll();
$query_pur_book = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and chd.product_id='" . $Parray['product_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_book = $db->query($query_pur_book);
$result_book = $rs_book->fetchAll();
if (count($result_book) > 0) {
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_book[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['BestSeller'][$key]['is_free'] = "true";
$response['BestSeller'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
$response['BestSeller'][$key]['is_free'] = "purchased";
$response['BestSeller'][$key]['group_name'] = $group_name;
} else {
if ($Parray['price'] == 0 || $Parray['price'] == '') {
$response['BestSeller'][$key]['is_free'] = "free";
$response['BestSeller'][$key]['group_name'] = $group_name;
} else {
$response['BestSeller'][$key]['is_free'] = "false";
$response['BestSeller'][$key]['group_name'] = $group_name;
}
}
}
/*
if(in_array($Parray['id'],$array_of_books))
{
$get_group_name = mysql_query("select * from pclive_company_groups where id= '".$result_user[0]['group_id']."'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['BestSeller'][$key]['is_free']="true";
$response['BestSeller'][$key]['group_name']= $result_group_name['group_name'];
}
else
{
$query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
$rs_pur_book = $db->query($query_pur_book);
$result_book= $rs_pur_book->FetchAll();
if(count($result_book)>0)
$response['BestSeller'][$key]['is_free']="purchased";
else if($Parray['price']==0 || $Parray['price']=='')
{
$response['BestSeller'][$key]['is_free']="free";
}
else
$response['BestSeller'][$key]['is_free']="false";
$response['BestSeller'][$key]['group_name']= "";
}*/
}
$response['Message'] = "Success.";
$response['error'] = "false";
} else {
// $response = '[{"Error": {"Message":"No Best Sellers Found.","error":"true"}}]';
$response['Message'] = "No Best Sellers Found.";
$response['error'] = "true";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetOnlyNewArrivals":
if ($jsonObj->UserId != '') {
$query_user = "******" . $jsonObj->UserId . "'";
$exe_user = $db->query($query_user);
$result_user = $exe_user->FetchAll();
$array_of_books = array();
$sql_books = "select * from pclive_group_subscriptions where company_id='" . $result_user[0]['parent_id'] . "' and group_id='" . $result_user[0]['group_id'] . "'";
$exe_books = mysql_query($sql_books);
if ($result_user[0]['group_status'] == '1') {
while ($result_books = mysql_fetch_array($exe_books)) {
$array_of_books[] = $result_books['publication_id'];
}
}
$implode_array_of_books = @implode(",", $array_of_books);
}
$date = date('Y-m-d', time() - 15 * 86400);
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
//$sql="SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='$jsonObj->StoreId' and date(add_time) >= '$date' ORDER BY prod.add_time DESC";
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' AND prod.add_time >=DATE( DATE_SUB( NOW( ) , INTERVAL 30 DAY ) ) ORDER BY prod.add_time DESC ";
} else {
//$sql="SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id WHERE prod.admin_approve='1' AND prod.file_name!='' and date(add_time) >= '$date' ORDER BY prod.add_time DESC";
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' AND prod.add_time >=DATE( DATE_SUB( NOW( ) , INTERVAL 30 DAY ) ) ORDER BY prod.add_time DESC ";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['NewArrivals'] = $records;
foreach ($records as $key => $Parray) {
$retVal = array();
$select = 'SELECT * from pclive_country where id="' . $Parray['country_id'] . '"';
$country_result = $db->query($select);
$retVal = $country_result->FetchAll();
//echo ">>>>>".$retVal['currency_id'];
$response['NewArrivals'][$key]['country_name'] = $retVal[0]['country'];
$retVal1 = array();
$select1 = 'SELECT * from pclive_currency where currency_id="' . $retVal[0]['currency_id'] . '"';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
// get symbol with price $retVal1[0]['currency_sign'];
$response['NewArrivals'][$key]['priceText'] = $retVal1[0]['currency_sign'] . " " . $response['NewArrivals'][$key]['price'];
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$response['NewArrivals'][$key]['title'] = $bookbrand_info['brand'];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
/*
$this->modelBooks = new Publisher_Model_DbTable_Books();
$getBrandInfo=$this->modelBooks->getBrandInfo($Parray['title']);
if(!empty($getBrandInfo) && is_numeric($Parray['title']))
{
$bookname=$getBrandInfo['brand'];
}else
{
$bookname=$Parray['title'];
}
if(!empty($Parray['parent_brand_id']) && $Parray['cat_id']!='3')
{
$productInfo=$this->modelBooks->fetchRow('id="'.$Parray['parent_brand_id'].'"');
$getParentBrandInfo=$this->modelBooks->getBrandInfo($productInfo->title);
if(!empty($getParentBrandInfo))
{
$bookname=$getParentBrandInfo['brand'].'-'.$bookname;
}
//$all=getPublicationIdsByCategoryName();
}
$response['NewArrivals'][$key]['title']=$bookname;
$bookname= str_replace(" ","",$bookname);
*/
$response['NewArrivals'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['NewArrivals'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
$response['NewArrivals'][$key]['publish_time'] = $Parray['publish_time'] . " 00:00:00";
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
//$response['NewArrivals'][$key]['publisher_name']=$pub_info['publisher'];
$response['NewArrivals'][$key]['publisher_name'] = $pub_info['publisher'];
$response['NewArrivals'][$key]['publisher'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['NewArrivals'][$key]['author_name'] = "";
} else {
$response['NewArrivals'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['NewArrivals'][$key]['rating'] = $rs[0] + 1;
} else {
$response['NewArrivals'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['NewArrivals'][$key]['rating'] = $rs[0];
}
} else {
$response['NewArrivals'][$key]['rating'] = 0;
}
$response['NewArrivals'][$key]['books_status'] = "Yes";
/*if(@in_array($Parray['id'],$array_of_books))
{
$get_group_name = mysql_query("select * from pclive_company_groups where id= '".$result_user[0]['group_id']."'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Library'][$key]['is_free']="true";
$response['Library'][$key]['group_name']= $result_group_name['group_name'];
}*/
//else
//{
//echo "<pre>";
//print_r($Parray);
$group_name = '';
$query_product_pub = "select parent_brand_id from pclive_products where id= '" . $Parray['id'] . "'";
$rs_product_pub = $db->query($query_product_pub);
$result_product_pub = $rs_product_pub->FetchAll();
if ($result_product_pub[0]['parent_brand_id'] > 0) {
$sql_issue = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and publication_id='" . $result_product_pub[0]['parent_brand_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_issue = $db->query($sql_issue);
$result_issue = $rs_issue->fetchAll();
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_issue[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['NewArrivals'][$key]['is_free'] = "true";
$response['NewArrivals'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
if (count($result_issue) > 0) {
$response['NewArrivals'][$key]['is_free'] = "purchased";
$response['NewArrivals'][$key]['group_name'] = $group_name;
/*if($result_issue[0]['subs_type']>0 && $result_issue[0]['remaining_downloads']>0)
{
$start_date = explode(" ",$result_issue[0]['start_date']);
//$start_date ='2014-05-11';
$start_date = $start_date[0];
$query_subscribe_product = "select id from pclive_products where parent_brand_id= '".$result_issue[0]['publication_id']."' and date_format(add_time,'%Y-%m-%d')>'".$start_date[0]."'";
$rs_subscribe_product = $db->query($query_subscribe_product);
$result_subscribe_product = $rs_subscribe_product->FetchAll();
if(count($result_subscribe_product)>0 )
{
$response['NewArrivals'][$key]['is_free']="purchased";
$response['NewArrivals'][$key]['group_name']=$group_name;
}
else
{
$response['NewArrivals'][$key]['is_free']="false";
$response['NewArrivals'][$key]['group_name']=$group_name;
}
}
elseif($result_issue[0]['remaining_downloads']>0)
{
$response['NewArrivals'][$key]['is_free']="purchased";
$response['NewArrivals'][$key]['group_name']=$group_name;
}
else
{
$response['NewArrivals'][$key]['is_free']="false";
$response['NewArrivals'][$key]['group_name']=$group_name;
} */
} else {
$response['NewArrivals'][$key]['is_free'] = "false";
$response['NewArrivals'][$key]['group_name'] = $group_name;
}
} else {
//$sql_pub = "select * from pclive_credit_history";
//$query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
//$rs_pur_book = $db->query($query_pur_book);
//$result_book= $rs_pur_book->fetchAll();
$query_pur_book = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and chd.product_id='" . $Parray['product_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.payment_status='1'";
$rs_book = $db->query($query_pur_book);
$result_book = $rs_book->fetchAll();
if (count($result_book) > 0) {
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_book[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['NewArrivals'][$key]['is_free'] = "true";
$response['NewArrivals'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
$response['NewArrivals'][$key]['is_free'] = "purchased";
$response['NewArrivals'][$key]['group_name'] = $group_name;
} else {
if ($Parray['price'] == 0 || $Parray['price'] == '') {
$response['NewArrivals'][$key]['is_free'] = "free";
$response['NewArrivals'][$key]['group_name'] = $group_name;
} else {
$response['NewArrivals'][$key]['is_free'] = "false";
$response['NewArrivals'][$key]['group_name'] = $group_name;
}
}
}
//}
/* if(in_array($Parray['id'],$array_of_books))
{
$get_group_name = mysql_query("select * from pclive_company_groups where id= '".$result_user[0]['group_id']."'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['NewArrivals'][$key]['is_free']="true";
$response['NewArrivals'][$key]['group_name']= $result_group_name['group_name'];
}
else
{
$query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
$rs_pur_book = $db->query($query_pur_book);
$result_book= $rs_pur_book->FetchAll();
if(count($result_book)>0)
$response['NewArrivals'][$key]['is_free']="purchased";
else if($Parray['price']==0 || $Parray['price']=='')
{
$response['NewArrivals'][$key]['is_free']="free";
}
else
$response['NewArrivals'][$key]['is_free']="false";
$response['NewArrivals'][$key]['group_name']= "";
}*/
}
$response['Message'] = "Success.";
$response['error'] = "false";
} else {
//$response = '[{"Error": {"Message":"No New Arrivals Found.","error":"true"}}]';
$response['Message'] = "No New Arrivals";
$response['error'] = "true";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetAllCategories":
$get_all_categories = "select * from pclive_genres where status='1' order by genre ASC";
$res_all_categories = $db->query($get_all_categories);
$data_categories = $res_all_categories->FetchAll();
if (count($data_categories) > 0) {
$response['Allcategories'] = $data_categories;
$response['Message'] = "Success.";
$response['error'] = "false";
} else {
//$response = '[{"Error": {"Message":"No Categories.","error":"true"}}]';
$response['Message'] = "No Categories Found.";
$response['error'] = "true";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "GetFullLibrary":
if ($jsonObj->UserId != '') {
$query_user = "******" . $jsonObj->UserId . "'";
$exe_user = $db->query($query_user);
$result_user = $exe_user->FetchAll();
$array_of_books = array();
$sql_books = "select * from pclive_group_subscriptions where company_id='" . $result_user[0]['parent_id'] . "' and group_id='" . $result_user[0]['group_id'] . "'";
$exe_books = mysql_query($sql_books);
if ($result_user[0]['group_status'] == '1') {
while ($result_books = mysql_fetch_array($exe_books)) {
$array_of_books[] = $result_books['publication_id'];
}
}
$implode_array_of_books = @implode(",", $array_of_books);
}
$main_array = array();
if (!empty($jsonObj->StoreId) && $jsonObj->StoreId > 0) {
$store_qry = 'SELECT is_store,is_store_status from pclive_country where id="' . $jsonObj->StoreId . '" order by id desc LIMIT 1';
$store_result = $db->query($store_qry);
$store_record = $store_result->FetchAll();
$store_info = $store_record[0];
if ($store_info['is_store'] == 1 && $store_info['is_store_status'] == 1) {
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id='{$jsonObj->StoreId}' ORDER BY prod.cat_id ASC";
} else {
//default nigeria
$sql = "SELECT prod.*,c.category_name,g.genre,storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id=storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' AND storeprice.country_id=226 ORDER BY prod.cat_id ASC";
}
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Library'] = $records;
foreach ($records as $key => $Parray) {
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$response['Library'][$key]['title'] = $bookbrand_info['brand'];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
/*
$this->modelBooks = new Publisher_Model_DbTable_Books();
$getBrandInfo=$this->modelBooks->getBrandInfo($Parray['title']);
if(!empty($getBrandInfo) && is_numeric($Parray['title']))
{
$bookname=$getBrandInfo['brand'];
}else
{
$bookname=$Parray['title'];
}
if(!empty($Parray['parent_brand_id']) && $Parray['cat_id']!='3')
{
$productInfo=$this->modelBooks->fetchRow('id="'.$Parray['parent_brand_id'].'"');
$getParentBrandInfo=$this->modelBooks->getBrandInfo($productInfo->title);
if(!empty($getParentBrandInfo))
{
$bookname=$getParentBrandInfo['brand'].'-'.$bookname;
}
//$all=getPublicationIdsByCategoryName();
}
$response['Library'][$key]['title']=$bookname;
$bookname= str_replace(" ","",$bookname);
*/
$retVal = array();
$select = 'SELECT * from pclive_country where id="' . $Parray['country_id'] . '"';
$country_result = $db->query($select);
$retVal = $country_result->FetchAll();
$response['Library'][$key]['country_name'] = $retVal[0]['country'];
//echo ">>>>>".$retVal['currency_id'];
$retVal1 = array();
$select1 = 'SELECT * from pclive_currency where currency_id="' . $retVal[0]['currency_id'] . '"';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
$response['Library'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Library'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
$response['Library'][$key]['publish_time'] = $Parray['publish_time'] . " 00:00:00";
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
//$response['Library'][$key]['publisher_name']=$pub_info['publisher'];
$response['Library'][$key]['publisher_name'] = $pub_info['publisher'];
$response['Library'][$key]['publisher'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Library'][$key]['author_name'] = "";
} else {
$response['Library'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
// get symbol with price $retVal1[0]['currency_sign'];
$response['Library'][$key]['priceText'] = $retVal1[0]['currency_sign'] . " " . $response['Library'][$key]['price'];
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Library'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Library'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Library'][$key]['rating'] = $rs[0];
}
} else {
$response['Library'][$key]['rating'] = 0;
}
$response['Library'][$key]['books_status'] = "Yes";
/*if(@in_array($Parray['id'],$array_of_books))
{
$get_group_name = mysql_query("select * from pclive_company_groups where id= '".$result_user[0]['group_id']."'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Library'][$key]['is_free']="true";
$response['Library'][$key]['group_name']= $result_group_name['group_name'];
}*/
//else
//{
//echo "<pre>";
//print_r($Parray);
$group_name = '';
$query_product_pub = "select parent_brand_id from pclive_products where id= '" . $Parray['id'] . "'";
$rs_product_pub = $db->query($query_product_pub);
$result_product_pub = $rs_product_pub->FetchAll();
if ($result_product_pub[0]['parent_brand_id'] > 0) {
$sql_issue = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and publication_id='" . $result_product_pub[0]['parent_brand_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_issue = $db->query($sql_issue);
$result_issue = $rs_issue->fetchAll();
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_issue[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Library'][$key]['is_free'] = "true";
$response['Library'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
if (count($result_issue) > 0) {
$response['Library'][$key]['is_free'] = "purchased";
$response['Library'][$key]['group_name'] = $group_name;
/*if($result_issue[0]['subs_type']>0 && $result_issue[0]['remaining_downloads']>0)
{
$start_date = explode(" ",$result_issue[0]['start_date']);
//$start_date ='2014-05-11';
$start_date = $start_date[0];
$query_subscribe_product = "select id from pclive_products where parent_brand_id= '".$result_issue[0]['publication_id']."' and date_format(add_time,'%Y-%m-%d')>'".$start_date[0]."'";
$rs_subscribe_product = $db->query($query_subscribe_product);
$result_subscribe_product = $rs_subscribe_product->FetchAll();
if(count($result_subscribe_product)>0 )
{
$response['Library'][$key]['is_free']="purchased";
$response['Library'][$key]['group_name']=$group_name;
}
else
{
$response['Library'][$key]['is_free']="false";
$response['Library'][$key]['group_name']=$group_name;
}
}
elseif($result_issue[0]['remaining_downloads']>0)
{
$response['Library'][$key]['is_free']="purchased";
$response['Library'][$key]['group_name']=$group_name;
}
else
{
$response['Library'][$key]['is_free']="false";
$response['Library'][$key]['group_name']=$group_name;
} */
} else {
$response['Library'][$key]['is_free'] = "false";
$response['Library'][$key]['group_name'] = $group_name;
}
} else {
//$sql_pub = "select * from pclive_credit_history";
//$query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
//$rs_pur_book = $db->query($query_pur_book);
//$result_book= $rs_pur_book->fetchAll();
$query_pur_book = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and chd.product_id='" . $Parray['product_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_book = $db->query($query_pur_book);
$result_book = $rs_book->fetchAll();
if (count($result_book) > 0) {
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_book[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Library'][$key]['is_free'] = "true";
$response['Library'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
$response['Library'][$key]['is_free'] = "purchased";
$response['Library'][$key]['group_name'] = $group_name;
} else {
if ($Parray['price'] == 0 || $Parray['price'] == '') {
$response['Library'][$key]['is_free'] = "free";
$response['Library'][$key]['group_name'] = $group_name;
} else {
$response['Library'][$key]['is_free'] = "false";
$response['Library'][$key]['group_name'] = $group_name;
}
}
}
//}
}
$response['Message'] = "Success.";
$response['error'] = "false";
} else {
$response = '[{"Error": {"Message":"No New Arrivals Found.","error":"true"}}]';
$response['Message'] = "No Books in library.";
$response['error'] = "true";
}
///echo "<pre>";
// print_r($response);
// exit;
$response = json_encode($response, JSON_HEX_APOS);
echo $response;
break;
case "GetFullStoreLibrary":
if ($jsonObj->UserId != '') {
$query_user = "******" . $jsonObj->UserId . "'";
$exe_user = $db->query($query_user);
$result_user = $exe_user->FetchAll();
$array_of_books = array();
$sql_books = "select * from pclive_group_subscriptions where company_id='" . $result_user[0]['parent_id'] . "' and group_id='" . $result_user[0]['group_id'] . "'";
$exe_books = mysql_query($sql_books);
while ($result_books = mysql_fetch_array($exe_books)) {
$array_of_books[] = $result_books['publication_id'];
}
$implode_array_of_books = @implode(",", $array_of_books);
}
$main_array = array();
if (!empty($jsonObj->Keyword)) {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' and (prod.title like '%{$jsonObj->Keyword}%' or prod.description like '%{$jsonObj->Keyword}%') ORDER BY prod.cat_id ASC";
} else {
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' ORDER BY prod.cat_id ASC";
}
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['Library'] = $records;
foreach ($records as $key => $Parray) {
$retVal = array();
$select = 'SELECT * from pclive_country where id="' . $Parray['country_id'] . '"';
$country_result = $db->query($select);
$retVal = $country_result->FetchAll();
$response['Library'][$key]['country_name'] = $retVal[0]['country'];
//echo ">>>>>".$retVal['currency_id'];
$retVal1 = array();
$select1 = 'SELECT * from pclive_currency where currency_id="' . $retVal[0]['currency_id'] . '"';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
// get symbol with price $retVal1[0]['currency_sign'];
$response['Library'][$key]['priceText'] = $retVal1[0]['currency_sign'] . " " . $response['Library'][$key]['price'];
//$response['Library'][$key]['price']=$response['Library'][$key]['price'];
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$response['Library'][$key]['title'] = $bookbrand_info['brand'];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
/*
$this->modelBooks = new Publisher_Model_DbTable_Books();
$getBrandInfo=$this->modelBooks->getBrandInfo($Parray['title']);
if(!empty($getBrandInfo) && is_numeric($Parray['title']))
{
$bookname=$getBrandInfo['brand'];
}else
{
$bookname=$Parray['title'];
}
if(!empty($Parray['parent_brand_id']) && $Parray['cat_id']!='3')
{
$productInfo=$this->modelBooks->fetchRow('id="'.$Parray['parent_brand_id'].'"');
$getParentBrandInfo=$this->modelBooks->getBrandInfo($productInfo->title);
if(!empty($getParentBrandInfo))
{
$bookname=$getParentBrandInfo['brand'].'-'.$bookname;
}
//$all=getPublicationIdsByCategoryName();
}
$response['Library'][$key]['title']=$bookname;
$bookname= str_replace(" ","",$bookname);
*/
$response['Library'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['Library'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
$response['Library'][$key]['publish_time'] = $Parray['publish_time'] . " 00:00:00";
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
$response['Library'][$key]['publisher_name'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['Library'][$key]['author_name'] = "";
} else {
$response['Library'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['Library'][$key]['rating'] = $rs[0] + 1;
} else {
$response['Library'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['Library'][$key]['rating'] = $rs[0];
}
} else {
$response['Library'][$key]['rating'] = 0;
}
$response['Library'][0]['books_status'] = 'Yes';
/*if(@in_array($Parray['id'],$array_of_books))
{
$get_group_name = mysql_query("select * from pclive_company_groups where id= '".$result_user[0]['group_id']."'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Library'][$key]['is_free']="true";
$response['Library'][$key]['group_name']= $result_group_name['group_name'];
}*/
//else
//{
//echo "<pre>";
//print_r($Parray);
$group_name = '';
$query_product_pub = "select parent_brand_id from pclive_products where id= '" . $Parray['id'] . "'";
$rs_product_pub = $db->query($query_product_pub);
$result_product_pub = $rs_product_pub->FetchAll();
if ($result_product_pub[0]['parent_brand_id'] > 0) {
$sql_issue = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and publication_id='" . $result_product_pub[0]['parent_brand_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_issue = $db->query($sql_issue);
$result_issue = $rs_issue->fetchAll();
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_issue[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Library'][$key]['is_free'] = "true";
$response['Library'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
if (count($result_issue) > 0) {
$response['Library'][$key]['is_free'] = "purchased";
$response['Library'][$key]['group_name'] = $group_name;
/*if($result_issue[0]['subs_type']>0 && $result_issue[0]['remaining_downloads']>0)
{
$start_date = explode(" ",$result_issue[0]['start_date']);
//$start_date ='2014-05-11';
$start_date = $start_date[0];
$query_subscribe_product = "select id from pclive_products where parent_brand_id= '".$result_issue[0]['publication_id']."' and date_format(add_time,'%Y-%m-%d')>'".$start_date[0]."'";
$rs_subscribe_product = $db->query($query_subscribe_product);
$result_subscribe_product = $rs_subscribe_product->FetchAll();
if(count($result_subscribe_product)>0 )
{
$response['Library'][$key]['is_free']="purchased";
$response['Library'][$key]['group_name']=$group_name;
}
else
{
$response['Library'][$key]['is_free']="false";
$response['Library'][$key]['group_name']=$group_name;
}
}
elseif($result_issue[0]['remaining_downloads']>0)
{
$response['Library'][$key]['is_free']="purchased";
$response['Library'][$key]['group_name']=$group_name;
}
else
{
$response['Library'][$key]['is_free']="false";
$response['Library'][$key]['group_name']=$group_name;
} */
} else {
$response['Library'][$key]['is_free'] = "false";
$response['Library'][$key]['group_name'] = $group_name;
}
} else {
//$sql_pub = "select * from pclive_credit_history";
// $query_pur_book = "select * from pclive_credit_history where userid= '".$jsonObj->UserId."' and payment_status=1 and bookid= '".$Parray['product_id']."'";
//$rs_pur_book = $db->query($query_pur_book);
// $result_book= $rs_pur_book->fetchAll();
$query_pur_book = "select *,chd.subscription_type as subs_type,chd.group_id as grp_id,chd.start_date as start_date,chd.publication_id as publication_id,chd.number_of_issues,chd.number_of_downloaded,chd.remaining_downloads from pclive_credit_history as ch,pclive_user_sub_details chd where ch.order_id=chd.order_id and chd.product_id='" . $Parray['product_id'] . "' and chd.user_id='" . $jsonObj->UserId . "' and ch.bookid='" . $Parray['product_id'] . "' and ch.payment_status='1'";
$rs_book = $db->query($query_pur_book);
$result_book = $rs_book->fetchAll();
if (count($result_book) > 0) {
if ($result_issue[0]['grp_id'] != 0) {
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_book[0]['grp_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['Library'][$key]['is_free'] = "true";
$response['Library'][$key]['group_name'] = $result_group_name['group_name'];
$group_name = $result_group_name['group_name'];
}
$response['Library'][$key]['is_free'] = "purchased";
$response['Library'][$key]['group_name'] = $group_name;
} else {
if ($Parray['price'] == 0 || $Parray['price'] == '') {
$response['Library'][$key]['is_free'] = "free";
$response['Library'][$key]['group_name'] = $group_name;
} else {
$response['Library'][$key]['is_free'] = "false";
$response['Library'][$key]['group_name'] = $group_name;
}
}
}
//}
}
$response['Message'] = "Success.";
$response['error'] = "false";
} else {
$response = '[{"Error": {"Message":"No New Arrivals Found.","error":"true"}}]';
$response['Message'] = "No Books in library.";
$response['error'] = "true";
$response['Library'][0]['books_status'] = 'No';
}
///echo "<pre>";
// print_r($response);
// exit;
$response = json_encode($response, JSON_HEX_APOS);
echo $response;
break;
case "GetFreeLibrary":
if ($jsonObj->UserId != '') {
$query_user = "******" . $jsonObj->UserId . "' and parent_id!=0 and group_id!=0 and group_status='1'";
$exe_user = $db->query($query_user);
$result_user = $exe_user->FetchAll();
if (count($result_user) > 0) {
$query_group_name = "select * from pclive_companies where id = '" . $jsonObj->UserId . "' and parent_id!=0 and group_id!=0";
$exe_group = $db->query($query_group_name);
$result_group = $exe_group->FetchAll();
// Get group name from group id
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_group[0]['group_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$query_free_book = "select bookid from pclive_credit_history where userid = '" . $result_user[0]['parent_id'] . "' and payment_status=1 and group_id='" . $result_group[0]['group_id'] . "'";
$exe_free_book = $db->query($query_free_book);
$result_book = $exe_free_book->FetchAll();
$book_id_arr = array();
foreach ($result_book as $key1 => $book) {
$book_id_arr[] = $book['bookid'];
}
$bookstr = implode(",", $book_id_arr);
if (count($result_book) > 0) {
$main_array = array();
$sql = "SELECT prod.*,c.category_name,g.genre, storeprice.product_id, storeprice.country_id, storeprice.language_id, storeprice.price FROM pclive_products as prod INNER JOIN pclive_product_prices as storeprice ON prod.id = storeprice.product_id INNER JOIN pclive_categories c on c.id=prod.cat_id INNER JOIN pclive_genres g on prod.product_type=g.id INNER JOIN pclive_product_images img ON prod.id=img.product_id WHERE prod.admin_approve='1' AND prod.file_name!='' and prod.id in({$bookstr}) ORDER BY prod.cat_id ASC";
$result = $db->query($sql);
$records = $result->FetchAll();
if (count($records) > 0) {
$response['groupBooks'] = $records;
foreach ($records as $key => $Parray) {
$retVal = array();
$select = 'SELECT * from pclive_country where id="' . $Parray['country_id'] . '"';
$country_result = $db->query($select);
$retVal = $country_result->FetchAll();
$response['groupBooks'][$key]['country_name'] = $retVal[0]['country'];
//echo ">>>>>".$retVal['currency_id'];
$retVal1 = array();
$select1 = 'SELECT * from pclive_currency where currency_id="' . $retVal[0]['currency_id'] . '"';
$currency_result = $db->query($select1);
$retVal1 = $currency_result->FetchAll();
// get symbol with price $retVal1[0]['currency_sign'];
$response['groupBooks'][$key]['priceText'] = $retVal1[0]['currency_sign'] . " " . $response['groupBooks'][$key]['price'];
$book_thumb_qry = 'SELECT * from pclive_product_images where product_id="' . $Parray['product_id'] . '" order by id desc LIMIT 1';
$boothumb_result = $db->query($book_thumb_qry);
$book_thumb_record = $boothumb_result->FetchAll();
$book_thumb_info = $book_thumb_record[0];
if ($book_thumb_info['image_name_thumb'] != '') {
$thumbnail_path = $this->view->serverUrl() . $this->view->baseUrl() . "/" . USER_UPLOAD_DIR . $book_thumb_info['image_name_thumb'];
} else {
$thumbnail_path = "";
}
$bookname = str_replace(" ", "", $Parray['title']);
if (is_numeric($Parray['title'])) {
$bookbrand = "select * from pclive_brands where id='" . $Parray['title'] . "' ";
$bookbrand_result = $db->query($bookbrand);
$bookbrand_record = $bookbrand_result->FetchAll();
$bookbrand_info = $bookbrand_record[0];
$response['groupBooks'][$key]['title'] = $bookbrand_info['brand'];
$bookname = str_replace(" ", "", $bookbrand_info['brand']);
}
/*
$this->modelBooks = new Publisher_Model_DbTable_Books();
$getBrandInfo=$this->modelBooks->getBrandInfo($Parray['title']);
if(!empty($getBrandInfo) && is_numeric($Parray['title']))
{
$bookname=$getBrandInfo['brand'];
}else
{
$bookname=$Parray['title'];
}
if(!empty($Parray['parent_brand_id']) && $Parray['cat_id']!='3')
{
$productInfo=$this->modelBooks->fetchRow('id="'.$Parray['parent_brand_id'].'"');
$getParentBrandInfo=$this->modelBooks->getBrandInfo($productInfo->title);
if(!empty($getParentBrandInfo))
{
$bookname=$getParentBrandInfo['brand'].'-'.$bookname;
}
//$all=getPublicationIdsByCategoryName();
}
$response['groupBooks'][$key]['title']=$bookname;
$bookname= str_replace(" ","",$bookname);
*/
$response['groupBooks'][$key]['ProductThumbnail'] = $thumbnail_path;
$response['groupBooks'][$key]['Producturl'] = "http://miprojects2.com.php53-6.ord1-1.websitetestlink.com/projects/evendor/api/download/index/apicall/Bookdownload/apikey/" . $jsonObj->apikey . "/bookid/" . $Parray['product_id'] . "/bookname/" . $bookname;
$response['groupBooks'][$key]['publish_time'] = $Parray['publish_time'] . " 00:00:00";
//code to get publisher name from user table
$pub_qry = 'SELECT publisher from pclive_users where id="' . $Parray['publisher_id'] . '" order by id desc LIMIT 1';
$pub_result = $db->query($pub_qry);
$pub_record = $pub_result->FetchAll();
$pub_info = $pub_record[0];
//$response['groupBooks'][$key]['publisher_name']=$pub_info['publisher'];
//$response['groupBooks'][$key]['publisher_name']=$pub_info['first_name']." ".$pub_info['last_name'];
//$response['groupBooks'][$key]['publisher']=$pub_info['first_name']." ".$pub_info['last_name'];
$response['groupBooks'][$key]['publisher_name'] = $pub_info['publisher'];
$response['groupBooks'][$key]['publisher'] = $pub_info['publisher'];
//code to get author name from user table
$author_qry = 'SELECT first_name,last_name from pclive_users where id="' . $Parray['author_id'] . '" order by id desc LIMIT 1';
$author_result = $db->query($author_qry);
$author_record = $author_result->FetchAll();
$author_info = $author_record[0];
if ($author_info['first_name'] == "") {
$response['groupBooks'][$key]['author_name'] = "";
} else {
$response['groupBooks'][$key]['author_name'] = $author_info['first_name'] . " " . $author_info['last_name'];
}
$review_qry = 'SELECT avg(rating*1) as rate,`productid` FROM pclive_review where productid="' . $Parray['product_id'] . '" group by productid';
$review_result = $db->query($review_qry);
$review_record = $review_result->FetchAll();
$review_info = $review_record[0];
if (count($review_record) > 0) {
$rs = explode(".", $review_info['rate']);
if ($rs[1] != '') {
if ("." . $rs[1] > 0.5) {
$response['groupBooks'][$key]['rating'] = $rs[0] + 1;
} else {
$response['groupBooks'][$key]['rating'] = $rs[0] + 0.5;
}
} else {
$response['groupBooks'][$key]['rating'] = $rs[0];
}
} else {
$response['groupBooks'][$key]['rating'] = 0;
}
$response['groupBooks'][$key]['books_status'] = "Yes";
$get_group_name = mysql_query("select * from pclive_company_groups where id= '" . $result_user[0]['group_id'] . "'");
$result_group_name = mysql_fetch_array($get_group_name);
$response['groupBooks'][$key]['is_free'] = "true";
$response['groupBooks'][$key]['group_name'] = $result_group_name['group_name'];
}
$response['Message'] = "Success.";
$response['error'] = "false";
}
} else {
$response['Message'] = "No group publication is subscribed for you.";
$response['error'] = "true";
}
} else {
$response['Message'] = "You are not a group user.";
$response['error'] = "true";
}
} else {
//$response = '[{"Error": {"Message":"No New Arrivals Found.","error":"true"}}]';
$response['Message'] = "User Id does not exist.";
$response['error'] = "true";
}
$response = stripslashes(json_encode($response, JSON_HEX_APOS));
echo $response;
break;
case "purchasedBooks":
$query_pur_book = "select * from pclive_credit_history where userid= '" . $jsonObj->userid . "' and payment_status=1 and bookid= '" . $jsonObj->bookid . "'";
$rs_pur_book = $db->query($query_pur_book);
$result_book = $rs_pur_book->FetchAll();
if (count($result_book) > 0) {
echo '{"Message":"success", "error":"false"}';
} else {
echo '{"Message":"You have to purchase from website", "error":"true"}';
}
break;
case "pushNotification":
//$idreg="APA91bG-BjQAinY8ZzhFn0_3OT9CpO1_1vuWVStZsOiiX-Lj8gNCEchp-sUw77zFAWzV-KvGKAKk_IfvkixA1DyQ8jcc7iTKOlFv5a_Wa_htmsQqAXxfAgn1fsgaa-dtjHCiL2jA69JzyLMQDlMg6ndBvKvuxnMDCo07R6AnPpv13DvC8DY6a7E";
//$idreg="APA91bE3oteFpKRBhLyKlpa4OplH6-4lzpw47iSa8bSZzGlsgm8_YBoVEEhUpSjAvvIj-9jn1FmG2RgVIKpbOILKYddGBCP217XcO1wiN6APbxOicR87ISc2pdPDRpj40LAUvohR7m1ppkDjGoJsiKIEDNOJ68UAmA";
$idreg = "APA91bErTCy2Ubl6otSCoad0I4_gA6gYPdDDN_8c4cVGFPPKXRfIculGJMhNiT1zhyg8f_BQsjaTNYHSd1NtxwH0qh2NZVwwUu8LpiC102VlKkowsLgpXTAqCXMrru0zVs7cP5unwy5kBChXM6a9IpEDn1zI8AOouw";
//$idreg="APA91bErTCy2Ubl6otSCoad0I4_gA6gYPdDDN_8c4cVGFPPKXRfIculGJMhNiT1zhyg8f_BQsjaTNYHSd1NtxwH0qh2NZVwwUu8LpiC102VlKkowsLgpXTAqCXMrru0zVs7cP5unwy5kBChXM6a9IpEDn1zI8AOouw";
$regID = array($idreg);
// $message="You have registerted successfully";
$message = array("userID" => '7236');
$this->send_push_notification($regID, $message);
echo "PushNotification testing";
break;
default:
echo "Sorry! Invalid Method Call";
}
} else {
echo "Invalid Request Format";
}
exit;
}
public function createAction()
{
$this->view->messages = $this->_flashMessenger->getMessages();
$this->_helper->layout->disableLayout();
$formData = array();
$formErrors = array();
$formData = $this->getRequest()->getPost();
//print_r($formData);exit;
if ($this->getRequest()->isPost() && isset($formData['create_member']) && $formData['create_member'] == 'Create') {
if (!isset($formData['group_id']) || empty($formData['group_id'])) {
$formErrors['group_id'] = "Please select a group";
}
if (!isset($formData['first_name']) || trim($formData['first_name']) == "") {
$formErrors['first_name'] = "Please enter first name";
}
if (!isset($formData['last_name']) || trim($formData['last_name']) == "") {
$formErrors['last_name'] = "Please enter last name";
}
if (!isset($formData['user_email']) || trim($formData['user_email']) == "") {
$formErrors['user_email'] = "Please enter email";
}
if (!isset($formData['user_password']) || trim($formData['user_password']) == "") {
$formErrors['user_password'] = "******";
}
if (!CommonFunctions::isValidEmail($formData['user_email'])) {
if (!array_key_exists('user_email', $formErrors)) {
$formErrors['user_email'] = "Please enter valid email";
}
}
/*if($this->modelCompany->isExist('username="******"'))
{
if(!(array_key_exists('username',$formErrors)))
{
$formErrors['username']="******";
}
}
*/
if ($this->modelCompany->isExistCompany('user_email="' . $formData['user_email'] . '" and (account_type="1" or account_type="3")') || $this->modelPublisher->isExist('emailid="' . $formData['user_email'] . '"')) {
if (!array_key_exists('user_email', $formErrors)) {
$formErrors['user_email'] = "Email already exist for company or member of company or publisher";
}
}
if ($this->modelCompany->isExist('user_email="' . $formData['user_email'] . '" and (parent_id!="0" or group_id!="0")')) {
if (!array_key_exists('user_email', $formErrors)) {
$formErrors['user_email'] = "Email already member of a group.";
}
}
if (count($formErrors) == 0) {
if ($this->getRequest()->isPost()) {
$groupName = $this->modelGroup->getInfoByGroupId($formData['group_id']);
########################## get user who are not publisher,company and member of other company ######################
$memberData = $this->modelCompany->getNonMemberUser($formData['user_email']);
if (count($memberData) > 0) {
//$groupName = $this->modelGroup->getInfoByGroupId($formData['group_id']);
$activationCode = CommonFunctions::generateGUID();
$add_time = date('Y-m-d H:i:s');
$formData['user_password'] = empty($formData['user_password']) ? CommonFunctions::getRandomNumberPassword(8) : $formData['user_password'];
$formData['company_id'] = !empty($this->sessCompanyInfo->id) ? $this->sessCompanyInfo->id : 0;
$MemberUserData = array('parent_id' => $formData['company_id'], 'group_varify_id' => $formData['group_id'], 'user_email' => $formData['user_email'], 'account_type' => 3, 'status' => '1', 'updated_date' => date("Y-m-d H:i:s"), 'activation_code' => $activationCode, 'added_date' => $add_time);
$group_id = $formData['group_id'];
$lastId = $this->modelCompany->update($MemberUserData, "id='" . $memberData[0]['id'] . "'");
if ($memberData[0]['id'] != '') {
$mailhost = SMTP_SERVER;
$mailconfig = array('ssl' => SMTP_SSL, 'port' => SMTP_PORT, 'auth' => SMTP_AUTH, 'username' => SMTP_USERNAME, 'password' => SMTP_PASSWORD);
$transport = new Zend_Mail_Transport_Smtp($mailhost, $mailconfig);
Zend_Mail::setDefaultTransport($transport);
$varification_url = $this->view->serverUrl() . $this->view->baseUrl() . '/user/register/groupverification/code/' . $activationCode . '/id/' . $group_id;
$message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Electronic Vendor Ltd</title>
<style type="text/css">
body{
margin:0;
padding:0px;
}
#container{
width:700px;
margin:0 auto;
}
#header{
width:700px;
float:left;
padding:40px 0 10px 0;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
text-align:center;
font-size:11px;
}
#header a{
color:#3A3B3F;
font-weight:bold;
text-decoration:none;
}
#header a:hover{
color:#40BBE3;
}
#logopart
{
border:0px solid red;
width:698px;
height:140px;
background-color:#1B75BB;
margin-left:0px;
}
#content{
width:698px;
float:left;
padding:0px 0px 10px 0px;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
border:1px solid #D6D6D6;
font-size:12px;
}
#content p{
margin:0px 20px;
padding:0px 0 20px 0;
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color:#3A3B3F;
}
#content p.logo{
margin:0px;
padding:15px 0 0 20px;
height:77px
}
#content p.title{
margin:0px;
font-size:20px;
font-family:Arial, Helvetica, sans-serif;
border-bottom:3px solid #D6D6D6;
padding:0px 0 13px 0;
margin:25px 20px 14px 20px;
color:#3A3B3F;
}
#content p a{
color:#40BBE3;
text-decoration:none;
}
#content p a:hover{
color:#3A3B3F;
text-decoration:underline;
}
#content h2{
margin:0px;
padding:0 0 14px 0;
font-size:14px;
font-family:Arial, Helvetica, sans-serif;
font-weight:bold;
}
#footer{
width:700px;
float:left;
}
#footer p{
margin:0 0 0 0;
padding:0 0 0 0;
font-family:Arial, Helvetica, sans-serif;
font-size:11px;
color:#78797E;
}
#footer p.disclamer{
margin: 0 0 0 0;
padding:16px 6px 10px 6px;
text-align: justify;
border-bottom:1px solid #3A3B3F;
color:#78797E;
}
#footer p.notice{
margin: 0 0 15px 0;
padding:16px 6px 10px 6px;
text-align: justify;
color:#78797E;
}
</style>
</head>
<body>
<div id="container">
<div id="header"></div>
<div id="content">
<div id="logopart">
<p class="logo"><a href="' . SVN_URL . '" target="_blank">
Electronic Vendor Ltd
</a></p>
</div>
<p class="title">To be active member of this "' . $groupName['group_name'] . '" group click below link.</p>
<BR />
<p style="color:#ffffff;"><a href="' . $varification_url . '">Group Activation Link</a></p>
<br>
<p class="title">Membership of a ' . $groupName['group_name'] . ' group email</p>
<p>Congrats you are member of a ' . $groupName['group_name'] . ' group :</p>
<BR />
<p> </p>
</div>
<div id="footer"> </div>
</div>
</body>
</html>';
$mail = new Zend_Mail();
$mail->addTo($formData['user_email']);
$mail->setSubject("Membership of a " . $groupName['group_name'] . " group email.");
$mail->setBodyHtml($message);
$mail->setFrom(SETFROM, SETNAME);
if ($mail->send()) {
$this->_flashMessenger->addMessage('<div class="div-success">Individual member is updated to member of this group.User Name and password will remain same of the user.</div>');
} else {
$this->view->errorMessage = '<div class="div-error">Mail could not be sent. Try again later.</div>';
}
$this->_redirect('company/member/');
}
} else {
$activationCode = CommonFunctions::generateGUID();
$add_time = date('Y-m-d H:i:s');
$formData['user_password'] = empty($formData['user_password']) ? CommonFunctions::getRandomNumberPassword(8) : $formData['user_password'];
$formData['company_id'] = !empty($this->sessCompanyInfo->id) ? $this->sessCompanyInfo->id : 0;
$username_array = explode("@", $formData['user_email']);
$formData['user_name'] = $username_array[0];
$MemberUserData = array('parent_id' => $formData['company_id'], 'group_id' => $formData['group_id'], 'user_email' => $formData['user_email'], 'user_password' => md5($formData['user_password']), 'user_name' => $formData['user_name'], 'first_name' => $formData['first_name'], 'account_type' => 3, 'last_name' => $formData['last_name'], 'status' => '0', 'updated_date' => date("Y-m-d H:i:s"), 'activation_code' => $activationCode, 'added_date' => $add_time);
$lastId = $this->modelCompany->insert($MemberUserData);
if ($lastId > 0) {
$mailhost = SMTP_SERVER;
$mailconfig = array('ssl' => SMTP_SSL, 'port' => SMTP_PORT, 'auth' => SMTP_AUTH, 'username' => SMTP_USERNAME, 'password' => SMTP_PASSWORD);
$transport = new Zend_Mail_Transport_Smtp($mailhost, $mailconfig);
Zend_Mail::setDefaultTransport($transport);
$message = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Electronic Vendor Ltd</title>
<style type="text/css">
body{
margin:0;
padding:0px;
}
#container{
width:700px;
margin:0 auto;
}
#header{
width:700px;
float:left;
padding:40px 0 10px 0;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
text-align:center;
font-size:11px;
}
#header a{
color:#3A3B3F;
font-weight:bold;
text-decoration:none;
}
#header a:hover{
color:#40BBE3;
}
#logopart
{
border:0px solid red;
width:698px;
height:140px;
background-color:#1B75BB;
margin-left:0px;
}
#content{
width:698px;
float:left;
padding:0px 0px 10px 0px;
font-family:Arial, Helvetica, sans-serif;
color:#3A3B3F;
border:1px solid #D6D6D6;
font-size:12px;
}
#content p{
margin:0px 20px;
padding:0px 0 20px 0;
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color:#3A3B3F;
}
#content p.logo{
margin:0px;
padding:15px 0 0 20px;
height:77px
}
#content p.title{
margin:0px;
font-size:20px;
font-family:Arial, Helvetica, sans-serif;
border-bottom:3px solid #D6D6D6;
padding:0px 0 13px 0;
margin:25px 20px 14px 20px;
color:#3A3B3F;
}
#content p a{
color:#40BBE3;
text-decoration:none;
}
#content p a:hover{
color:#3A3B3F;
text-decoration:underline;
}
#content h2{
margin:0px;
padding:0 0 14px 0;
font-size:14px;
font-family:Arial, Helvetica, sans-serif;
font-weight:bold;
}
#footer{
width:700px;
float:left;
}
#footer p{
margin:0 0 0 0;
padding:0 0 0 0;
font-family:Arial, Helvetica, sans-serif;
font-size:11px;
color:#78797E;
}
#footer p.disclamer{
margin: 0 0 0 0;
padding:16px 6px 10px 6px;
text-align: justify;
border-bottom:1px solid #3A3B3F;
color:#78797E;
}
#footer p.notice{
margin: 0 0 15px 0;
padding:16px 6px 10px 6px;
text-align: justify;
color:#78797E;
}
</style>
</head>
<body>
<div id="container">
<div id="header"></div>
<div id="content">
<div id="logopart">
<p class="logo"><a href="' . SVN_URL . '" target="_blank">
Electronic Vendor Ltd
</a></p>
</div>
<BR />
<p style="color:#ffffff;">Activate your account by using given below link :</p>
<BR />
<br>
<p class="title">To activate your membership of ' . $groupName['group_name'] . ' and active member of this group please click below link.</p>
<p style="color:#ffffff;"><a href="' . $this->view->serverUrl() . $this->view->baseUrl() . '/user/register/verificationwithgroup/' . $activationCode . '">Account Activation Link</a></p>
<br>
<p class="title">After activating your account login with following information.</p>
<p>Your login details given below :</p>
<p>Username: ' . $formData['user_email'] . '</p>
<p>Password: ' . $formData['user_password'] . '</p>
<p>Password: ' . $groupName['group_name'] . '</p>
<BR />
<p> </p>
</div>
<div id="footer"> </div>
</div>
</body>
</html>';
$mail = new Zend_Mail();
$mail->addTo($formData['user_email']);
$mail->setSubject("Member Registration Email");
$mail->setBodyHtml($message);
$mail->setFrom(SETFROM, SETNAME);
if ($mail->send()) {
$this->_flashMessenger->addMessage('<div class="div-success">Member created successfully</div>');
} else {
$this->view->errorMessage = '<div class="div-error">Mail could not be sent. Try again later.</div>';
}
$this->_redirect('company/member/');
}
}
}
} else {
//$this->view->errorMessage = '<div class="div-error">Please enter required fields properly.</div>';
//$this->_redirect('company/member/');
}
} else {
$formData['first_name'] = "";
$formData['last_name'] = "";
$formData['user_email'] = "";
$formData['user_password'] = "";
}
$this->view->formData = $formData;
$this->view->formErrors = $formErrors;
$sessionMsg = new Zend_Session_Namespace('step1Msg');
$sessionMsg->formData = $formData;
$sessionMsg->formErrors = $formErrors;
$sessionMsg->errorMessage = $this->view->errorMessage;
$this->_redirect('company/member/');
}
public function indexAction()
{
$this->view->messages = $this->_flashMessenger->getMessages();
$formData = array();
$formErrors = array();
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
//print_r($formData);exit;
//=====================START FORM VALIDATION===================================
if (!isset($formData['first_name']) || trim($formData['first_name']) == "") {
$formErrors['first_name'] = "Please enter your first name";
}
if (!isset($formData['last_name']) || trim($formData['last_name']) == "") {
$formErrors['last_name'] = "Please enter your last name";
}
if (!isset($formData['user_name']) || trim($formData['user_name']) == "") {
$formErrors['user_name'] = "Please enter user name";
}
if (!isset($formData['user_email']) || trim($formData['user_email']) == "") {
$formErrors['user_email'] = "Please enter your email";
}
if (!isset($formData['user_password']) || trim($formData['user_password']) == "") {
$formErrors['user_password'] = "******";
}
if (!isset($formData['user_password']) || trim($formData['user_password']) == "") {
$formErrors['user_password'] = "******";
}
if (!isset($formData['verify_user_password']) || trim($formData['verify_user_password']) == "") {
$formErrors['verify_user_password'] = "******";
}
if (!isset($formData['agree']) || trim($formData['agree']) == "") {
$formErrors['agree'] = "Please check agree";
}
if ($formData['user_password'] != $formData['verify_user_password']) {
$formErrors['verify_user_password'] = "******";
}
if (!CommonFunctions::isValidEmail($formData['user_email'])) {
if (!array_key_exists('user_email', $formErrors)) {
$formErrors['user_email'] = "Please enter valid email";
}
}
if ($this->modelCandidates->isExist('user_name="' . $formData['user_name'] . '"')) {
if (!array_key_exists('user_name', $formErrors)) {
$formErrors['user_name'] = "Username already exist";
}
}
if ($this->modelCandidates->isExist('user_email="' . $formData['user_email'] . '"')) {
if (!array_key_exists('user_email', $formErrors)) {
$formErrors['user_email'] = "Email already exist";
}
}
//=====================END FORM VALIDATION===================================
if (count($formErrors) == 0) {
//======inserting data to the candidate table===============
$activationCode = CommonFunctions::generateGUID();
$activationStartTime = strtotime(date('Y-m-d H:i:s'));
$activationExpireTime = strtotime(date('Y-m-d H:i:s', strtotime("+1 days")));
//echo "TIME::::".$activationStartTime."====TIME 2:::".strtotime(date('Y-m-d H:i:s'))."===EXPIRE TIME:::".$activationExpireTime;exit;
$candidateData = array('user_name' => $formData['user_name'], 'user_email' => $formData['user_email'], 'user_password' => $formData['user_password'], 'added_date' => date("Y-m-d H:i:s"), 'updated_date' => date("Y-m-d H:i:s"), 'status' => 0, 'activation_code' => $activationCode, 'activation_start_time' => $activationStartTime, 'activation_expire_time' => $activationExpireTime);
$lastId = $this->modelCandidates->insert($candidateData);
if ($lastId) {
//======inserting data to the candidate profile table===============
$agree = isset($formData['agree']) && $formData['agree'] != "" ? 1 : 0;
$signup_newsletter = isset($formData['signup_newsletter']) && $formData['signup_newsletter'] != "" ? 1 : 0;
$notify_jobs = isset($formData['notify_jobs']) && $formData['notify_jobs'] != "" ? 1 : 0;
$profileData = array('user_id' => $lastId, 'first_name' => $formData['first_name'], 'last_name' => $formData['last_name'], 'agree' => $agree, 'signup_newsletter' => $signup_newsletter, 'notify_jobs' => $notify_jobs, 'added_date' => date("Y-m-d H:i:s"), 'updated_date' => date("Y-m-d H:i:s"));
$this->modelCandidateProfiles->insert($profileData);
$sessionPost = new Zend_Session_Namespace('step1Post');
$sessionPost->user_id = $lastId;
$this->_redirect('user/register/step2');
} else {
$this->view->errorMessage = '<div class="div-error">Sorry, unable to register, please try later.</div>';
}
} else {
$this->view->errorMessage = '<div class="div-error">Please enter email required field to register.</div>';
}
}
$this->view->formData = $formData;
$this->view->formErrors = $formErrors;
}
public function step2Action()
{
$this->view->messages = $this->_flashMessenger->getMessages();
$sessionPost = new Zend_Session_Namespace('step1Post');
if (isset($sessionPost) && $sessionPost != null && isset($sessionPost->formData) && count($sessionPost->formData) > 0) {
//print_r($sessionPost->formData);
$step1formData = $sessionPost->formData;
$formData = array();
$formErrors = array();
$formData['business_name'] = $step1formData['business_name'];
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
//print_r($formData);exit;
//=====================START FORM VALIDATION===================================
if (!isset($formData['business_name']) || trim($formData['business_name']) == "") {
$formErrors['business_name'] = "Please enter your business name";
}
//=====================END FORM VALIDATION===================================
if (count($formErrors) == 0) {
//======inserting data to the candidate table===============
$activationCode = CommonFunctions::generateGUID();
$activationStartTime = strtotime(date('Y-m-d H:i:s'));
$activationExpireTime = strtotime(date('Y-m-d H:i:s', strtotime("+1 days")));
//echo "TIME::::".$activationStartTime."====TIME 2:::".strtotime(date('Y-m-d H:i:s'))."===EXPIRE TIME:::".$activationExpireTime;exit;
$compData = array('user_name' => $step1formData['user_name'], 'user_email' => $step1formData['user_email'], 'user_password' => $step1formData['user_password'], 'added_date' => date("Y-m-d H:i:s"), 'updated_date' => date("Y-m-d H:i:s"), 'status' => 1, 'activation_code' => $activationCode, 'activation_start_time' => $activationStartTime, 'activation_expire_time' => $activationExpireTime);
$lastId = $this->modelCompany->insert($compData);
if ($lastId) {
//========unset the session for step1 form data====
Zend_Session::namespaceUnset('step1Post');
//=================================================
//======inserting data to the company profile table===============
$agree = isset($step1formData['agree']) && $step1formData['agree'] != "" ? 1 : 0;
$signup_newsletter = isset($step1formData['signup_newsletter']) && $step1formData['signup_newsletter'] != "" ? 1 : 0;
$notify_jobs = isset($step1formData['notify_jobs']) && $step1formData['notify_jobs'] != "" ? 1 : 0;
$profileData = array('company_id' => $lastId, 'business_name' => $formData['business_name'], 'contact_name' => $step1formData['contact_name'], 'post_code' => $formData['post_code'], 'state' => $formData['state'], 'industry_1' => $formData['industry_1'], 'industry_2' => $formData['industry_2'], 'about_us' => $formData['about_us'], 'opening_hours' => $formData['opening_hours'], 'telephone' => $formData['telephone'], 'website' => $formData['website'], 'abn' => $formData['abn'], 'acn' => $formData['acn'], 'facebook_url' => $formData['facebook_url'], 'twitter_url' => $formData['twitter_url'], 'shifte_url' => $formData['shifte_url'], 'agree' => $agree, 'signup_newsletter' => $signup_newsletter, 'notify_jobs' => $notify_jobs, 'added_date' => date("Y-m-d H:i:s"), 'updated_date' => date("Y-m-d H:i:s"));
$profileId = $this->modelCompanyProfiles->insert($profileData);
if ($profileId > 0) {
/**** Uploading Logo File on Server*****/
$upload = new Zend_File_Transfer_Adapter_Http();
$upload->setDestination(COMPANY_UPLOAD_DIR);
$files = $upload->getFileInfo();
if (isset($files) && count($files) > 0) {
$i = 1;
foreach ($files as $file => $info) {
if ($info['name'] != "") {
if ($upload->isValid($file)) {
try {
// upload received file(s)
$upload->receive($file);
} catch (Zend_File_Transfer_Exception $e) {
//echo $e->getMessage();//exit;
}
// so, Finally lets See the Data that we received on Form Submit
$name = $upload->getFileName($file);
$size = $upload->getFileSize($file);
# Returns the mimetype for the '$file' form element
$mimeType = $upload->getMimeType($file);
$renameFile = time() . $i . '.jpg';
$fullFilePath = COMPANY_UPLOAD_DIR . $renameFile;
//Rename uploaded file using Zend Framework
$filterFileRename = new Zend_Filter_File_Rename(array('target' => $fullFilePath, 'overwrite' => true));
$filterFileRename->filter($name);
$logoData = array('logo' => $renameFile);
$this->modelCompanyProfiles->update($logoData, 'id=' . $profileId);
}
}
$i++;
}
}
/*****End Uploading************/
}
$this->_redirect('company/register/thanks');
} else {
$this->view->errorMessage = '<div class="div-error">Please enter required fieild to register.</div>';
}
} else {
$this->view->errorMessage = '<div class="div-error">Sorry, unable to register, please try later.</div>';
}
}
$this->view->formData = $formData;
$this->view->formErrors = $formErrors;
$this->view->industryList = $this->modelIndustries->fetchAll('status=1');
} else {
$this->_flashMessenger->addMessage('<div class="div-error">Please enter required fieild to register.</div>');
$this->_redirect('company/register/');
}
}
