?>
</div>
<?php
if (!$data['isDownloadable']) {
?>
<div id="shipping_info_<?php
echo $data['orderID'];
?>
"
class="row-shipping-info">
<strong>Their Shipping Information:</strong>
<div>
<?php
$countryData = BuckysCountry::getCountryById($data['countryID']);
$shippingAddressVal = '<div>' . $data['fullName'] . '</div>' . '<div>' . $data['address'] . '</div>' . '<div>' . $data['address2'] . '</div>' . '<div>' . $data['city'] . ', ' . $data['state'] . '</div>' . '<div>' . $data['zip'] . '</div>' . '<div>' . $countryData["country_title"] . '</div>';
?>
<?php
echo $shippingAddressVal;
?>
</div>
</div>
<?php
}
?>
</div>
<div class="clear"></div>
</td>
<td class="n2">
/**
* Search items
*
* @param string $qStr : Query String
* @param string $catStr : Category Name/ Category ID
* @param string $locStr : Location / Location ID
* @return array
*/
public function search($qStr, $catStr, $locStr, $userID)
{
global $db;
$tradeCatIns = new BuckysTradeCategory();
$tradeLocationIns = new BuckysCountry();
//Get category data
$catData = null;
if (is_numeric($catStr)) {
$catData = $tradeCatIns->getCategoryByID($catStr);
} else {
$catData = $tradeCatIns->getCategoryByName($catStr);
}
//Get Location data
$locationData = null;
if (is_numeric($locStr)) {
$locationData = $tradeLocationIns->getCountryById($locStr);
} else {
$locationData = $tradeLocationIns->getCountryByName($locStr);
}
//Make Where condition
$whereCondList = array();
if (isset($qStr) && $qStr != '') {
$qStr = addslashes($qStr);
$whereCondList[] = sprintf(" MATCH (i.title, i.subtitle, i.description) AGAINST ('%s' IN BOOLEAN MODE)", $qStr);
}
if (isset($catData)) {
$whereCondList[] = 'i.catID=' . $catData['catID'];
} else {
if ($catStr != '') {
return null;
}
}
if (isset($locationData)) {
$whereCondList[] = 'i.locationID=' . $locationData['countryID'];
}
if (isset($userID) && is_numeric($userID)) {
$whereCondList[] = 'i.userID=' . $userID;
}
//Valid items
$avaiableTime = date('Y-m-d H:i:s', time() - TRADE_ITEM_LIFETIME * 3600 * 24);
$whereCondList[] = "i.createdDate >='" . $avaiableTime . "'";
$whereCondList[] = 'i.status=' . BuckysTradeItem::STATUS_ITEM_ACTIVE;
$whereCond = ' WHERE ' . implode(' AND ', $whereCondList);
$whereCond .= ' GROUP BY i.itemID ';
$query = sprintf("SELECT i.*, (SELECT COUNT(*) FROM %s AS o WHERE i.itemID=o.targetItemID AND o.status=%d) AS offer, u.firstName, u.lastName, tu.totalRating, tu.positiveRating \n FROM %s AS i \n LEFT JOIN %s AS tu ON i.userID=tu.userID \n LEFT JOIN %s AS u ON i.userID=u.userID \n ", TABLE_TRADE_OFFERS, BuckysTradeOffer::STATUS_OFFER_ACTIVE, TABLE_TRADE_ITEMS, TABLE_TRADE_USERS, TABLE_USERS);
$query = $db->prepare($query . $whereCond);
$data = $db->getResultsArray($query);
return $data;
}
/**
* Search products
*
* @param string $qStr : Query String
* @param string $catStr : Category Name/ Category ID
* @param string $locStr : Location / Location ID
* @return array
*/
public function search($qStr, $catStr, $locStr, $userID)
{
global $db;
$catIns = new BuckysShopCategory();
$locationIns = new BuckysCountry();
//Get category data
$catData = null;
if (is_numeric($catStr)) {
$catData = $catIns->getCategoryByID($catStr);
} else {
$catData = $catIns->getCategoryByName($catStr);
}
//Get Location data
$locationData = null;
if (is_numeric($locStr)) {
$locationData = $locationIns->getCountryById($locStr);
} else {
$locationData = $locationIns->getCountryByName($locStr);
}
//Make Where condition
$whereCondList = [];
if (isset($qStr) && $qStr != '') {
$qStr = addslashes($qStr);
$whereCondList[] = sprintf(" MATCH (p.title, p.subtitle, p.description) AGAINST ('%s' IN BOOLEAN MODE)", $qStr);
}
if (isset($catData)) {
$whereCondList[] = 'p.catID=' . $catData['catID'];
} else {
if ($catStr != '') {
return null;
}
}
if (isset($locationData)) {
$whereCondList[] = 'p.locationID=' . $locationData['countryID'];
}
if (isset($userID) && is_numeric($userID)) {
$whereCondList[] = 'p.userID=' . $userID;
}
//Valid items
$avaiableTime = date('Y-m-d H:i:s');
$whereCondList[] = " (p.expiryDate >='" . $avaiableTime . "' OR p.listingDuration=-1) ";
$whereCondList[] = 'p.status=' . BuckysShopProduct::STATUS_ACTIVE;
$whereCond = ' WHERE ' . implode(' AND ', $whereCondList);
$whereCond .= ' GROUP BY p.productID ';
$query = sprintf("SELECT p.*, u.firstName, u.lastName, tu.totalRating, tu.positiveRating \n FROM %s AS p \n LEFT JOIN %s AS tu ON p.userID=tu.userID \n LEFT JOIN %s AS u ON p.userID=u.userID \n ", TABLE_SHOP_PRODUCTS, TABLE_USERS_RATING, TABLE_USERS);
$query = $db->prepare($query . $whereCond);
$data = $db->getResultsArray($query);
return $data;
}
$userIns = new BuckysUser();
$tradeOfferIns = new BuckysTradeOffer();
$view['item'] = $tradeItemIns->getItemById($paramItemID);
$view['myID'] = $userID;
if (!isset($view['item']) || $view['item']['status'] == BuckysTradeItem::STATUS_ITEM_INACTIVE) {
buckys_redirect('/trade/index.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
}
//Check if the items owner is active one
$userData = $userIns->getUserData($view['item']['userID']);
if ($userData['status'] == BuckysUser::STATUS_USER_BANNED) {
buckys_redirect('/trade/index.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
}
//Read more info from DB
$catData = $tradeCatIns->getCategoryByID($view['item']['catID']);
$view['item']['categoryName'] = isset($catData) ? $catData['name'] : '';
$countryData = $countryIns->getCountryById($view['item']['locationID']);
$view['item']['locationName'] = isset($countryData) ? $countryData['country_title'] : '';
$view['item']['userInfo'] = $userIns->getUserBasicInfo($view['item']['userID']);
if (!isset($view['item']['userInfo'])) {
buckys_redirect('/trade/index.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
}
//Check if you can make an offer to this user. If this user decline your offer before for this item, then you can't send again
$view['offerDisabled'] = false;
if (!$userID || $userID == $view['item']['userID']) {
$view['offerDisabled'] = true;
} else {
/**
* If it has been set, then it means you can't make an offer if one of your offer declined by this user.
* When you enable this block, please note BuckysTradeOffer::addOffer() function, there are parts disabled
*/
//$view['offerDisabled'] = $tradeOfferIns->checkDeclinedOffer($view['item']['itemID'], null, $userID);
$userIns = new BuckysUser();
$shippingInfoIns = new BuckysTradeUser();
$view['product'] = $shopProductIns->getProductById($paramShopID);
$view['myID'] = $userID;
if (!isset($view['product']) || $view['product']['status'] == BuckysShopProduct::STATUS_INACTIVE) {
buckys_redirect('/shop/index.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
}
//Check if the items owner is active one
$userData = $userIns->getUserData($view['product']['userID']);
if ($userData['status'] == BuckysUser::STATUS_USER_BANNED) {
buckys_redirect('/shop/index.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
}
//Read more info from DB
$catData = $catIns->getCategoryByID($view['product']['catID']);
$view['product']['categoryName'] = isset($catData) ? $catData['name'] : '';
$countryData = $countryIns->getCountryById($view['product']['locationID']);
$view['product']['locationName'] = isset($countryData) ? $countryData['country_title'] : '';
$view['product']['userInfo'] = $userIns->getUserBasicInfo($view['product']['userID']);
if (!isset($view['product']['userInfo'])) {
buckys_redirect('/shop/index.php', MSG_INVALID_REQUEST, MSG_TYPE_ERROR);
}
$view['my_product_flag'] = false;
$view['available_shipping_price'] = null;
$view['my_shipping_info'] = $myShippingData = $shippingInfoIns->getUserByID($userID);
$view['fill_shipping_info'] = false;
$view['my_info'] = $userIns->getUserBasicInfo($userID);
$view['is_purchased'] = $shopProductIns->isPurchased($userID, $paramShopID);
if (!$userID || $userID == $view['product']['userID']) {
$view['my_product_flag'] = true;
} else {
if ($view['product']['isDownloadable'] == 1) {
/**
* Get country by ID
*
* @param integer $countryID
*/
function buckys_trade_get_country_name($countryID)
{
$countryIns = new BuckysCountry();
$countryData = $countryIns->getCountryById($countryID);
if ($countryData) {
return $countryData['country_title'];
}
return;
}
<?php
echo $view['my_info']['firstName'] . ' ' . $view['my_info']['lastName'] . "<br/>";
if ($view['my_shipping_info']['shippingAddress'] != '') {
echo $view['my_shipping_info']['shippingAddress'] . ' ' . $view['my_shipping_info']['shippingAddress2'] . "<br/>";
}
if ($view['my_shipping_info']['shippingCity'] != '') {
echo $view['my_shipping_info']['shippingCity'] . ", ";
}
if ($view['my_shipping_info']['shippingState'] != '') {
echo $view['my_shipping_info']['shippingState'] . "<br/>";
}
if ($view['my_shipping_info']['shippingZip'] != '') {
echo $view['my_shipping_info']['shippingZip'] . "<br/>";
}
if ($view['my_shipping_info']['shippingCountryID'] != '') {
$cotD = BuckysCountry::getCountryById($view['my_shipping_info']['shippingCountryID']);
echo $cotD['country_title'];
}
?>
</p>
<label>Returns:</label>
<p>
<?php
echo $productData['returnPolicy'];
?>
</p>
<label>Item:</label>
<div class="clear"></div>
<div class="prod-l">
