/**
* @brief
* @param row a row from the items table of the database
* @returns an object of the class OC_News_Item
*/
public function fromRow($row)
{
$url = $row['url'];
$title = $row['title'];
$guid = $row['guid'];
$body = $row['body'];
$id = $row['id'];
$item = new Item($url, $title, $guid, $body, $id);
$item->setStatus($row['status']);
$item->setAuthor($row['author']);
$item->setDate(Utils::dbtimestampToUnixtime($row['pub_date']));
return $item;
}
function autoMail()
{
global $database;
//$itemsArr = array();
$today = date("Y-m-d");
$this->query = "select * from items where BidEndOn ='{$today}' AND highest_bid!=0";
$result = mysql_query($this->query);
while ($row = mysql_fetch_array($result)) {
$item = new Item();
$item->setItemId($row["ItemID"]);
$item->setTitle($row["Title"]);
$item->setMinPrice($row["min_price"]);
$item->setCategory($row["Category"]);
$item->setOwnerId($row["OwnerID"]);
$ad = date("Y-m-d H:i:s", strtotime($row['addedOn']));
$item->setHighestBid($row["highest_bid"]);
$item->setAddedOn($ad);
$item->setBiddingEndOn($row["BidEndOn"]);
$item->setDesc($row["Description"]);
$item->setStatus($row["Status"]);
$this->query = "SELECT PicDate,PicPath FROM itempics WHERE OwnId = " . $item->ownerId . " AND PicDate = '" . $ad . "'";
$res = mysql_query($this->query);
$r = mysql_fetch_array($res);
$item->setPicPath($r['PicPath']);
$this->query = "select email from user where UserID={$item->ownerId}";
$res = mysql_query($this->query);
$r = mysql_fetch_row($res);
$OwnerEmail = $r[0];
$this->query = "select bids.BidderID from items INNER JOIN bids ON items.highest_bid=bids.amount where items.ItemID ={$item->itemId}";
$res = mysql_query($this->query);
$r = mysql_fetch_row($res);
$bidderId = $r[0];
$this->query = "select email from user where UserID={$bidderId}";
$res = mysql_query($this->query);
$r = mysql_fetch_row($res);
$WinnerEmail = $r[0];
echo "\nOwner email:" . $OwnerEmail . "\n";
echo "\nWinner email:" . $WinnerEmail . "\n";
$this->query = "update account set balance=balance+{$item->highestBid} where UserID={$item->ownerId}";
mysql_query($this->query);
$this->query = "delete from bids where ItemID={$item->itemId}";
mysql_query($this->query);
$this->query = "update items set OwnerId ={$bidderId}, status='sold' where ItemID={$item->itemId}";
mysql_query($this->query);
$this->query = "insert into WonItems (winnerId,ownerId) values ({$bidderId}, {$item->ownerId} )";
mailForOwner($OwnerEmail, $item);
mailForWinner($WinnerEmail, $item);
}
}
/**
* @brief
* @param row a row from the items table of the database
* @returns an object of the class OC_News_Item
*/
public function fromRow($row)
{
$url = $row['url'];
$title = $row['title'];
$guid = $row['guid'];
$body = $row['body'];
$id = $row['id'];
$item = new Item($url, $title, $guid, $body, $id);
$item->setStatus($row['status']);
$item->setAuthor($row['author']);
$item->setFeedId($row['feed_id']);
$item->setDate(Utils::dbtimestampToUnixtime($row['pub_date']));
if ($row['enclosure_mime'] !== null && $row['enclosure_link'] !== null) {
$enclosure = new Item_Enclosure();
$enclosure->setMimeType($row['enclosure_mime']);
$enclosure->setLink($row['enclosure_link']);
$item->setEnclosure($enclosure);
}
return $item;
}
function getItem($id)
{
global $database;
$item = new Item();
$this->query = "select * from items where ItemID='{$id}'";
$result = mysql_query($this->query);
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_row($result);
$item->setItemId($row[0]);
$item->setTitle($row[1]);
$item->setMinPrice($row[2]);
$item->setHighestBid($row[3]);
$item->setCategory($row[4]);
$item->setOwnerId($row[5]);
$item->setAddedOn($row[6]);
$item->setBiddingEndOn($row[7]);
$item->setDesc($row[8]);
$item->setStatus($row[9]);
}
return $item;
}
public function testToExport()
{
$item = new Item();
$item->setId(3);
$item->setGuid('guid');
$item->setGuidHash('hash');
$item->setUrl('https://google');
$item->setTitle('title');
$item->setAuthor('author');
$item->setPubDate(123);
$item->setBody('body');
$item->setEnclosureMime('audio/ogg');
$item->setEnclosureLink('enclink');
$item->setFeedId(1);
$item->setStatus(0);
$item->setRead();
$item->setStarred();
$item->setLastModified(321);
$feed = new Feed();
$feed->setLink('http://test');
$feeds = array("feed1" => $feed);
$this->assertEquals(array('guid' => 'guid', 'url' => 'https://google', 'title' => 'title', 'author' => 'author', 'pubDate' => 123, 'body' => 'body', 'enclosureMime' => 'audio/ogg', 'enclosureLink' => 'enclink', 'unread' => false, 'starred' => true, 'feedLink' => 'http://test'), $item->toExport($feeds));
}
function autoMail()
{
global $database;
//$itemsArr = array();
$today = date("Y-m-d");
$this->query = "select * from items where BidEndOn ='{$today}' AND highest_bid!=0 AND status != 'sold'";
$result = mysql_query($this->query);
while ($row = mysql_fetch_array($result)) {
$item = new Item();
$item->setItemId($row["ItemID"]);
$item->setTitle($row["Title"]);
$item->setMinPrice($row["min_price"]);
$item->setCategory($row["Category"]);
$item->setOwnerId($row["OwnerID"]);
$ad = date("Y-m-d H:i:s", strtotime($row['addedOn']));
$item->setHighestBid($row["highest_bid"]);
$item->setAddedOn($ad);
$item->setBiddingEndOn($row["BidEndOn"]);
$item->setDesc($row["Description"]);
$item->setStatus($row["Status"]);
print_r($item);
$this->query = "SELECT PicDate,PicPath FROM itempics WHERE OwnId = " . $item->ownerId . " AND PicDate = '" . $ad . "'";
$res = mysql_query($this->query);
$r = mysql_fetch_array($res);
$item->setPicPath($r['PicPath']);
$this->query = "select email from user where UserID={$item->ownerId}";
$res = mysql_query($this->query);
$r = mysql_fetch_row($res);
$OwnerEmail = $r[0];
$ul = new UserLogic();
$ownuser = $ul->getUser($item->ownerId);
$this->query = "select bids.BidderID from items INNER JOIN bids ON items.highest_bid=bids.amount where bids.ItemID ={$item->itemId}";
$res = mysql_query($this->query);
$r = mysql_fetch_row($res);
$bidderId = $r[0];
echo $bidderId;
$winuser = $ul->getUser($r[0]);
$this->query = "select email from user where UserID={$bidderId}";
$res = mysql_query($this->query);
$r = mysql_fetch_row($res);
$WinnerEmail = $r[0];
echo "\nOwner email:" . $OwnerEmail . "\n";
echo "\nWinner email:" . $WinnerEmail . "\n";
require "fbmain.php";
if ($facebook) {
if ($ownuser->fb_id) {
try {
$wallpostpage = $facebook->api('/' . $ownuser->fb_id . '/feed', 'post', array('message' => 'Your item ' . $item->title . '. has been sold at price ' . $item->highestBid . '$. ', 'picture' => 'http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs1324.snc4/161996_166764056682774_6216247_q.jpg
', 'link' => 'http://www.facebook.com/apps/application.php?id=166764056682774', 'name' => 'eVeiling.com', 'cb' => ''));
} catch (FacebookApiException $e) {
print_r($o);
}
}
if ($winuser->fb_id) {
try {
$wallpostpage = $facebook->api('/' . $winuser->fb_id . '/feed', 'post', array('message' => 'You have won the auction of ' . $item->title . ' at ' . $item->highestBid . '$.', 'picture' => 'http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs1324.snc4/161996_166764056682774_6216247_q.jpg
', 'link' => 'http://www.facebook.com/apps/application.php?id=166764056682774', 'name' => 'eVeiling.com', 'cb' => ''));
} catch (FacebookApiException $e) {
print_r($o);
}
}
}
$this->query = "update account set balance=balance+{$item->highestBid} where UserID={$item->ownerId}";
mysql_query($this->query);
$this->query = "delete from bids where ItemID={$item->itemId}";
mysql_query($this->query);
$this->query = "update items set OwnerId ={$bidderId}, status='sold' where ItemID={$item->itemId}";
mysql_query($this->query);
$this->query = "insert into WonItems (winnerId,ownerId,ItemId) values ({$bidderId}, {$item->ownerId},{$item->itemId} )";
mysql_query($this->query);
mailForOwner($OwnerEmail, $item);
mailForWinner($WinnerEmail, $item);
}
}
static function getItems(Feed &$feed)
{
$fid = $feed->getId();
$text = $feed->getMessage();
static::doParse($text);
$assocs = static::$array;
$result = array();
foreach ($assocs as $index => $assoc) {
$item = new Item();
$item->setId($fid . '_' . $index);
$item->setFeed($feed);
if (isset($assoc['type'])) {
$item->setType($assoc['type']);
} else {
$item->setType('GLOBAL');
}
if (isset($assoc['description'])) {
$item->setDescription($assoc['description']);
}
if (isset($assoc['global'])) {
$item->setGlobal($assoc['global']);
}
if (isset($assoc['name'])) {
$item->setName($assoc['name']);
}
if (isset($assoc['note'])) {
$item->setNote($assoc['note']);
}
if (isset($assoc['price_digit'])) {
$item->setPrice($assoc['price_digit']);
}
if (isset($assoc['price'])) {
$item->setPriceStr($assoc['price']);
}
if (isset($assoc['status'])) {
$item->setStatus($assoc['status']);
}
$result[] = $item;
}
if (!$result) {
$item = new Item();
$item->setId($fid . '_0');
$item->setFeed($feed);
$item->setType('GLOBAL');
$item->setGlobal($text);
$result[] = $item;
}
return $result;
}
session_start();
require_once 'Logic/ItemLogic.php';
$title = $_POST['title'];
$minPrice = $_POST['minPrice'];
$category = $_POST['category'];
$Enddate = $_POST['inputDate'];
$desc = $_POST['desc'];
$item = new Item();
$item->setTitle($title);
$item->setMinPrice($minPrice);
$item->setCategory($category);
$item->setBiddingEndOn($Enddate);
$item->setDesc($desc);
$item->setOwnerId($_SESSION['user']);
//($_SESSION['user']);
$item->setStatus("available");
$itemLogic = new ItemLogic();
$itemLogic->insertItem($item);
?>
<script type="text/javascript">
</script>
<div class="c">
<form id="abc" method="post">
<div id="file-uploader-demo1">
<noscript>
<p>Please enable JavaScript to use file uploader.</p>
<!-- or put a simple form for upload here -->
</noscript>
function getPostedItems($id)
{
global $database;
$itemsArr = array();
$this->query = "select * from items where ownerid={$id}";
$result = mysql_query($this->query);
if ($result) {
while ($row = mysql_fetch_array($result)) {
$item = new Item();
$item->setItemId($row["ItemID"]);
$item->setTitle($row["Title"]);
$item->setMinPrice($row["min_price"]);
$item->setCategory($row["Category"]);
$item->setOwnerId($row["OwnerID"]);
$ad = date("Y-m-d H:i:s", strtotime($row['addedOn']));
$item->setHighestBid($row["highest_bid"]);
$item->setAddedOn($ad);
$item->setBiddingEndOn($row["BidEndOn"]);
$item->setDesc($row["Description"]);
$item->setStatus($row["Status"]);
$this->query = "SELECT PicDate,PicPath FROM itempics WHERE OwnId = " . $item->ownerId . " AND PicDate = '" . $ad . "'";
$res = mysql_query($this->query);
$r = mysql_fetch_array($res);
$item->setPicPath($r['PicPath']);
array_push($itemsArr, $item);
}
return $itemsArr;
}
}
