<?php
include 'vp_dbconfig.php';
$start = $_REQUEST['start'];
$limit = $_REQUEST['limit'];
$user = $_REQUEST['user'];
$notifications_array = array();
$orderid_array = array();
if ($user == "vendor") {
$vendor_name = FetchVendorNameFromId($vendor_id);
if (!isset($_REQUEST['markorders'])) {
if ($_REQUEST['first'] == "yes") {
$query = "select * from vendor_notifications where value={$vendor_id} or user like '%|{$vendor_id}' order by created_at DESC, display_once ASC limit {$start}, {$limit}";
} else {
if ($_REQUEST['first'] == "no") {
$query = "select * from vendor_notifications where display_once IN (0, 2) and (value={$vendor_id} or user like '%|{$vendor_id}') order by created_at DESC, display_once ASC limit {$start}, {$limit}";
} else {
if ($_REQUEST['first'] == "no2") {
$query = "select * from vendor_notifications where value={$vendor_id} or user like '%|{$vendor_id}' order by created_at DESC, display_once ASC limit {$start}, {$limit}";
}
}
}
//$query = "select * from vendor_notifications where display_once in (0, 2) and value=$vendor_id or user like '%|$vendor_id' order by FIND_IN_SET(display_once, '0, 2') limit $start, $limit";
//echo $query;
$result = mysql_query($query);
//echo mysql_error()."<br><br>";
while ($row = mysql_fetch_assoc($result)) {
//echo "<br><br>I am in while.<br>";
$id = $row['id'];
$type = $row['type'];
$user = $row['user'];
if ($type == "6") {
//echo "Landed 6.";
$comment_main = explode("|", $user);
$comment = $comment_main[0];
$vendor_name = FetchVendorNameFromId($comment_main[1]);
if (is_numeric($comment_main[1])) {
$temp_notification = "<a href='vp_ordermain.php?orderid={$orderid}&flag=1&display_flag=0' target='_blank' style='text-decoration:none; color:black;'>- <b>{$vendor_name}</b> has added Comment '<b>{$comment}</b>' in Order <b>{$orderid}</b>.<br>{$time}</a>";
} else {
$temp_notification = "<a href='vp_ordermain.php?orderid={$orderid}&flag=1&display_flag=0' target='_blank' style='text-decoration:none; color:black;'>- <b>" . $comment_main[1] . "</b> has added Comment '<b>{$comment}</b>' in Order <b>{$orderid}</b>.<br>{$time}</a>";
}
} else {
if ($type == "7") {
//echo "Landed 7.";
$remark_main = explode("|", $user);
$remark = $remark_main[0];
$vendor_name = FetchVendorNameFromId($remark_main[1]);
if (is_numeric($remark_main[1])) {
$temp_notification = "<a href='vp_ordermain.php?orderid={$orderid}&flag=1&display_flag=0' target='_blank' style='text-decoration:none; color:black;'>- <b>{$vendor_name}</b> has added a Remark '<b>{$remark}</b>' while accepting the Order <b>{$orderid}</b>.<br>{$time}</a>";
} else {
$temp_notification = "<a href='vp_ordermain.php?orderid={$orderid}&flag=1&display_flag=0' target='_blank' style='text-decoration:none; color:black;'>- <b>" . $remark_main[1] . "</b> has added a Remark '<b>{$remark}</b>' while accepting the Order <b>{$orderid}</b>.<br>{$time}</a>";
}
} else {
//echo "Landed Here.";
}
}
}
}
}
}
}
}
