query("insert into $tbl_order_comments set comments='$comments',order_status='$order_status',payment_status='$payment_status',pay_amount='$pay_amount',pay_via='$pay_via',transaction_id='$transaction_id',card_number='$card_number',pay_date='$pay_date',order_id='$order_id',posted_date=now()"); $obj->query("update $tbl_order set order_status='$order_status',payment_status='$payment_status' where id='$order_id' "); ################################ Reward Point Management ################################## $oArr = $obj->query("select user_id,total_amount,payment_status, coupon_code from $tbl_order where id='$order_id' "); $resultOrder = $obj->fetchNextObject($oArr); $user_id = $resultOrder->user_id; $total_amount = $resultOrder->total_amount; $setting_reward = getField('rewardamount', $tbl_setting, 1); $reward_point = floor($total_amount / $setting_reward); if ($_REQUEST['payment_status'] == 1) { $ordArr = $obj->query("select id from $tbl_reward_history where order_id='$order_id' and type='Cr' "); if ($obj->numRows($ordArr) == 0) { $obj->query("insert into $tbl_reward_history set order_id='$order_id',user_id='$user_id',reward_point='$reward_point',type='Cr',added_date=now(),status=1 "); } } if ($resultOrder->payment_status == 1) { if ($_REQUEST['payment_status'] == 0) { $ordArr = $obj->query("select id from $tbl_reward_history where order_id='$order_id' and type='Dr' "); if ($obj->numRows($ordArr) == 0) { $obj->query("insert into $tbl_reward_history set order_id='$order_id',user_id='$user_id',reward_point='$reward_point',type='Dr',added_date=now(),status=1 "); } } } } ################################ Reward Point Management End################################## $_SESSION['sess_msg'] = "Comment posted successfully.!"; } ?> query("select * from $tbl_order_comments where order_id in (" . $_REQUEST['order_id'] . ") order by id desc "); if ($obj->numRows($commentArr) > 0) { ?>

Admin: Add Comment On Order ID :

Current Status Select Status query("select * from $tbl_order_status where status=1 "); $current_status = getField('order_status', $tbl_order, $_REQUEST['order_id']); while ($resultStatus = $obj->fetchNextObject($statusArr)) { ?> id == $current_status) { ?>selected>order_status); ?> Payment Status Select selected>Successfull selected>Unsuccessfull Comment

fetchNextObject($commentArr)) { ?> Order Id Date Pay Via Received Amount Received Date Comment order_id); ?> posted_date)); ?> pay_via == 'Credit/Debit Card') { if ($resultComment->transaction_id != '') { echo 'Transaction ID:#' . $resultComment->transaction_id . " "; } if ($resultComment->card_number != '') { echo 'Crad Last digits:' . $resultComment->card_number . " "; } ?> Cash pay_amount != 0) { echo 'Rs. ' . stripslashes($resultComment->pay_amount); } ?> posted_date != '0000-00-00') { echo stripslashes($resultComment->posted_date); } ?> comments); ?>

coupon_code != '') { // insert refer a friend reward point if ($_REQUEST['order_status'] == 3 && $_REQUEST['payment_status'] == 1) { $referarr = $obj->query("select ref_user_id,hero from tbl_coupon where coupon_code='$resultOrder->coupon_code' and status=1"); $resultrefer = $obj->fetchNextObject($referarr); if ($resultrefer->ref_user_id != '' && $resultrefer->hero == '') { $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='500', type='Cr', added_date='now()', status='1'"); } // insert be a hero reward point if ($resultrefer->ref_user_id != '' && $resultrefer->hero == '0') { $start_date = date('Y-m-01', strtotime(date('Y-m-d'))); $last_date = date('Y-m-t', strtotime(date('Y-m-d'))); $cArr = $obj->query("select count(*) as ordered from $tbl_order where coupon_code='$resultOrder->coupon_code' and order_date>'$start_date' and order_date<'$last_date'"); $os = $obj->fetchNextObject($cArr); if ($os == 5) { $rewardearned = 5000; $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='$rewardearned', type='Cr', added_date='now()', status='1'"); } if ($os == 10) { $rewardearned = 5000; $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='$rewardearned', type='Cr', added_date='now()', status='1'"); } if ($os == 15) { $rewardearned = 5000; $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='$rewardearned', type='Cr', added_date='now()', status='1'"); } } } } ?>