File: //www/exchange0old/exchange/templates/trader_left.html
<table cellspacing="0" cellpadding="0" border="0" width="100%">
<tbody>
<AJDF:output>if ($smarty.session.user.usertype=='1' OR $smarty.session.user.usertype=='2')</AJDF:output>
<tr>
<td align="left" valign="top"><div class="my_acc">
<div class="acc_prof1"> <a href="#" class="left_heading_my1"><b>My Exchange</b></a> </div>
<div class="clear"></div>
<div class="menu_center">
<div class="sub_h"><a href="?do=investorhome" class="sub_head"><b>Dashboard</b></a></div>
<div class="clear"></div>
<div class="sub_h"><a href="index.php?do=tradefloor" class="sub_head"><b>Trade Floor</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=invtradebook">My Trade Book (<AJDF:output>php</AJDF:output>
$sql = mysql_query("SELECT m.* FROM `invoice_master` as m ,invoice_bidding as inv WHERE inv.user_id ='".$_SESSION['user']['userid']."' && m.invoice_id = inv.invoice_id && m.invoice_status != 2 && m.trading_close_date >= NOW() && m.invoice_status = 1 group by m.invoice_id ");
while($row = mysql_fetch_array($sql)){
$invoice[] = $row['invoice_id'];
}
$sql1 = mysql_query("SELECT m.invoice_id FROM `invoice_master` as m, invoice_closed as cd
where cd.won_by = '".$_SESSION['user']['userid']."' && m.invoice_id = cd.invoice_id ");
while($case1 = mysql_fetch_array($sql1)){
$invoice[] = $case1['invoice_id'];
}
$sql2 = mysql_query("SELECT m.invoice_id FROM `invoice_master` as m, invoice_bidding as cd
where cd.user_id = '".$_SESSION['user']['userid']."' && cd.buy_out ='2' && m.invoice_id = cd.invoice_id GROUP BY cd.invoice_id");
while($key = mysql_fetch_array($sql2)){
$sql133 = mysql_query("SELECT cd.invoice_id FROM invoice_closed as cd
where cd.invoice_id = '".$key['invoice_id']."' LIMIT 1");
if(mysql_num_rows($sql33) == 0){
while($key = mysql_fetch_array($sql2)){
$invoice[] = $key['invoice_id'];
}
}
}
$sql3 = mysql_query("SELECT m.invoice_id, IF( (((select user_id from invoice_bidding as inv WHERE inv.invoice_id = m.invoice_id order by invoice_bidding_id DESC limit 1)) = '".$_SESSION['user']['userid']."') , 'yes','no') as new_status FROM `invoice_bidding` as cd, invoice_master as m WHERE cd.user_id = '".$_SESSION['user']['userid']."' && cd.buy_out ='1' && m.invoice_id = cd.invoice_id && m.invoice_status = 2");
while($case3 = mysql_fetch_array($sql3)){
$invoice[] = $case3['invoice_id'];
}
if(count($invoice) > 0){
$invoice1 = array_unique($invoice);
echo count($invoice1);
}else{
echo '0';
}
<AJDF:output> /php</AJDF:output>)</a></li>
<li class="unselect"><a href="#">My Trade Status (0)</a></li>
<li class="unselect"><a href="index.php?do=mytradebyyield">My Yield to Date</a></li>
<!--<li class="unselect"><a href="#">My Trade History<mytradebyyield/a></li>-->
</ul>
<div class="clear"></div>
<div class="sub_h"><a href="index.php?do=mystatements" class="sub_head"><b>My Transactions</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=mybankstatements">Bank Statements</a></li>
<li class="unselect"><a href="index.php?do=mytrastatements">Transaction Statements</a></li>
<li class="unselect"><a href="index.php?do=myreports">My Reports (<AJDF:output>php</AJDF:output>
$where = '';
$sql4_1 = mysql_query("SELECT temp_reg_id FROM `temp_registration` WHERE user_id = '".$_SESSION['user']['userid']."' limit 1 ");
while($case4_1 = mysql_fetch_array($sql4_1)){
$where = " || t.temp_reg_id = '".$case4_1['temp_reg_id']."' ";
}
$sql4 = mysql_query("SELECT t.*, c.*,td.*,DATE_FORMAT(t.transaction_date,'%d/%m/%Y') as order_date ".
" FROM `transactions` as t ".
" LEFT JOIN `transaction_detail` as td ON td.transaction_id = t.transaction_id ".
" LEFT JOIN `shopping_cart` as c ON c.cart_session = td.cart_session_id && c.user_id = t.user_id ".
" WHERE (t.user_id = '".$_SESSION['user']['userid']."' $where ) ");
$rprt_count = mysql_num_rows($sql4);
echo $rprt_count;
<AJDF:output> /php</AJDF:output>)</a></li>
</ul>
<div class="sub_h"><a href="#" class="sub_head"><b>My Messages</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=investorinbox">Inbox (<AJDF:output>php</AJDF:output>
$sql=mysql_query("SELECT count(message_id) AS msg FROM messages WHERE message_to='".$_SESSION['user']['userid']."' AND message_flag='1'");
$row=mysql_fetch_array($sql);
echo $row['msg'];
<AJDF:output> /php</AJDF:output>)</a></li>
<li class="unselect"><a href="index.php?do=investorsent">Sent Items</a></li>
<li class="unselect"><a href="index.php?do=investorcompose">Compose Message</a></li>
</ul>
<div class="sub_h"><a href="?do=showinvestorcurrency" class="sub_head"><b>My Currency Accounts</b></a></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="?do=invcurrencyaccountone" class="sub_head">Create new Account</a></li>
</ul>
<div class="sub_h"><a href="#" class="sub_head"><b>My User Account</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=myprofile">View / Edit Profile</a></li>
<li class="unselect"><a href="index.php?do=editdetails">Change Password</a></li>
</ul>
<div class="sub_h"><a href="index.php?do=showinvestorcurrency" class="sub_head"><b>My Organisation</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="#">Add new User</a></li>
<li class="unselect"><a href="#">Add new Branch </a></li>
<li class="unselect"><a href="index.php?do=invapplication1">Create new Organisation</a></li>
</ul>
<div class="sub_h"><a href="index.php?do=auto_trading" class="sub_head"><b>Automated Trading</b></a></div>
<div class="clear"></div>
<div style="border-bottom:1px solid #ccc;" class="sub_h"><a href="#" class="sub_head"><b>Dispute Resolution</b></a></div>
<div class="clear"></div>
</div>
<div>
<div class="acc_prof"><a href="#" class="left_heading_my"><b>Shop</b></a></div>
<div class="clear"></div>
<div class="acc_prof"><a href="#" class="left_heading_my"><b>Help Center</b></a></div>
<div class="clear"></div>
</div>
<div class="acc_bottom_left"></div>
<div class="acc_bottom_center"></div>
<div class="acc_bottom_right"></div>
<div class="clear"></div>
</div></td>
</tr>
<AJDF:output> elseif ($smarty.session.user.usertype=='3' OR $smarty.session.user.usertype=='4')</AJDF:output>
<tr>
<td align="left" valign="top"><div class="my_acc">
<div class="acc_prof1"> <a href="#" class="left_heading_my1"><b>My Exchange</b></a> </div>
<div class="clear"></div>
<div class="menu_center">
<div class="sub_h"><a href="?do=issuerhome" class="sub_head"><b>Dashboard</b></a></div>
<div class="clear"></div>
<div class="sub_h"><a href="index.php?do=tradefloor" class="sub_head"><b>Trade Floor</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=opentrade" class="sub_head">Open A Trade</a></li>
<li class="unselect"><a href="index.php?do=mytradedraft" class="sub_head">Post new Trade (<AJDF:output>php</AJDF:output>
$sql=mysql_query("SELECT count(invoice_id) AS msg FROM invoice_master WHERE user_id='".$_SESSION['user']['userid']."' AND draft='1'");
$row=mysql_fetch_array($sql);
echo $row['msg'];
<AJDF:output> /php</AJDF:output>)</a></li>
<AJDF:output>php</AJDF:output>
$query = mysql_query("SELECT org.organisation_id FROM organisation_details as org, debtor_relation as r WHERE
r.revolving_etr='1' && org.user_id ='". $_SESSION["user"]["userid"]."' &&
r.organisation_id = org.organisation_id ");
$offer = mysql_num_rows($query);
if($offer > 0){
echo '<li class="unselect"><a href="index.php?do=revolvingtrade" class="sub_head">Revolving ETR Upload</a></li>';
}
<AJDF:output> /php</AJDF:output>
<AJDF:output> php</AJDF:output>
$sql=mysql_query("SELECT partner_id FROM temp_registration WHERE user_id='".$_SESSION['user']['userid']."'");
$row=mysql_fetch_array($sql);
if($row['partner_id']==1)
{
echo '<li class="unselect"><a href="index.php?do=smbdrafttrade" class="sub_head">SMB Draft Trades</a>';
}
<AJDF:output> /php</AJDF:output>
</ul>
<div class="clear"></div>
<div class="sub_h"><a href="index.php?do=mytradebook" class="sub_head"><b>My Trade Book (<AJDF:output>php</AJDF:output>
$sql=mysql_query("SELECT count(invoice_id) AS msg FROM invoice_master WHERE user_id='".$_SESSION['user']['userid']."' AND draft='0'");
$row=mysql_fetch_array($sql);
echo $row['msg'];
<AJDF:output> /php</AJDF:output>)</b></a></div>
<div class="clear"></div>
<!--<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=mytradehistory" class="sub_head">My Trade History (0)</a></li>
</ul>-->
<div class="sub_h"><a href="index.php?do=mydebtor" class="sub_head"><b>My Debtors</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=createdebtor" class="sub_head">Create new Debtor</a></li>
</ul>
<div class="sub_h"><a href="#" class="sub_head"><b>My Messages</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=traderinbox">Inbox (
<AJDF:output> php</AJDF:output>
$sql=mysql_query("SELECT count(message_id) AS msg FROM messages WHERE message_to='".$_SESSION['user']['userid']."' AND message_flag='1'");
$row=mysql_fetch_array($sql);
echo $row['msg'];
<AJDF:output> /php</AJDF:output>
)</a></li>
<li class="unselect"><a href="index.php?do=tradersent">Sent Items</a></li>
<li class="unselect"><a href="index.php?do=tradercompose">Compose Message</a></li>
</ul>
<div class="sub_h"><a href="index.php?do=mystatements" class="sub_head"><b>My Transactions</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=mytrastatements">Transaction Statement</a></li>
<li class="unselect"><a href="index.php?do=myreports">My Reports (<AJDF:output>php</AJDF:output>
$where = '';
$sql4_1 = mysql_query("SELECT temp_reg_id FROM `temp_registration` WHERE user_id = '".$_SESSION['user']['userid']."' limit 1 ");
while($case4_1 = mysql_fetch_array($sql4_1)){
$where = " || t.temp_reg_id = '".$case4_1['temp_reg_id']."' ";
}
$sql4 = mysql_query("SELECT t.*, c.*,td.*,DATE_FORMAT(t.transaction_date,'%d/%m/%Y') as order_date ".
" FROM `transactions` as t ".
" LEFT JOIN `transaction_detail` as td ON td.transaction_id = t.transaction_id ".
" LEFT JOIN `shopping_cart` as c ON c.cart_session = td.cart_session_id && c.user_id = t.user_id ".
" WHERE (t.user_id = '".$_SESSION['user']['userid']."' $where ) ");
$rprt_count = mysql_num_rows($sql4);
echo $rprt_count;
<AJDF:output> /php</AJDF:output>)</a></li>
</ul>
<div class="sub_h"><a href="#" class="sub_head"><b>My User Account</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="index.php?do=mytrade">View / Edit Profile</a></li>
<li class="unselect"><a href="index.php?do=editpersonal">Change Password</a></li>
</ul>
<div class="sub_h"><a href="?do=showtradercurrency" class="sub_head"><b>My Organisation</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="#" class="sub_head">Add new User</a></li>
<li class="unselect"><a href="#" class="sub_head">Add new Branch</a></li>
<li class="unselect"><a href="?do=application1" class="sub_head">Create new Organisation</a></li>
</ul>
<div class="clear"></div>
<div style="border-bottom:1px solid #ccc;" class="sub_h"><a href="#" class="sub_head"><b>Dispute Resolution</b></a></div>
<div class="clear"></div>
</div>
<div>
<div class="acc_prof"><a href="#" class="left_heading_my"><b>Shop</b></a></div>
<div class="clear"></div>
<div class="acc_prof"><a href="#" class="left_heading_my"><b>Help Center</b></a></div>
<div class="clear"></div>
</div>
<div class="acc_bottom_left"></div>
<div class="acc_bottom_center"></div>
<div class="acc_bottom_right"></div>
<div class="clear"></div>
</div>
</td>
</tr>
<AJDF:output>elseif ($smarty.session.user.usertype=='5')</AJDF:output>
<tr>
<td align="left" valign="top"><div class="my_acc">
<div class="acc_prof1"> <a href="#" class="left_heading_my1"><b>Exchange</b></a> </div>
<div class="clear"></div>
<div class="menu_center">
<div class="sub_h"><a href="?do=intermediaryhome" class="sub_head"><b>Dashboard</b></a></div>
<div class="clear"></div>
<div class="sub_h"><a href="index.php?do=tradefloor" class="sub_head"><b>Trade Floor</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="javascript:void(0);">Trade Book (<AJDF:output>php</AJDF:output>
$sql = mysql_query("SELECT m.* FROM `invoice_master` as m ,invoice_bidding as inv WHERE inv.user_id ='".$_SESSION['user']['userid']."' && m.invoice_id = inv.invoice_id && m.invoice_status != 2 && m.trading_close_date >= NOW() && m.invoice_status = 1 group by m.invoice_id ");
while($row = mysql_fetch_array($sql)){
$invoice[] = $row['invoice_id'];
}
$sql1 = mysql_query("SELECT m.invoice_id FROM `invoice_master` as m, invoice_closed as cd
where cd.won_by = '".$_SESSION['user']['userid']."' && m.invoice_id = cd.invoice_id ");
while($case1 = mysql_fetch_array($sql1)){
$invoice[] = $case1['invoice_id'];
}
$sql2 = mysql_query("SELECT m.invoice_id FROM `invoice_master` as m, invoice_bidding as cd
where cd.user_id = '".$_SESSION['user']['userid']."' && cd.buy_out ='2' && m.invoice_id = cd.invoice_id ");
while($case2 = mysql_fetch_array($sql2)){
$invoice[] = $case2['invoice_id'];
}
$sql3 = mysql_query("SELECT m.invoice_id, IF( (((select user_id from invoice_bidding as inv WHERE inv.invoice_id = m.invoice_id order by invoice_bidding_id DESC limit 1)) = '".$_SESSION['user']['userid']."') , 'yes','no') as new_status FROM `invoice_bidding` as cd, invoice_master as m WHERE cd.user_id = '".$_SESSION['user']['userid']."' && cd.buy_out ='1' && m.invoice_id = cd.invoice_id && m.invoice_status = 2");
while($case3 = mysql_fetch_array($sql3)){
$invoice[] = $case3['invoice_id'];
}
if(count($invoice) > 0){
$invoice1 = array_unique($invoice);
echo count($invoice1);
}else{
echo '0';
}
<AJDF:output> /php</AJDF:output>)</a></li>
<li class="unselect"><a href="javascript:void(0);">Trade Status (0)</a></li>
<li class="unselect"><a href="javascript:void(0);">Yield to Date</a></li>
<!--<li class="unselect"><a href="#">My Trade History<mytradebyyield/a></li>-->
</ul>
<div class="clear"></div>
<div class="sub_h"><a href="javascript:void(0);" class="sub_head"><b>Transactions</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="javascript:void(0);">Bank Statements</a></li>
<li class="unselect"><a href="javascript:void(0);">Transaction Statements</a></li>
<!--<li class="unselect"><a href="index.php?do=myreports">My Reports (<AJDF:output>php</AJDF:output>
$where = '';
$sql4_1 = mysql_query("SELECT temp_reg_id FROM `temp_registration` WHERE user_id = '".$_SESSION['user']['userid']."' limit 1 ");
while($case4_1 = mysql_fetch_array($sql4_1)){
$where = " || t.temp_reg_id = '".$case4_1['temp_reg_id']."' ";
}
$sql4 = mysql_query("SELECT t.*, c.*,td.*,DATE_FORMAT(t.transaction_date,'%d/%m/%Y') as order_date ".
" FROM `transactions` as t ".
" LEFT JOIN `transaction_detail` as td ON td.transaction_id = t.transaction_id ".
" LEFT JOIN `shopping_cart` as c ON c.cart_session = td.cart_session_id && c.user_id = t.user_id ".
" WHERE (t.user_id = '".$_SESSION['user']['userid']."' $where ) ");
$rprt_count = mysql_num_rows($sql4);
echo $rprt_count;
<AJDF:output> /php</AJDF:output>)</a></li>-->
</ul>
<div class="sub_h"><a href="javascript:void(0);" class="sub_head"><b>My Messages</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="javascript:void(0);">Inbox (<AJDF:output>php</AJDF:output>
$sql=mysql_query("SELECT count(message_id) AS msg FROM messages WHERE message_to='".$_SESSION['user']['userid']."' AND message_flag='1'");
$row=mysql_fetch_array($sql);
echo $row['msg'];
<AJDF:output> /php</AJDF:output>)</a></li>
<li class="unselect"><a href="javascript:void(0);">Sent Items</a></li>
<li class="unselect"><a href="javascript:void(0);">Compose Message</a></li>
</ul>
<div class="sub_h"><a href="?do=showmyinvestors" class="sub_head"><b>My Investors</b></a></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="?do=addnewinvestor" class="sub_head">Create New Investor</a></li>
<li class="unselect"><a href="?do=showinvorg" class="sub_head">My Investor Organisation</a></li>
</ul>
<div class="sub_h"><a href="?do=showintermediarycurrency" class="sub_head"><b>My Organisation</b></a></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="?do=intermedapplication1" class="sub_head">Create New Organisation</a></li>
</ul>
<!-- <div class="sub_h"><a href="?do=showinvorg" class="sub_head"><b>My Investor Organisation</b></a></div> -->
<div class="sub_h"><a href="#" class="sub_head"><b>My User Account</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="?do=intermedprofile">View / Edit Profile</a></li>
<li class="unselect"><a href="?do=editaccountinfo">Change Password</a></li>
</ul>
<!-- <div class="sub_h"><a href="index.php?do=showinvestorcurrency" class="sub_head"><b>My Organisation</b></a></div>
<div class="clear"></div>
<ul class="myacc_l_menu">
<li class="unselect"><a href="#">Add new User</a></li>
<li class="unselect"><a href="#">Add new Branch </a></li>
<li class="unselect"><a href="index.php?do=invapplication1">Create new Organisation</a></li>
</ul>
<div class="sub_h"><a href="index.php?do=auto_trading" class="sub_head"><b>Automated Trading</b></a></div>
<div class="clear"></div>
<div style="border-bottom:1px solid #ccc;" class="sub_h"><a href="#" class="sub_head"><b>Dispute Resolution</b></a></div>
<div class="clear"></div>
</div>
<div>
<div class="acc_prof"><a href="#" class="left_heading_my"><b>Shop</b></a></div>-->
<div class="clear"></div>
<div class="acc_prof"><a href="#" class="left_heading_my"><b>Help Center</b></a></div>
<div class="clear"></div>
</div>
<div class="acc_bottom_left"></div>
<div class="acc_bottom_center"></div>
<div class="acc_bottom_right"></div>
<div class="clear"></div>
</div></td>
</tr>
<AJDF:output>/if</AJDF:output>
</tbody>
</table>