admin_hanghoa.php | searchcode

/admin/admin_hanghoa.php

http://webdienmay.googlecode.com/
PHP | 163 lines | 156 code | 7 blank | 0 comment | 13 complexity | 7d10275d468df37c359d48c0c4c93315 MD5 | raw file

<?php ob_start(); session_start(); ob_clean();

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>ADMIN_ Trang Xe</title>

</head>



<body>

 <?php 

	if(isset($_SESSION['userid'])&&$_SESSION['level']==2)

	{

?>

<form id="form1" name="form1" method="post" action="">

  <p align="center">Danh Sách Hŕng Hóa<br />

    <a href="them_hanghoa.php">Thęm M?i</a>----<a href="uploadhh.php">Thęm Danh Sách T? File XML</a>---- <a href="admin_ghj.php">Trang Admin </a></p>

  <table width="1000" border="1" align="center" cellpadding="0" cellspacing="0">

    <tr bgcolor="#FFFFCC">

      <td width="10"><div align="center" class="style1">STT</div></td>

      <td width="80"><div align="center" class="style1">Mă Hŕng</div></td>

      <td width="180"><div align="center" class="style1">Tęn Hŕng</div></td>

      <td width="100"><div align="center">Giá</div></td>

      <td width="100"><div align="center">S? L??ng</div></td>

      <td width="130"><div align="center" class="style1">Hěnh</div></td>

      <td width="200"><div align="center">Thông Tin</div></td>

      <td width="100"><div align="center">Mă Nhóm </div>

          <div align="center" class="style1"></div></td>

      <td width="50"><div align="center" class="style1">S?a</div></td>

      <td width="50"><div align="center" class="style1">Xóa</div></td>

    </tr>

      <?php

  require_once("../db.inc");

  $sodong=5;

  $nhom=4;

  $i=0;

  

  if(!isset($_GET["tst"])) 

  {

	  $kq=mysql_query("select * from hanghoa order by Mahang ASC ",$link);

	  $tongsotrang=ceil((mysql_num_rows($kq)-1)/$sodong);

	  $tongsonhom=ceil($tongsotrang/$nhom);

  }

  else

  {

	  $tongsotrang=intval($_GET["tst"]);

	  $tongsonhom=ceil($tongsotrang/$nhom);

  }

  if (!isset($_GET["p"]))

  { 

      if (!isset($_GET["n"]))

	  {$p=1; $n=1; }

	  else

	  {$n=intval($_GET["n"]);

	   $p=$n*$nhom-$nhom+1;  }

  }

  else

  {

  	$p=intval($_GET["p"]);

	$n=ceil($p/$nhom);

  }

  $x=($p-1)*$sodong;

  $s="select * from hanghoa order by Mahang ASC limit ".$x.",".$sodong;

  $kq=mysql_query($s,$link);

  while($dong=mysql_fetch_array($kq) )

  {	

  	if($dong["Mahang"]!='0')

	{

	$i++;

	$sql2="SELECT hanghoa.Mahang, sum( admin_nhaphang.Soluong ) as Nhap FROM admin_nhaphang, hanghoa WHERE admin_nhaphang.Mahang = hanghoa.Mahang AND admin_nhaphang.Manhom = hanghoa.Manhom AND hanghoa.Mahang = '".$dong["Mahang"]."' AND hanghoa.Manhom = '".$dong["Manhom"]."' Group by admin_nhaphang.Mahang,admin_nhaphang.Manhom" ;

		  		  

	$kq2=mysql_query($sql2,$link);

	$dong2=mysql_fetch_array($kq2);

		  

	$sql3="SELECT hanghoa.Mahang, sum( admin_xuatkho.Soluong ) as Xuat FROM admin_xuatkho, hanghoa WHERE admin_xuatkho.Mahang = hanghoa.Mahang AND admin_xuatkho.Manhom = hanghoa.Manhom AND hanghoa.Mahang = '".$dong["Mahang"]."' AND hanghoa.Manhom = '".$dong["Manhom"]."' Group by admin_xuatkho.Mahang,admin_xuatkho.Manhom" ;

		  		  

	$kq3=mysql_query($sql3,$link);

	$dong3=mysql_fetch_array($kq3);

	$Sl=$dong2["Nhap"]-$dong3["Xuat"];

	

	$t1=substr($dong["Gia"],-3,4);

	$t2=substr($dong["Gia"],-6,-3);

	$t3=substr($dong["Gia"],0,-6);

	if($dong["Gia"]>999999) $gia=$t3.'.'.$t2.'.'.$t1.' VN&#272;';

	else  $gia=$t2.'.'.$t1.' VN&#272;';

  ?>

    <tr>

      <td width="10"><div align="center"><?php echo $i; ?></div></td>

      <td width="80"><div align="center"><?php echo $dong["Mahang"]; ?></div></td>

      <td width="180"><div align="center"><?php echo $dong["Tenhang"]; ?></div></td>

      <td width="100"><div align="center"><?php echo $gia; ?></div></td>

      <td width="100"><div align="center"><?php echo $Sl ?></div></td>

      <td width="130"><div align="center"><img src="../images/hanghoa/<?php echo $dong["Hinh"]; ?>" alt="" width="120" height="150" /></div></td>

      <td width="200"><div align="center">

        <label for="textarea"></label>

        <textarea name="textarea" id="textarea" cols="30" rows="2" disabled="disabled"><?php echo $dong["Thongtin"]; ?></textarea>

        </div></td>

      <td width="100"><div align="center"><?php echo $dong["Manhom"]; ?></div></td>

      <td width="50"><div align="center"><a href="sua_hanghoa.php?id=<?php echo $dong["Mahang"]; ?>">S?a</a></div></td>

      <td width="50"><div align="center"><a href="xoa_hanghoa.php?id=<?php echo $dong["Mahang"]; ?>">Xóa</a></div></td>

    </tr>

    <?php

	}

  }

  

  ?>

  </table>

 <p align="center">Phân Trang : 

<?php if ($n>1) {

	$n1=$n-1;

?>

<a href="admin_hanghoa.php?n=<?php echo $n1; ?>&tst=<?php echo $tongsotrang; ?>"><<</a>&nbsp;

<?php } ?>	

<?php

$dau=($n-1)*$nhom+1;

if ($n<$tongsonhom)

{$cuoi=$dau+$nhom-1;

}

else

{$cuoi=$tongsotrang;}

for($i=$dau;$i<=$cuoi;$i++)

{ if ($i==$p)

   { echo $i."&nbsp;";

   }

   else

   {

 ?>

 <a href="admin_hanghoa.php?p=<?php echo $i; ?>&tst=<?php echo $tongsotrang; ?>"><?php echo $i; ?></a>

<?php

   }

}

?>   

<?php if ($n<$tongsonhom) {

	$n2=$n+1;

?>

<a href="admin_hanghoa.php?n=<?php echo $n2; ?>&tst=<?php echo $tongsotrang; ?>">>></a>&nbsp;

<?php } ?>

</p>

</form>

<?php

	}

	else 

	{

			?>

    </div>

    <form action=../login.php method=post>

	  <div align="center">

	    <p>?? vŕo ???c trang qu?n tr? b?n c?n ??ng nh?p v?i tŕi kho?n c?a qu?n tr? vięn.</p>

	    <p>Tŕi kho?n:

	      <input type=text name=username size=15 />

	      <br />

	M?t kh?u:

	<input type=password name=password size=15 />

	<br />

	<input type=submit name=ok value="??ng Nh?p" />

	      </p>

	  </div>

</form>

	<div align="center">

	  <?php

	}?>

<p align="center">&nbsp;</p>

</body>

</html>