public function delete()
{
$post = $this->input->post();
if ($post) {
$ids = array_filter(explode(",", $post['id']));
foreach ($ids as $id) {
$cladArr = $imgArr = $this->common_model->selectData(CLASSIFIEDAD, '*', array("clad_id" => $id));
//pr($imgArr,9);
if (!empty($imgArr)) {
$imglist = $imgArr[0]->clad_image;
if ($imglist != '') {
$imgArr = array_filter(explode(',', $imglist));
foreach ($imgArr as $k => $v) {
removeAdImgs($v);
/*if(file_exists(DOC_ROOT_CLASSIFIED_AD.$v))
unlink(DOC_ROOT_CLASSIFIED_AD.$v);*/
}
}
}
$uData = $this->common_model->selectData(USER, '*', array("u_id" => $cladArr[0]->clad_uid));
//pr($uData,9);
//$ret = $this->common_model->deleteData(CLASSIFIEDAD, array('clad_id' => $id ));
$curDate = date('Y-m-d H:i:s');
$where = 'clad_id = ' . $id;
$param = array('clad_active' => 0, 'is_deleted' => 1, 'clad_image' => '', 'clad_modified_date' => $curDate);
$ret = $this->common_model->updateData(CLASSIFIEDAD, $param, $where);
if ($ret > 0) {
## send mail n sms to owner
$uName = $uData[0]->u_fname ? $uData[0]->u_fname : '';
$uEmail = $uData[0]->u_email ? $uData[0]->u_email : '';
if ($uEmail != '') {
$emailTpl = $this->load->view('email_templates/addeletenotification', array('name' => $uName, 'adtitle' => $cladArr[0]->clad_title, 'adid' => $post['id']), true);
$retemail = sendEmail($uEmail, SUBJECT_ADDELETE_INFO, $emailTpl, FROM_EMAIL, FROM_NAME);
}
## Send sms to seller
$phonemsg = AD_DELETE_NOTIFICATION;
## take msg content from constant
$phonemsg = str_replace('{name}', $cnt, $phonemsg);
$phonemsg = str_replace('{clad_id}', "#" . $post['id'], $phonemsg);
$phonemsg = str_replace('{clad_title}', $cladArr[0]->clad_title, $phonemsg);
$response = connectMobile($phonemsg, $uData[0]->u_mobile);
$res = json_decode($response->raw_body, true);
}
}
if ($ret > 0) {
echo "success";
} else {
echo "error";
}
}
}
public function deleteAd($clad_id)
{
//$ret = $this->common_model->deleteData(CLASSIFIEDAD, array('clad_id' => $clad_id ));
$curDate = date('Y-m-d H:i:s');
$where = 'clad_id = ' . $clad_id;
$param = array('clad_active' => 0, 'is_deleted' => 1, 'clad_image' => '', 'clad_modified_date' => $curDate);
$update = $this->common_model->updateData(CLASSIFIEDAD, $param, $where);
$flsmsg = 'Your Ad has been removed successfuly';
if ($update) {
$cladArr = $imgArr = $this->common_model->selectData(CLASSIFIEDAD, '*', array("clad_id" => $clad_id));
//pr($imgArr,9);
if (!empty($imgArr)) {
$imglist = $imgArr[0]->clad_image;
if ($imglist != '') {
$imgArr = explode(',', $imglist);
foreach ($imgArr as $k => $v) {
if (file_exists(DOC_ROOT_CLASSIFIED_AD . $v)) {
unlink(DOC_ROOT_CLASSIFIED_AD . $v);
}
}
}
}
## Send sms to customer of ad
$phonemsg = AD_DELETE_NOTIFICATION;
## take msg content from constant
$phonemsg = str_replace('{clad_id}', "#" . $clad_id, $phonemsg);
$response = connectMobile($phonemsg, $this->user_session['mobile']);
$res = json_decode($response->raw_body, true);
$flash_arr = array('flash_type' => 'success', 'flash_msg' => $flsmsg);
} else {
$flash_arr = array('flash_type' => 'error', 'flash_msg' => 'Error Occured during processing..Please try again later.');
}
$this->session->set_flashdata($flash_arr);
redirect("myaccount/my-ad-list");
}
public function deletead($data)
{
if (isset($data['user']) && isset($data['adid'])) {
if ($data['user'] != '' && $data['adid'] != '') {
$ret = $this->common_model->selectData(CLASSIFIEDAD, '*', array('clad_uid' => $data['user'], 'clad_id' => $data['adid']));
if (count($ret) == 0) {
$result['status'] = "204";
$result['message'] = "User is not permitted to delete this ad";
$result['data'] = $result;
} else {
$curDate = date('Y-m-d H:i:s');
$where = "clad_id =" . $data['adid'];
#$update = $this->common_model->deleteData(CLASSIFIEDAD, $where);
$update = $this->common_model->updateData(CLASSIFIEDAD, array('is_deleted' => '1', 'clad_active' => '0', 'clad_image' => '', 'clad_modified_date' => $curDate), $where);
## remove all image of ad
if (!empty($ret)) {
$imglist = $ret[0]->clad_image;
if ($imglist != '') {
$imgArr = explode(',', $imglist);
foreach ($imgArr as $k => $v) {
if (file_exists(DOC_ROOT_CLASSIFIED_AD . $v)) {
unlink(DOC_ROOT_CLASSIFIED_AD . $v);
}
}
}
}
## Send sms to customer of ad
$res = $this->common_model->selectData(USER, '*', array('u_id' => $ret[0]->clad_uid));
$phonemsg = AD_DELETE_NOTIFICATION;
## take msg content from constant
$phonemsg = str_replace('{clad_id}', "#" . $data['adid'], $phonemsg);
$response = connectMobile($phonemsg, $res[0]->u_mobile);
$res = json_decode($response->raw_body, true);
$result['status'] = "200";
$result['message'] = "Request successfuly completed";
$result['data'] = $result;
}
} else {
$result['status'] = "204";
$result['message'] = "Please enter valid data";
$result['data'] = $result;
}
} else {
$result['status'] = "204";
$result['message'] = "Please enter valid data";
$result['data'] = $result;
}
return $result;
}
function sendSMS($phoneNumber)
{
$password = mt_rand(10000, 99999);
#$password="******";
$message = "Thanks to use Gujjubazar.Your Mobile No:{$phoneNumber}. Your Password : {$password} Use this number as your password in login.";
$response = connectMobile($message, $phoneNumber);
$res = json_decode($response->raw_body, true);
if ($res['response']['status'] == 'success') {
return array('status' => 'success', 'password' => $password);
} else {
return array('status' => 'error', 'password' => $password);
}
}
public function autoActiveAd()
{
$curDate = date('Y-m-d H:i:s');
$this->db->select('ad.*,u.*');
$this->db->from(CLASSIFIEDAD_AD);
$this->db->join(USER_U, "ad.clad_uid = u.u_id");
$where = 'ad.clad_created_date < "' . date('Y-m-d H:i:s', strtotime('-30 minutes')) . '" AND ad.clad_active=2 AND u.u_active = 1 AND u.u_canpost=1 AND u.u_is_verified=1 AND ad.is_deleted=0';
$this->db->where($where);
$query = $this->db->get();
$result = $query->result();
//echo "<pre>"; print_r($this->db->queries);pr($result,9);exit;
if (!empty($result)) {
foreach ($result as $k => $v) {
$where = 'clad_id = ' . $v->clad_id;
$ret = $this->common_model->updateData(CLASSIFIEDAD, array('clad_active' => 1, 'clad_modified_date' => $curDate), $where);
if ($ret) {
if ($v->u_email != '') {
$Arr = array();
$Arr['name'] = $v->u_fname;
$Arr['ad_title'] = $v->clad_title;
$Arr['siteurl'] = "http://" . $_SERVER['HTTP_HOST'];
$Arr['adUrl'] = createUrl("detail", array($v->clad_id, $v->clad_title));
$Arr['clad_id'] = $v->clad_id;
$Arr['baseurl'] = base_url();
$emailTpl = $this->load->view('email_templates/adLiveSuccessfully', $Arr, true);
//pr($emailTpl,8);
$ret = sendEmail($v->u_email, SUBJECT_NEWADLIVE_USER_NOTIFICATION, $emailTpl, FROM_EMAIL, FROM_NAME);
}
## Send sms to customer who post ad
$phonemsg = AD_APPROVAL_NOTIFICATION;
## take msg content from constant
$phonemsg = str_replace('{clad_id}', "#" . $v->clad_id, $phonemsg);
$response = connectMobile($phonemsg, $v->u_mobile);
$res = json_decode($response->raw_body, true);
}
}
}
}
public function messageToSeller()
{
//pr($_POST);die;
if (isset($_POST['message']) && $_POST['message'] != '') {
//$cnt = urldecode($_POST['contact']);
$message = urldecode($_POST['message']);
$dataArr = array();
$dataArr['message'] = $message;
//$dataArr['buyer_contact'] = $cnt;
$this->load->helper('email');
## send mail / msg to seller regarding msg notification on his/her Ad
$res = $this->common_model->selectData(USER, 'u_fname,u_lname,u_email,u_mobile', array("u_id" => $_POST['clad_uid']));
$sellerEmail = @$res[0]->u_email;
$cnt = $phoneNumber = @$res[0]->u_mobile;
$dataArr['name'] = $res[0]->u_fname . ' ' . $res[0]->u_lname;
//$dataArr['siteurl'] = "http://" . $_SERVER['HTTP_HOST'];
/* * * User notification ** */
$macids = array();
$macid = $this->common_model->getMacids(trim($_POST['clad_uid']));
foreach ($macid as $val) {
$macids[] = $val->macid;
}
## get ad title
$adDetail = $this->common_model->selectData(CLASSIFIEDAD, '*', array("clad_id" => $_POST['clad_id']));
$pushMsg = "You have new message on Ad " . $adDetail[0]->clad_title . " - " . trim($message);
$msg = array('message' => $pushMsg, 'title' => 'Gujjubazar', 'subtitle' => 'No. 1 Classified site', 'type' => 'message', 'msgcnt' => 3, 'vibrate' => 1, 'sound' => 1);
if (count($macids) != 0) {
sendNotification($macids, $msg);
}
if ($sellerEmail != '') {
## send mail to seller if seller's mail id available
// $adDetail = $this->common_model->selectData(CLASSIFIEDAD, '*', array('clad_id' => $_POST['clad_id']));
$dataArr['adtitle'] = $adDetail[0]->clad_title;
$dataArr['adid'] = $_POST['clad_id'];
$emailTpl = $this->load->view('email_templates/sellerContactMail', $dataArr, true);
$ret = sendEmail($sellerEmail, SUBJECT_SELLER_NOTIFICATION, $emailTpl, FROM_EMAIL, FROM_NAME);
if (!$ret) {
$sendM = "Error occured during contacting seller.Please try after sometime";
} else {
$sendM = "Your Message has been send to seller.";
}
}
## Send sms to seller
$phonemsg = SELLER_MSG_NOTIFICATION;
## take msg content from constant
$phonemsg = str_replace('{name}', $cnt, $phonemsg);
$phonemsg = str_replace('{clad_id}', "#" . $_POST['clad_id'], $phonemsg);
$response = connectMobile($phonemsg, $phoneNumber);
$res = json_decode($response->raw_body, true);
## save into db
$uid = $this->user_session['uid'];
if (isset($uid) && $uid != '') {
$data = array('clad_id' => trim($_POST['clad_id']), 'ad_msg_from' => $uid, 'ad_msg_to' => trim($_POST['clad_uid']), 'ad_message' => trim($message), 'ad_msg_read_flag' => 0);
$insVal = $this->common_model->insertData(MESSAGE, $data);
} else {
$data = array('ad_reply_user_contact' => trim($cnt), 'ad_reply_user_message' => trim($message), 'clad_id' => trim($_POST['clad_id']), 'ad_reply_created_date' => date('Y-m-d H:i:s'), 'ad_reply_modified_date' => date('Y-m-d H:i:s'), 'ad_reply_status' => 0);
$insVal = $this->common_model->insertData(ADREPLY, $data);
}
## process to update cache json for this new msg by read cache .. process index .. and write cache
if ($insVal) {
$sendM = "Your Message has been send to seller.";
} else {
$sendM = "Error occured during contacting seller.Please try after sometime";
}
$this->manageCache($_POST['clad_id']);
echo $sendM;
return;
} else {
echo 'Error occured during processing..Please try again.';
return;
}
}
