<?php
include_once("inc/auth.inc.php");
include_once("inc/utility_all.php");
$HTML_PAGE_TITLE = _("查看产品管理");
include_once("general/crm/apps/crm/header.php");
include_once("inc/utility_org.php");
include_once("inc/utility_file.php");
include_once(G_STUDIO_PATH."/include/utility.mins.php");
include_once(G_STUDIO_PATH."/include/utility.ui.php");
include_once(G_CRM_PATH."/include/general.func.php");
include_once(G_STUDIO_PATH."/include/entity.class.php");
include_once(G_CRM_PATH."/include/xml/xmlDocument.class.php");
include_once(G_STUDIO_PATH."/include/sysstatus.php");
include_once(G_STUDIO_PATH."/include/classes/filter/filter_inter.php");
$entity = "crm_product";
include_once(G_STUDIO_PATH."/include/auth.php");
//ob_end_clean();
?>
<link rel="stylesheet" type="text/css" href="/<?=G_CRM_PATH?>/styles/detail.css" />
<script src="<?=MYOA_JS_SERVER?>/static/js/module.js?v=<?=MYOA_SYS_VERSION?>"></script>
<script type="text/javascript" src="<?=MYOA_JS_SERVER?>/static/js/attach.js"></script>
<script src="/<?=G_CRM_PATH?>/include/js/check.js"></script>
<script src="/<?=G_PLATFORM_PATH?>/js/general/general.js"></script>
<script src="/<?=G_PLATFORM_PATH?>/js/extend/jquery/jquery.min.js"></script>
<script src="/<?=G_PLATFORM_PATH?>/js/extend/DatePicker/WdatePicker.js"></script>
<script src="/<?=G_CRM_PATH?>/include/js/detail.js"></script>
<script Language="JavaScript">var upload_limit=1,limit_type="php,php3,php4,php5,";</script>
<body marginheight=0 marginwidth=0 class="bodycolor" style="margin:0px 20px 0px 20px;padding-bottom:5px;">
<script>
$(document).ready(function(){
$.noConflict();
});
var G = G || {};
G.entity = "<?=$entity?>";
G.id = "<?=$id?>";
function changeFrameHeight(){
var ifm= document.getElementById("iframepage");
ifm.height=document.documentElement.clientHeight;
}
window.οnresize=function(){
changeFrameHeight();
}
</script>
<form name="crm_form" method="post" enctype="multipart/form-data">
<?php
$id = intval($_GET["id"]);
//echo "2";
?>
<div id='navReg'>
<div class='title'><a href='../index.php' > 产品管理</a> > <a href="DetailView2.php?op_id=000&id=<?=$id?>" target="_blank" style="font-size:14px;">销售记录</a><span style="font-size:14px"> | </span><a href="#" style="font-size:14px">采购记录</a></div><div class='tips'></div></div>
<?
$NAVIG_LABELS[0] = _("产品管理");
$NAVIG_LABELS[1] = _("查看");
$NAVIG_LINGKS[0] = "../index.php";
$NAVIG_TIPS = "";
$MODULE_IMG = "crm_product.png";
//moduleNavigMessage($NAVIG_LABELS, $NAVIG_LINGKS, $NAVIG_TIPS,$MODULE_IMG);
//echo "1";
echo "<br>";
$xmlDocument = new xmlDocument();
$xmlDocument->loadFile("../template/tmpl.xml");
$info = $xmlDocument->parseLoad(TD::conn(),$id);
if (empty($info)) {
Message(_("警告"),_("记录不存在或已删除!"));
} else {
echo "<div class='wrapper'>";
include_once("./DetailHeader.php");
echo $xmlDocument->parseDetail($info);
echo "</div>";
include_once("./DetailFooter.php");
include("./DetailOperation.php");
include(G_CRM_PATH."/include/template/relation_tmpl.php");
}
?>
</form>
<div><?
$connstatus = ($connstatus) ? true : false;
$ITEMS_IN_PAGE=8;
if(!isset($start) || $start=="")
$start=0;
if(!$PAGE_SIZE)
$PAGE_SIZE=8;
$gongyingshang=$_REQUEST["gongyingshang"];
$query_str=" ";
if($gongyingshang!=""){
$query_str.=" and po.supplier_id_text like '%".$gongyingshang."%' ";
}
?>
<form enctype="multipart/form-data" action="DetailView.php?op_id=000&id=<?=$id?>" method="post" name="form2">
<table class="TableBlock" width="98%" align="center">
<TR>
<TD nowrap="nowrap" class="TableData">供应商名称:</TD>
<TD nowrap="nowrap" class="TableData"><input type="text" name="gongyingshang" size="40" maxlength="100" class="BigInput" value="<?=$gongyingshang?>" >
<input type="submit" value="<?=_("查询")?>" class="BigButton">
<input type="reset" value="<?=_("重填")?>" class="BigButton">
</TR>
</table>
</form><?
$query = "select p.product_name as product_name,
po.id as poid,po.purchase_name as purchase_name, po.supplier_id_text as gys,po.purchase_date as purchase_date,po.supplier_id as sid,
popl.price as price,popl.qty as qty,popl.total as total
from crm_product as p,crm_purchase_order as po,crm_purchase_order_products_list as popl
where p.id='$id' and p.id=popl.product_id and popl.main_id=po.id".$query_str." order by poid desc";
//echo $query."<br>";
$cursor= exequery(TD::conn(),$query, $connstatus);
$TOTAL_ITEMS=mysql_num_rows($cursor);
/*
if($TOTAL_ITEMS==0)
{
?>
<table border="0" width="98%" align="center" cellspacing="0" cellpadding="3" class="small" style="font-family:微软雅黑,宋体;">
<tr>
<td class="Big"><img src="<?=MYOA_STATIC_SERVER?>/static/images/notify_open.gif" align="absmiddle"><span class="big4"> <?=_("产品采购记录显示")?></span>
</td>
</tr>
</table>
<br>
<div style="font-family:微软雅黑,宋体">
<?
// Message("提示",_("暂无产品采购记录!!"));
// exit;
?>
</div>
<?
} */
?>
<?
foreach ($_POST as $key=> $value)
$QSTRING.=$key."=".$value."&";
$THE_FOUR_VAR = $QSTRING."start"; //page_bar($PAGE_START,$TOTAL_ITEMS,$PAGE_SIZE,"PAGE_START")
//page_bar($PAGE_START,$TOTAL_ITEMS,$PAGE_SIZE,$THE_FOUR_VAR)
//page_bar($PAGE_START,$TOTAL_ITEMS,$PAGE_SIZE,$THE_FOUR_VAR,$script_href=null,$direct_print=false,$show_total=0)
?>
<table border="0" width="98%" align="center" cellspacing="0" cellpadding="3" class="small" style="font-family:微软雅黑,宋体;">
<tr>
<td class="Big"><img src="<?=MYOA_STATIC_SERVER?>/static/images/notify_open.gif" align="absmiddle"><span class="big4"><?=_("产品采购记录显示")?></span> (每页8条)
</td>
<td align="right" valign="bottom" class="small1"><!--<?=sprintf(_("共%s条"), '<span class="big4"> '.$TOTAL_ITEMS.' </span>')?>-->
</td>
<td align="right" valign="bottom" class="small1">
<?=page_bar($start,$TOTAL_ITEMS,$PAGE_SIZE,$THE_FOUR_VAR,$script_href=null,$direct_print=false,$show_total=1)?>
<? //page_bar($PAGE_START,$TOTAL_ITEMS,$PAGE_SIZE,$THE_FOUR_VAR,$script_href=null,$direct_print=false,$show_total=1) ?>
</td>
</tr>
</table>
<?
$CUR_PAGE=$start/$PAGE_SIZE+1;
//echo $CUR_PAGE."<br>";
//============================ 显示已发布文件 =======================================
$query = "select p.product_name as product_name,
po.id as poid,po.purchase_name as purchase_name, po.supplier_id_text as gys,po.purchase_date as purchase_date,po.supplier_id as sid,
popl.price as price,popl.qty as qty,popl.total as total
from crm_product as p,crm_purchase_order as po,crm_purchase_order_products_list as popl
where p.id='$id' and p.id=popl.product_id and popl.main_id=po.id".$query_str." order by poid desc";
$query .= " limit $start,$ITEMS_IN_PAGE";
//echo $query."<br>";
?>
<table border="1px" cellpadding="0px" cellspacing="0px" width="98%" align="center" bordercolor="#eeeeee" style="font-size:12px">
<tr style="font-size:12px; font-weight:bold; height:30px; font-family:Arial Narrow,'Times New Roman', Times, serif; line-height:22px;" id="tr1">
<td align="center" nowrap bgcolor="#CCCCCC" style="cursor:hand;" width="15%">供应商名称</td>
<td align="center" nowrap bgcolor="#CCCCCC" style="cursor:hand;" width="15%">采购单价</td>
<td align="center" nowrap bgcolor="#CCCCCC" style="cursor:hand;" width="15%">订单名称 </td>
<td align="center" nowrap="nowrap" bgcolor="#CCCCCC" width="10%"><strong>数量</strong></td>
<td align="center" nowrap="nowrap" bgcolor="#CCCCCC" width="15%"><strong>合计</strong></td>
<td align="center" nowrap="nowrap" bgcolor="#CCCCCC" width="15%"><strong>采购日期</strong></td>
<td align="center" nowrap="nowrap" bgcolor="#CCCCCC" width="15%"><strong>操作</strong></td>
</tr>
<?
//$query = "SELECT * from attend_mobile order by M_ID DESC limit 500";
$cursor= exequery(TD::conn(),$query);
while($ROW=mysql_fetch_array($cursor))
{
$gys=$ROW["gys"];
$price=$ROW["price"];
$purchase_name=$ROW["purchase_name"];
$poid=$ROW["poid"];
$sid=$ROW["sid"];
$qty=$ROW["qty"];
$number=$ROW["number"];
$total=$ROW["total"];
$purchase_date=$ROW["purchase_date"]
?>
<tr height="30px;" onMouseOver="this.style.background='#F3F3F3'" onMouseOut="this.style.background='#FFFFFF'" class="tr2" onDblClick="javascript:open_file('<?=$id?>');">
<td align="center" nowrap="nowrap"> <a href="/general/crm/modules/Purchase/suppliers/DetailView/DetailView.php?op_id=000&id=<?=$sid?>" target="_blank"><?=$gys?></a> </td>
<td align="center" nowrap="nowrap"> <?=number_format($price,2)?></td>
<td align="center" nowrap="nowrap"><?=$purchase_name?></td>
<td align="center" nowrap="nowrap"><?=number_format($qty,2)?></td>
<td align="center" nowrap="nowrap"><?=number_format($total,2)?></td>
<td align="center" nowrap="nowrap"><?=date("Y-m-d",$purchase_date)?></td>
<td align="center" nowrap="nowrap" ><a href="/general/crm/modules/Purchase/purchaseOrder/DetailView/DetailView.php?op_id=000&id=<?=$poid?>" target="_blank">查看该采购订单</a></td>
</tr>
<?
}
?>
</table>
<iframe id="iframepage" src="DetailView3.php?op_id=000&id=<?=$id?>" width="100%" frameborder="0" scrolling="no" onLoad="changeFrameHeight()">
</iframe>
</div>
</body>
<script type="text/javascript" src="/<?=G_CRM_PATH?>/include/js/operation.js"></script>
</html>
<script src="./DetailExtend.js"></script>
iframe自适应高度的源代码
最新推荐文章于 2023-07-13 06:30:00 发布