/**
  * Add feedback
  *
  * @param mixed $writerID
  * @param mixed $score
  * @param mixed $feedback
  * @param mixed $activityID
  * @param mixed $activityType
  * @return int|null|string|void
  */
 public function addFeedback($writerID, $score, $feedback, $activityID, $activityType = BuckysFeedback::ACTIVITY_TYPE_TRADE)
 {
     global $db;
     if (!is_numeric($activityID) || !is_numeric($writerID) || !is_numeric($score) || $feedback == '') {
         return;
     }
     // failed
     //If you left feedback already, then return
     if ($this->hasFeedback($writerID, $activityID, $activityType)) {
         return;
     }
     //exists
     $param = ['activityID' => $activityID, 'activityType' => $activityType, 'writerID' => $writerID, 'score' => $score, 'comment' => $feedback, 'createdDate' => date('Y-m-d H:i:s')];
     $otherUserID = null;
     switch ($activityType) {
         case BuckysFeedback::ACTIVITY_TYPE_TRADE:
             $tradeIns = new BuckysTrade();
             $tradeData = $tradeIns->getTradeByID($activityID);
             if (!$tradeData) {
                 return;
             }
             //no such trade
             if ($tradeData['sellerID'] == $writerID) {
                 $otherUserID = $param['receiverID'] = $tradeData['buyerID'];
                 $param['itemID'] = $tradeData['buyerItemID'];
             } else {
                 if ($tradeData['buyerID'] == $writerID) {
                     $otherUserID = $param['receiverID'] = $tradeData['sellerID'];
                     $param['itemID'] = $tradeData['sellerItemID'];
                 } else {
                     return;
                     //no rights
                 }
             }
             break;
         case BuckysFeedback::ACTIVITY_TYPE_SHOP:
             $shopOrderIns = new BuckysShopOrder();
             $orderData = $shopOrderIns->getOrderByID($activityID);
             if (!$orderData || $orderData['buyerID'] != $writerID) {
                 return;
             }
             //no such trade
             $otherUserID = $param['receiverID'] = $orderData['sellerID'];
             $param['itemID'] = $orderData['productID'];
             break;
         default:
             return;
             //no such cases
             break;
     }
     $newID = $db->insertFromArray(TABLE_FEEDBACK, $param);
     if ($newID && $otherUserID) {
         //Update TradeUser Table for rating calculation
         $this->_updateRanking($otherUserID);
     }
     //Create notification
     $tradeNotificationIns = new BuckysTradeNotification();
     $tradeNotificationIns->createNotification($otherUserID, $writerID, BuckysTradeNotification::ACTION_TYPE_FEEDBACK, $newID);
     return $newID;
 }
 /**
  * Add feedback
  *
  * @param integer $tradeID
  * @param integer $userID
  * @param integer $score : one of this two value, 1 & -1
  * @param string  $feedback
  * @return int
  */
 public function addFeedback($tradeID, $userID, $score, $feedback)
 {
     global $db;
     if (!is_numeric($tradeID) || !is_numeric($userID) || !is_numeric($score) || $feedback == '') {
         return;
     }
     // failed
     if ($this->getFeedbackByTradeID($tradeID)) {
         return;
     }
     //exists
     //Add
     $tradeIns = new BuckysTrade();
     $tradeData = $tradeIns->getTradeByID($tradeID);
     $otherUserID = null;
     if (!$tradeData) {
         return;
     }
     //no such trade
     if ($tradeData['sellerID'] == $userID) {
         $param = ['tradeID' => $tradeID, 'sellerID' => $tradeData['sellerID'], 'buyerID' => $tradeData['buyerID'], 'sellerToBuyerScore' => $score, 'sellerToBuyerFeedback' => $feedback, 'sellerToBuyerFeedbackCreatedAt' => date('Y-m-d H:i:s')];
         $otherUserID = $tradeData['buyerID'];
     } else {
         if ($tradeData['buyerID'] == $userID) {
             $param = ['tradeID' => $tradeID, 'sellerID' => $tradeData['sellerID'], 'buyerID' => $tradeData['buyerID'], 'buyerToSellerScore' => $score, 'buyerToSellerFeedback' => $feedback, 'buyerToSellerFeedbackCreatedAt' => date('Y-m-d H:i:s')];
             $otherUserID = $tradeData['sellerID'];
         } else {
             return;
             //no rights
         }
     }
     $newID = $db->insertFromArray(TABLE_TRADE_FEEDBACK, $param);
     if ($newID && $otherUserID) {
         //Update TradeUser Table for rating calculation
         $this->_updateRanking($otherUserID);
     }
     //Create notification
     $tradeNotificationIns = new BuckysTradeNotification();
     $tradeNotificationIns->createNotification($otherUserID, $userID, BuckysTradeNotification::ACTION_TYPE_FEEDBACK, $newID);
     return $newID;
 }
 /**
  * Update shipping Info
  * It has 2 logic in it. Update your own shipping info, and update already created trade records which has no shipping info.
  * 
  * @param integer $userID
  * @param array $data
  */
 public function updateShippingInfo($userID, $data)
 {
     if (!is_numeric($userID) || $data['shippingAddress'] == '' || $data['shippingCity'] == '' || $data['shippingState'] == '' || $data['shippingZip'] == '' || $data['shippingCountryID'] == '' || !is_numeric($data['shippingCountryID'])) {
         return false;
     }
     //Update my shipping info
     global $db;
     $query = sprintf('UPDATE %s SET ', TABLE_TRADE_USERS);
     $query = $db->prepare($query . 'shippingAddress=%s, shippingCity=%s, shippingState=%s, shippingZip=%s, shippingCountryID=%d WHERE userID=' . $userID, $data['shippingAddress'], $data['shippingCity'], $data['shippingState'], $data['shippingZip'], $data['shippingCountryID']);
     $db->query($query);
     //Update trade table which has no shipping info with this info.
     //It will check trade table, and create records in trade_shipping_info
     $tradeIns = new BuckysTrade();
     $tradeShippingInfoIns = new BuckysTradeShippingInfo();
     //---------------- Update for seller ----------------------//
     $requiredList = $tradeIns->getShippingInfoRequiredTrade($userID, 'seller');
     if (!empty($requiredList) && count($requiredList) > 0) {
         foreach ($requiredList as $tradeData) {
             //Add shipping info
             $shippingRecID = $tradeShippingInfoIns->addTradeShippingInfo($userID);
             if (!empty($shippingRecID) && is_numeric($shippingRecID)) {
                 //update trade table
                 $tradeIns->updateTrade($tradeData['tradeID'], array('sellerShippingID' => $shippingRecID));
             }
         }
     }
     //---------------- Update for buyer ----------------------//
     $requiredList = $tradeIns->getShippingInfoRequiredTrade($userID, 'buyer');
     if (!empty($requiredList) && count($requiredList) > 0) {
         foreach ($requiredList as $tradeData) {
             //Add shipping info
             $shippingRecID = $tradeShippingInfoIns->addTradeShippingInfo($userID);
             if (!empty($shippingRecID) && is_numeric($shippingRecID)) {
                 //update trade table
                 $tradeIns->updateTrade($tradeData['tradeID'], array('buyerShippingID' => $shippingRecID));
             }
         }
     }
     return true;
 }
/**
 * Save Tracking number
 */
function saveTrackingNumber()
{
    $userID = buckys_is_logged_in();
    if (!$userID) {
        //You should be logged in
        return;
    } else {
        $tradeIns = new BuckysTrade();
        $tradeID = buckys_escape_query_integer($_REQUEST['tradeID']);
        $trackingNo = buckys_escape_query_string($_REQUEST['trackingNo']);
        $tradeData = $tradeIns->getTradeByID($tradeID);
        if (empty($tradeData) || $tradeData['sellerID'] != $userID && $tradeData['buyerID'] != $userID) {
            //error, no permission
            echo json_encode(['success' => 0, 'msg' => "You do not have permission."]);
        } else {
            if ($tradeData['sellerID'] == $userID) {
                $tradeIns->updateTrade($tradeID, ['sellerTrackingNo' => $trackingNo]);
            } else {
                $tradeIns->updateTrade($tradeID, ['buyerTrackingNo' => $trackingNo]);
            }
            echo json_encode(['success' => 1, 'msg' => "You have saved tracking number successfully."]);
        }
    }
}
示例#5
0
}
buckys_enqueue_stylesheet('trade.css');
buckys_enqueue_javascript('trade.js');
$BUCKYS_GLOBALS['content'] = 'trade/traded';
$BUCKYS_GLOBALS['headerType'] = 'trade';
$paramCurrentPage = get_secure_integer($_REQUEST['page']);
$paramType = get_secure_string($_REQUEST['type']);
$view = array();
$baseURL = '/trade/traded.php';
if ($paramType == 'history') {
    $baseURL .= '?type=' . $paramType;
} else {
    $paramType = 'completed';
}
//Get offer_received info
$tradeIns = new BuckysTrade();
$countryIns = new BuckysCountry();
$view['trades'] = $tradeIns->getTradesByUserID($userID, $paramType);
$view['trades'] = buckys_trade_pagination($view['trades'], $baseURL, $paramCurrentPage, TRADE_ROWS_PER_PAGE);
$view['myID'] = $userID;
switch ($paramType) {
    case 'history':
        $view['pagetitle'] = 'Trade History';
        break;
    case 'completed':
    default:
        $view['pagetitle'] = 'Completed Trades';
        //Mark the activity (offer received) as read
        $tradeNotificationIns = new BuckysTradeNotification();
        $tradeNotificationIns->markAsRead($userID, BuckysTradeNotification::ACTION_TYPE_OFFER_ACCEPTED);
        break;
 /**
  * Accept offer
  *
  * @param integer $offerID
  * @return bool|int
  */
 public function acceptOffer($offerID)
 {
     if (!is_numeric($offerID)) {
         return false;
     }
     //Get related info for this offer
     $tradeItemIns = new BuckysTradeItem();
     $offerInfo = $this->getOfferByID($offerID);
     if (empty($offerInfo)) {
         return false;
     }
     $sellerData = $tradeItemIns->getItemById($offerInfo['targetItemID']);
     $buyerData = $tradeItemIns->getItemById($offerInfo['offeredItemID']);
     if (empty($buyerData) || empty($sellerData)) {
         return false;
     }
     $offerInfo['sellerID'] = $sellerData['userID'];
     $offerInfo['buyerID'] = $buyerData['userID'];
     //Add trade
     $tradeIns = new BuckysTrade();
     $newTradeID = $tradeIns->addTrade($offerInfo['sellerID'], $offerInfo['buyerID'], $offerInfo['targetItemID'], $offerInfo['offeredItemID']);
     //Change trade Item status to "traded"
     $tradeItemIns->updateItem($offerInfo['targetItemID'], ['status' => BuckysTradeItem::STATUS_ITEM_TRADED]);
     $tradeItemIns->updateItem($offerInfo['offeredItemID'], ['status' => BuckysTradeItem::STATUS_ITEM_TRADED]);
     //Remove all offered made by these 2 items
     $this->deleteOffersByItemID($offerInfo['targetItemID']);
     $this->deleteOffersByItemID($offerInfo['offeredItemID']);
     //After processing accept (creating record in trade table), then you should remove the offer record from the table
     //$this->deleteOffer($offerID); // Meaningless code since it should be deleted by deleteOffersByItemID (2 commands above this)
     //Create notification
     $tradeNotificationIns = new BuckysTradeNotification();
     $tradeNotificationIns->createNotification($offerInfo['buyerID'], $offerInfo['sellerID'], BuckysTradeNotification::ACTION_TYPE_OFFER_ACCEPTED, $newTradeID);
     return $newTradeID;
 }
 /**
  * Update shipping Info
  * It has 2 logic in it. Update your own shipping info, and update already created trade records which has no shipping info.
  *
  * @param integer $userID
  * @param array   $data
  * @return bool
  */
 public function updateShippingInfo($userID, $data)
 {
     if (!is_numeric($userID) || $data['shippingAddress'] == '' || $data['shippingCity'] == '' || $data['shippingState'] == '' || $data['shippingZip'] == '' || $data['shippingCountryID'] == '' || !is_numeric($data['shippingCountryID'])) {
         return false;
     }
     //Update my shipping info
     global $db;
     $db->updateFromArray(TABLE_TRADE_USERS, $data, ['userID' => $userID]);
     //Update trade table which has no shipping info with this info.
     //It will check trade table, and create records in trade_shipping_info
     $tradeIns = new BuckysTrade();
     $tradeShippingInfoIns = new BuckysTradeShippingInfo();
     //---------------- Update for seller ----------------------//
     $requiredList = $tradeIns->getShippingInfoRequiredTrade($userID, 'seller');
     if (!empty($requiredList) && count($requiredList) > 0) {
         foreach ($requiredList as $tradeData) {
             //Add shipping info
             $shippingRecID = $tradeShippingInfoIns->addTradeShippingInfo($userID);
             if (!empty($shippingRecID) && is_numeric($shippingRecID)) {
                 //update trade table
                 $tradeIns->updateTrade($tradeData['tradeID'], ['sellerShippingID' => $shippingRecID]);
             }
         }
     }
     //---------------- Update for buyer ----------------------//
     $requiredList = $tradeIns->getShippingInfoRequiredTrade($userID, 'buyer');
     if (!empty($requiredList) && count($requiredList) > 0) {
         foreach ($requiredList as $tradeData) {
             //Add shipping info
             $shippingRecID = $tradeShippingInfoIns->addTradeShippingInfo($userID);
             if (!empty($shippingRecID) && is_numeric($shippingRecID)) {
                 //update trade table
                 $tradeIns->updateTrade($tradeData['tradeID'], ['buyerShippingID' => $shippingRecID]);
             }
         }
     }
     //-------------------- Update Buyer Shipping Info -----------------------//
     $tradeShippingInfoIns->updateTradeShippingInfo($userID, $data);
     return true;
 }
示例#8
0
/**
* Save Tracking number
* 
*/
function saveTrackingNumber()
{
    $userID = buckys_is_logged_in();
    if (!$userID) {
        //You should be logged in
        echo json_encode(array('success' => 0, 'msg' => "Please sign in to save tracking number."));
    } else {
        $tradeIns = new BuckysTrade();
        $tradeID = get_secure_integer($_REQUEST['tradeID']);
        $trackingNo = get_secure_string($_REQUEST['trackingNo']);
        $tradeData = $tradeIns->getTradeByID($tradeID);
        if (empty($tradeData) || $tradeData['sellerID'] != $userID && $tradeData['buyerID'] != $userID) {
            //error, no permission
            echo json_encode(array('success' => 0, 'msg' => "You do not have permission."));
        } else {
            if ($tradeData['sellerID'] == $userID) {
                $tradeIns->updateTrade($tradeID, array('sellerTrackingNo' => $trackingNo));
            } else {
                $tradeIns->updateTrade($tradeID, array('buyerTrackingNo' => $trackingNo));
            }
            echo json_encode(array('success' => 1, 'msg' => "You have saved tracking number successfully."));
        }
    }
}