function activeProfile($unique_id) { $request = Slim::getInstance()->request(); $body = json_decode($request->getBody()); //print_r($body);exit; //$email = $body->email; //$email = isset($user->email)?$user->email:$user->username; //echo $email;exit; //$pass = md5($body->password); $result = ''; if (!empty($unique_id)) { // $db = getConnection(); // $sql = "SELECT * FROM users WHERE unique_code=:unique_code"; // $stmt = $db->prepare($sql); // $stmt->bindParam("unique_code", $unique_id); // $stmt->execute(); // $count = $stmt->rowCount(); // //echo $count;exit; // $user = $stmt->fetchObject(); // $db = null; $user = json_decode(findByCondition(array('unique_code' => $unique_id), 'users')); $count = count($user); if ($count == 0) { $result = '{"type":"error","message":"You are Not Valid User"}'; } elseif ($count == 1) { //$result = json_encode($user); $user = $user['0']; $logged_in = $user->is_logged_in; $id = $user->id; $email = $user->email; //$arr['is_logged_in'] = 1; $arr['is_active'] = 1; $arr['last_login'] = date('Y-m-d h:m:s'); $updateinfo['save_data'] = $arr; // print_r($updateinfo);exit; $update = edit(json_encode($updateinfo), 'users', $id); if (!empty($update)) { //print_r($update);exit; $user->is_active = 1; //$user->is_logged_in=1; $user->last_login = $arr['last_login']; $user_details = json_encode($user); $db = getConnection(); $sql1 = "SELECT * FROM member_user_map WHERE email=:email order by id desc"; $stmt = $db->prepare($sql1); $stmt->bindParam("email", $email); $stmt->execute(); $membercount = $stmt->rowCount(); //echo $count;exit; //$tempvoucher = $stmt->fetchObject(); $allmember = $stmt->fetchAll(PDO::FETCH_OBJ); //print_r($allmember); //exit; $db = null; if ($membercount != 0) { //$arr['is_active'] = 1; $member_offer_id = $allmember[0]->offer_id; $member_voucher_id = $allmember[0]->voucher_id; $member_name = $allmember[0]->name; $first_name = ''; $last_name = ''; if (!empty($member_name)) { $member_name = explode(' ', $member_name); $first_name = $member_name[0]; $last_name = $member_name[1]; if (isset($member_name[2])) { $last_name = $last_name . ' ' . $member_name[2]; } $arr = array(); $arr['first_name'] = $first_name; $arr['last_name'] = $last_name; $updateinfo = array(); $updateinfo['save_data'] = $arr; // print_r($updateinfo);exit; $update = edit(json_encode($updateinfo), 'users', $id); } $member_voucher_query = "SELECT * FROM `voucher_owner` WHERE offer_id={$member_offer_id} and is_active=1 and voucher_id={$member_voucher_id}"; $memberVoucherDetails = findByQuery($member_voucher_query); //print_r($memberVoucherDetails); //exit; if (!empty($memberVoucherDetails)) { $voucher_owner_id = $memberVoucherDetails[0]['id']; $maparr = array(); $maparr['to_user_id'] = $id; $voucherupdateinfo['save_data'] = $maparr; $cndtn = array(); $cndtn['id'] = $voucher_owner_id; $updatemap = editByField(json_encode($voucherupdateinfo), 'voucher_owner', $cndtn); } $maparr = array(); $maparr['user_id'] = $id; $mapupdateinfo['save_data'] = $maparr; $cndtn = array(); $cndtn['email'] = $email; $updatemap = editByField(json_encode($mapupdateinfo), 'member_user_map', $cndtn); } $db = getConnection(); $sql = "SELECT * FROM gift_voucher_non_user WHERE email=:email"; $stmt = $db->prepare($sql); $stmt->bindParam("email", $email); $stmt->execute(); $tempvouchercount = $stmt->rowCount(); //echo $count;exit; //$tempvoucher = $stmt->fetchObject(); $tempvouchers = $stmt->fetchAll(PDO::FETCH_OBJ); $db = null; $expired_vouchers = 0; if ($tempvouchercount != 0) { foreach ($tempvouchers as $tempvoucher) { $date1 = strtotime($tempvoucher->gift_date); $date2 = time(); $interval = floor(($date2 - $date1) / (60 * 60 * 24)); $tempid = $tempvoucher->id; if ($interval < 3) { $to_user = $id; $from_user = $tempvoucher->user_id; $vid = $tempvoucher->voucher_id; //$vid = $tempvoucher->voucher_id; if (!empty($to_user)) { if (!empty($from_user)) { $db = getConnection(); $sql = "SELECT voucher_owner.id, voucher_owner.is_active, vouchers.id as voucher_id, vouchers.offer_id, vouchers.view_id, vouchers.offer_price, vouchers.offer_percent, vouchers.price, users.first_name, users.last_name, users.email FROM vouchers, voucher_owner, users WHERE voucher_owner.voucher_id = vouchers.id and voucher_owner.voucher_id=:vid and voucher_owner.is_active = '1' and voucher_owner.to_user_id=:userid"; $stmt = $db->prepare($sql); $stmt->bindParam("vid", $vid); $stmt->bindParam("userid", $from_user); $stmt->execute(); $voucherowner = $stmt->fetchObject(); if (!empty($voucherowner)) { $ownerid = $voucherowner->id; $offerid = $voucherowner->offer_id; $viewid = $voucherowner->view_id; $offer_price = $voucherowner->offer_price; $offer_percent = $voucherowner->offer_percent; $price = $voucherowner->price; $vid = $voucherowner->voucher_id; $arr = array(); $arr['is_active'] = 0; //$arr['buy_price'] = $buy_price; $arr['sold_date'] = date('Y-m-d h:i:s'); $allinfo['save_data'] = $arr; $old_owner_details = edit(json_encode($allinfo), 'voucher_owner', $ownerid); if ($old_owner_details) { $data = array(); $data['voucher_id'] = $vid; $data['offer_id'] = $offerid; $data['voucher_view_id'] = $viewid; $data['from_user_id'] = $from_user; $data['to_user_id'] = $to_user; $data['price'] = $price; $data['offer_price'] = $offer_price; $data['offer_percent'] = $offer_percent; $data['is_active'] = '1'; $data['buy_price'] = '0.00'; $data['purchased_date'] = date('Y-m-d h:i:s'); $data['transfer_type'] = 'Gift'; $newinfo['save_data'] = $data; $new_owner_details = add(json_encode($newinfo), 'voucher_owner'); if (!empty($new_owner_details)) { $new = json_decode($new_owner_details); $giveData['voucher_id'] = $vid; $giveData['offer_id'] = $offerid; $giveData['from_user_id'] = $from_user; $giveData['to_user_id'] = $to_user; $giveData['created_on'] = date('Y-m-d h:i:s'); $giveData['is_active'] = 1; $newgiveData['save_data'] = $giveData; $new_owner_details = add(json_encode($newgiveData), 'give_voucher'); } } } } } } else { $expired_vouchers++; } $deletetemptable = delete('gift_voucher_non_user', $tempid); } } if (isset($expired_vouchers) && $expired_vouchers > 0) { $result = '{"type":"success","message":"Logged In Succesfully","user_details":' . $user_details . ',"voucher_message":"Your ' . $expired_vouchers . ' Promo has been expired."}'; } else { $result = '{"type":"success","message":"Logged In Succesfully","user_details":' . $user_details . '}'; } } else { $result = '{"type":"error","message":"Error occured"}'; } } // echo $result; } }
function acceptEventBid($event_id, $bid_id) { //echo $bid_id; $temp = array(); $temp['event_id'] = $event_id; editByField(json_encode(array('save_data' => array('is_accepted' => 2))), 'event_bids', $temp); $t = edit(json_encode(array('save_data' => array('is_accepted' => 1))), 'event_bids', $bid_id); edit(json_encode(array('save_data' => array('status' => 'C'))), 'events', $event_id); //var_dump($t); $result = '{"type":"success","message":"Bid accepted successfully"}'; echo $result; }
function success_payment() { $rarray = array(); if (!empty($_POST)) { $data = array(); $data['is_paid'] = 'P'; $payment_id = $_POST['payment_id']; $details = editByField(json_encode(array('save_data' => $data)), 'orders', array('payment_id' => $payment_id)); if ($details) { $sql = "SELECT * FROM orders WHERE payment_id=:payment_id"; $db = getConnection(); $stmt = $db->prepare($sql); $stmt->bindParam("payment_id", $payment_id); $stmt->execute(); $user = $stmt->fetchObject(); $db = null; if ($user) { $userforEmail = findByConditionArray(array('id' => $user->user_id), 'users'); $emailForEmail = $userforEmail[0]['email']; $nameForEmail = $userforEmail[0]['first_name'] . ' ' . $userforEmail[0]['last_name']; $toMain = $emailForEmail; //'*****@*****.**'; $subjectMain = 'Download App Link'; $bodyMain = '<html><body><p>Dear ' . $nameForEmail . ',</p> <p>You can download the app from the link below:<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif"><a href="https://linkmaker.itunes.apple.com/en-us/" target="_blank">Download From Apple Store</a> | <a href="https://play.google.com/store?utm_source=apac_med&utm_medium=hasem&utm_content=Jun2515&utm_campaign=evergreen&pcampaignid=MKT-DR-apac-in-all-med-hasem-py-evergreen-Jun2515-1-en-bkws&gclid=Cj0KEQjwzq63BRCrtIuGjImRoIIBEiQAGLHdYT7z3GaJyAPj3q9T0zqoX5Try5Eh6WEgR8Dvh7EEnMgaAscR8P8HAQ&gclsrc=aw.ds" target="_blank">Download From Google Store</a> </span></p> <p>Thanks,<br /> mFood Team</p> <p> </p></body></html>'; //echo $user->id; $sql = "SELECT * FROM order_details WHERE order_id=:order_id"; $db = getConnection(); $stmt = $db->prepare($sql); $stmt->bindParam("order_id", $user->id); $stmt->execute(); $order_details = $stmt->fetchAll(PDO::FETCH_OBJ); $db = null; foreach ($order_details as $order_detail) { if ($order_detail->typemem == 'App' || $order_detail->typemem == 'Both') { sendMail($toMain, $subjectMain, $bodyMain); } if ($order_detail->event == 0) { $qty = $order_detail->quantity; $offer_details = json_decode(findById($order_detail->offer_id, 'offers')); //print_r($offer_details); $merchant_id = ''; $offer_id = ''; $point_id = ''; $point = ''; $merchant_id = $offer_details->merchant_id; $offer_id = $offer_details->id; $point_id = $offer_details->given_point_master_id; $needed_point_id = $offer_details->point_master_id; $point = $offer_details->mpoints_given; $given_point_details = findByConditionArray(array('id' => $point_id), 'point_master'); $given_point_exipre_date = $given_point_details[0]['expire_date']; if ($order_detail->resell == 0) { for ($i = 0; $i < $qty; $i++) { if ($offer_details->conditions == 0) { $voucher_data = array(); $voucher_data['offer_id'] = $order_detail->offer_id; $voucher_data['created_on'] = date('Y-m-d h:i:s'); $voucher_data['price'] = $offer_details->price; $voucher_data['offer_price'] = $offer_details->offer_price; $voucher_data['offer_percent'] = $offer_details->offer_percent; $voucher_data['from_date'] = $offer_details->offer_from_date; $voucher_data['to_date'] = $offer_details->offer_to_date; if ($offer_details->start_date_type == 'P') { $voucher_data['item_start_date'] = date('Y-m-d'); $voucher_data['item_expire_date'] = date('Y-m-d', strtotime("+" . $offer_details->valid_days . " days")); } else { $voucher_data['item_start_date'] = $offer_details->item_start_date; $voucher_data['item_expire_date'] = $offer_details->item_expire_date; } $voucher_data['item_start_hour'] = $offer_details->item_start_hour; $voucher_data['item_end_hour'] = $offer_details->item_end_hour; $voucher_data['is_active'] = 1; $voucher_data['purchase_type'] = 0; $s = add(json_encode(array('save_data' => $voucher_data)), 'vouchers'); $s = json_decode($s); //print_r($s); exit; $owner_data = array(); $owner_data['offer_id'] = $order_detail->offer_id; $owner_data['voucher_id'] = $s->id; $owner_data['from_user_id'] = 0; $owner_data['to_user_id'] = $order_detail->user_id; $owner_data['purchased_date'] = date('Y-m-d h:i:s'); $owner_data['is_active'] = 1; $owner_data['price'] = $offer_details->price; $owner_data['offer_price'] = $offer_details->offer_price; $owner_data['offer_percent'] = $offer_details->offer_percent; $owner_data['buy_price'] = $offer_details->offer_price; add(json_encode(array('save_data' => $owner_data)), 'voucher_owner'); $point_data = array(); $point_data['offer_id'] = $offer_id; $point_data['points'] = $point; $point_data['source'] = 'earn from promo click'; $point_data['user_id'] = $order_detail->user_id; $point_data['date'] = date('Y-m-d h:i:s'); $point_data['type'] = 'P'; $point_data['remaining_points'] = $point; $point_data['merchant_id'] = $merchant_id; $point_data['point_id'] = $point_id; $point_data['expire_date'] = $given_point_exipre_date; add(json_encode(array('save_data' => $point_data)), 'points'); $point_detail_data = array(); $point_detail_data['offer_id'] = $offer_id; $point_detail_data['points'] = $point; $point_detail_data['source'] = 'earn from promo click'; $point_detail_data['user_id'] = $order_detail->user_id; $point_detail_data['date'] = date('Y-m-d h:i:s'); $point_detail_data['type'] = 'P'; $point_detail_data['remaining_points'] = $point; $point_detail_data['merchant_id'] = $merchant_id; $point_detail_data['point_id'] = $point_id; $point_detail_data['expire_date'] = $given_point_exipre_date; $point_detail_data['transaction_type'] = 0; add(json_encode(array('save_data' => $point_detail_data)), 'point_details'); } } /********* Update Offer *************/ //$up_query = "UPDATE offers SET buy_count=buy_count+".$order_detail->quantity." where id=".$order_detail->offer_id; //updateByQuery($up_query); } elseif ($order_detail->resell == 1) { $resell_id = $order_detail->resell_id; $resellInfo = findByConditionArray(array('id' => $resell_id), 'voucher_resales'); $resell_point_id = $resellInfo[0]['point_id']; $resell_user_id = $resellInfo[0]['user_id']; $resell_price = $resellInfo[0]['price']; $to_user_id = $order_detail->user_id; $resellUserInfo = findByConditionArray(array('id' => $resell_user_id), 'users'); $toUserInfo = findByConditionArray(array('id' => $to_user_id), 'users'); $resell_user_email = $resellUserInfo[0]['email']; $to_user_email = $toUserInfo[0]['email']; $to_user_name = $toUserInfo[0]['first_name'] . ' ' . $toUserInfo[0]['last_name']; $resell_user_name = $resellUserInfo[0]['first_name'] . ' ' . $resellUserInfo[0]['last_name']; $mCashInfo = findByConditionArray(array('name' => 'mCash'), 'point_master'); $money_point = $mCashInfo[0]['money_point']; $point_val = $mCashInfo[0]['value']; $mCashExpireDate = $mCashInfo[0]['expire_date']; $mCashPointId = $mCashInfo[0]['id']; $total_point = round($resell_price / $point_val); $resell_voucher_id = $resellInfo[0]['voucher_id']; $voucherDetail = findByConditionArray(array('id' => $resell_voucher_id), 'vouchers'); $resellbidInfo = findByConditionArray(array('voucher_id' => $resell_voucher_id, 'user_id' => $to_user_id), 'voucher_bids'); if (empty($resellbidInfo)) { $resellownerInfo = findByConditionArray(array('voucher_id' => $resell_voucher_id, 'is_active' => 1), 'voucher_owner'); $voucher_owner_id = $resellownerInfo[0]['id']; $save_data = array(); $save_data['save_data']['voucher_status'] = 0; $voucher_edit = edit(json_encode($save_data), 'vouchers', $resell_voucher_id); $save_data = array(); $save_data['save_data']['resell_type'] = 2; $save_data['save_data']['is_active'] = 0; $voucher_owner_edit = edit(json_encode($save_data), 'voucher_owner', $voucher_owner_id); $save_data = array(); $save_data['save_data']['ispayment'] = 0; $save_data['save_data']['is_sold'] = '1'; $save_data['save_data']['sold_on'] = date('Y-m-d h:i:s'); $save_data['save_data']['accept_date'] = date('Y-m-d h:i:s'); $voucher_owner_edit = edit(json_encode($save_data), 'voucher_resales', $resell_id); $data = array(); $data['voucher_id'] = $resell_voucher_id; $data['offer_id'] = $voucherDetail[0]['offer_id']; $data['voucher_view_id'] = $voucherDetail[0]['view_id']; $data['from_user_id'] = $resell_user_id; $data['to_user_id'] = $to_user_id; $data['price'] = $voucherDetail[0]['price']; $data['offer_price'] = $voucherDetail[0]['offer_price']; $data['offer_percent'] = $voucherDetail[0]['offer_percent']; $data['is_active'] = '1'; $data['buy_price'] = $resell_price; $data['purchased_date'] = date('Y-m-d h:i:s'); $data['resell_type'] = 0; $data['owner_id'] = $voucher_owner_id; $newinfo['save_data'] = $data; $new_owner_details = add(json_encode($newinfo), 'voucher_owner'); } else { $resellownerInfo = findByConditionArray(array('voucher_id' => $resell_voucher_id, 'is_active' => 1), 'voucher_owner'); $voucher_owner_id = $resellownerInfo[0]['id']; $save_data = array(); $save_data['save_data']['voucher_status'] = 0; $voucher_edit = edit(json_encode($save_data), 'vouchers', $resell_voucher_id); $save_data = array(); $save_data['save_data']['resell_type'] = 0; $voucher_owner_edit = edit(json_encode($save_data), 'voucher_owner', $voucher_owner_id); $save_data = array(); $save_data['save_data']['ispayment'] = 0; $voucher_owner_edit = edit(json_encode($save_data), 'voucher_resales', $resell_id); } //$resellPointInfo = findByConditionArray(array('id' => $resell_point_id),'point_master'); if ($money_point == 1) { $point_detail_data = array(); $point_detail_data['offer_id'] = 0; $point_detail_data['points'] = $total_point; $point_detail_data['source'] = 'earn from promo click'; $point_detail_data['user_id'] = $resell_user_id; $point_detail_data['date'] = date('Y-m-d h:i:s'); $point_detail_data['type'] = 'P'; $point_detail_data['remaining_points'] = $total_point; $point_detail_data['merchant_id'] = 0; $point_detail_data['point_id'] = $mCashPointId; $point_detail_data['expire_date'] = $mCashExpireDate; $point_detail_data['transaction_type'] = 0; add(json_encode(array('save_data' => $point_detail_data)), 'point_details'); } $from = ADMINEMAIL; //$to = $saveresales->email; $to = $to_user_email; //'*****@*****.**'; $sviewid = 'MFG-000000000' . $voucherDetail[0]['id']; $sstartdate = date('d M, Y', strtotime($voucherDetail[0]['item_start_date'])); $senddate = date('d M, Y', strtotime($voucherDetail[0]['item_expire_date'])); $sprice = $voucherDetail[0]['price']; $resaleprice = $resell_price; $svname = $offer_details->title; $subject = 'Payment successfully'; $body = '<html><body><p>Dear ' . $to_user_name . ',</p> <p>You have successfully made payment for resell voucher<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher Id :</span>' . $sviewid . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher Name :</span>' . $svname . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher Start Date :</span>' . $sstartdate . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher End Date :</span>' . $senddate . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher price :</span>' . $sprice . '<br /><br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Sell price :</span>' . $resaleprice . '<br /><br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">If we can help you with anything in the meantime just let us know by e-mailing </span>' . $from . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif"></span><span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">! </span></p> <p>Thanks,<br /> mFood Team</p> <p> </p></body></html>'; sendMail($to, $subject, $body); $from = ADMINEMAIL; //$to = $saveresales->email; $to1 = $resell_user_email; //'*****@*****.**'; $subject1 = $to_user_name . ' has successfully made payment for your voucher'; $body1 = '<html><body><p>Dear ' . $resell_user_name . ',</p> <p> You have successfully sold voucher to ' . $to_user_name . '.<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher Id :</span>' . $sviewid . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher Name :</span>' . $svname . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher Start Date :</span>' . $sstartdate . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher End Date :</span>' . $senddate . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Voucher price :</span>' . $sprice . '<br /><br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">Sell price :</span>' . $resaleprice . '<br /><br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">If we can help you with anything in the meantime just let us know by e-mailing </span>' . $from . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif"></span><span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">! </span></p> <p>Thanks,<br /> mFood Team</p> <p> </p></body></html>'; sendMail($to1, $subject1, $body1); } } else { $event_id = $order_detail->event_id; $bid_id = $order_detail->event_bid_id; $temp = array(); $temp['event_id'] = $event_id; editByField(json_encode(array('save_data' => array('is_accepted' => 2))), 'event_bids', $temp); $t = edit(json_encode(array('save_data' => array('is_accepted' => 1))), 'event_bids', $bid_id); edit(json_encode(array('save_data' => array('status' => 'C'))), 'events', $event_id); $bidInfo = findByConditionArray(array('id' => $bid_id), 'event_bids'); $bid_user_id = $bidInfo[0]['user_id']; $from_user_id = $order_detail->user_id; $bidUserInfo = findByConditionArray(array('id' => $bid_user_id), 'users'); $fromUserInfo = findByConditionArray(array('id' => $from_user_id), 'users'); $bid_user_email = $bidUserInfo[0]['email']; $from_user_email = $fromUserInfo[0]['email']; $from_user_name = $fromUserInfo[0]['first_name'] . ' ' . $fromUserInfo[0]['last_name']; $bid_user_name = $bidUserInfo[0]['first_name'] . ' ' . $bidUserInfo[0]['last_name']; $from = ADMINEMAIL; //$to = $saveresales->email; $to1 = $bid_user_email; //$to1 = '*****@*****.**'; $subject1 = $from_user_name . ' accept the event that you have bidded and successfully made payment for the event'; $body1 = '<html><body><p>Dear ' . $bid_user_name . ',</p> <p> ' . $from_user_name . ' accept the event that you have bidded and successfully made payment for the event<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">If we can help you with anything in the meantime just let us know by e-mailing </span>' . $from . '<br /> <span style="color:rgb(34, 34, 34); font-family:arial,sans-serif"></span><span style="color:rgb(34, 34, 34); font-family:arial,sans-serif">! </span></p> <p>Thanks,<br /> mFood Team</p> <p> </p></body></html>'; sendMail($to1, $subject1, $body1); } } // $orders = getlist('order_details',array('order_id' => $user->id)); //print_r($orders); } //print_r($user); //exit; } $rarray = array('type' => 'success'); } else { $rarray = array('type' => 'error'); } echo json_encode($rarray); exit; }