查看文件: member_edit.php

大小: 7.65 KB

类型: application/octet-stream

<?php  require('system/login.php');  ?>
<?php require_once('../Connections/BE2.php'); ?>
<?php

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
   $write='';
   $cck='Y' ;
   $c='n'; 
   for($i=1;$i<11;$i++){
	   $c='N'; 
	   if(isset($_POST['ck'.$i]) && ($_POST['ck'.$i] =='Y')){ $c='Y';}
	   if($c=='N'){$cck='N' ;}
	  }

if($cck=='Y'){
 
   if($_POST['old_mem_check']<>'Y'){
    $upSQL = sprintf("UPDATE company SET mem_check='Y', ck_company='5' WHERE coid='%s'", $_POST['coid']);
    mysql_select_db($database_BE2, $BE2);
    $Result1 = mysql_query($upSQL, $BE2) or die(mysql_error());
   
    $upSQL1 = sprintf("UPDATE member SET mem_check='Y' WHERE mem_auto='%s'", $_POST['mid']);
    mysql_select_db($database_BE2, $BE2);
    $Result2 = mysql_query($upSQL1, $BE2) or die(mysql_error());
   
    $doc='系統審核已完成,感謝您的使用, SKYBNI 敬上.';
    $Ins_doc = sprintf("INSERT INTO guestdoc(guid,gdate,gsource,gdoc)VALUES('%s','%s','%s','%s')",$_POST['mid'],date('Y-m-d'),1,$doc);
    mysql_query($Ins_doc, $BE2) or die(mysql_error());
	
   //營業資料審核	
 
	  $mess='營業資料審核'; 
	  $InsertSQL = sprintf("INSERT INTO rec_step(rdoc,companyid,ostate,rstate,rdate,ruser)VALUES('%s','%s','%s','%s','%s','%s')",$mess, $_POST['mid'],'N','Y',date('Y-m-d'),$_SESSION['login_id']);
      mysql_select_db($database_BE2, $BE2);
      mysql_query($InsertSQL, $BE2) or die(mysql_error());
   }
	 
   
   $write='資料已更新...'; 
   
   
   } else{ $write='資料未更新...'; }
 
  $updateGoTo = $_POST["url"];
   
 // header(sprintf("Location: %s", $updateGoTo));
  echo  "<script>alert('".$write."');location.href='".$updateGoTo."';</script>";
  
}

$colname_Rt2 = "-1";
if (isset($_GET['id'])) {
  $colname_Rt2 = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_BE2, $BE2);
$query_Rt2 = sprintf("SELECT * FROM company WHERE coid = %s", $colname_Rt2);
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
?> 
<form method="post" name="form1" action="">
  <table width="485" align="center">
    <tr valign="baseline">
      <td width="144" align="right" nowrap><span class="s1"><span class="font2">營業資料審核</span>：</span></td>
      <td width="228"><?= $row_Rt2['mem_check']; ?></td>
      <td width="97">&nbsp;</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">註冊日期Idate：</td>
      <td> <?php echo $row_Rt2['co_time']; ?> </td>
      <td>&nbsp;</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">&nbsp;</td>
      <td><input type="hidden" id="mem_address" name="mem_address" value="<?php echo $row_Rt2['mem_address']; ?>" size="32" readonly="readonly" />
      <input type="hidden" id="old_mem_check" name="old_mem_check" value="<?php echo $row_Rt2['mem_check']; ?>" size="32" readonly="readonly" /></td>
      <td>&nbsp;</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">負責人姓名</td>
      <td><?=$row_Rt2['mem_user']; ?><input type="hidden" id="mid" name="mid" value="<?php echo $row_Rt2['mid']; ?>" />
      <input type="hidden" id="coid" name="coid" value="<?php echo $row_Rt2['coid']; ?>" /></td>
      
      <td nowrap="nowrap"><input name="ck1" type="checkbox" id="ck1" value="Y"  onclick="submit_ck()" />資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">營業項目</td>
      <td><?= $row_Rt2['company_card']; ?></td>
      <td><input type="checkbox" name="ck2" id="ck2" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">聯繫電話</td>
      <td><?= $row_Rt2['company_tel'];?></td>
      <td><input type="checkbox" name="ck3" id="ck3" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">統一編號</td>
      <td><?= $row_Rt2['company_code'];?></td>
      <td><input type="checkbox" name="ck4" id="ck4" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
 <tr valign="baseline">
      <td nowrap align="right">匯款帳號</td>
      <td><?= $row_Rt2['company_code2'];?></td>
      <td><input type="checkbox" name="ck5" id="ck5" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">公司名稱:</td>
      <td><?= $row_Rt2['company_name'] ; ?></td>
      <td><input type="checkbox" name="ck6" id="ck6" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">負責人身份証正面</td>
      <td>&nbsp;</td>
      <td><input type="checkbox" name="ck7" id="ck7" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">負責人身份証反面</td>
      <td>&nbsp;</td>
      <td><input type="checkbox" name="ck8" id="ck8" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">營業登記證</td>
      <td>&nbsp;</td>
      <td><input type="checkbox" name="ck9" id="ck9" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>   
    <tr valign="baseline">
      <td nowrap align="right">匯款存摺封面照片</td>
      <td>&nbsp;</td>
      <td><input type="checkbox" name="ck10" id="ck10" value="Y" onclick="submit_ck()"/>資料確定</td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">&nbsp;</td>
      <td><div id="btsubmit" ></div></td>
      <td>&nbsp;</td>
    </tr>
  </table>
  <input type="hidden" name="MM_update" value="form1">
  <input name="url" type="hidden" id="url" value="<?php echo $_SERVER['HTTP_REFERER']; ?>" />
</form>
    <div class="row">
  <div style="border-width:3px;border-style:dashed;border-color:#FFAC55;padding:5px;">     
  <?
  $s07=sprintf('%07d',$row_Rt2['mid']);
  if($row_Rt2['company_pic1']<>''){ ?>     
   <img name="img1" src="/logo_img/st_<?= $s07.'_1.'.$row_Rt2['company_pic1'] ?>" width="100%" alt="負責人身份証正面" /> 
    
  <? } ?> <div style="text-align:center;">負責人身份証正面</div>       
  </div> 
 
   <div style="border-width:3px;border-style:dashed;border-color:#FFAC55;padding:5px;">	     
    <? if($row_Rt2['company_pic3']<>''){ ?>     
   <img name="img4" src="/logo_img/st_<?= $s07.'_3.'.$row_Rt2['company_pic3'] ?>" width="100%" alt="負責人身份証反面" /> 
     
  <? } ?> <div style="text-align:center;">負責人身份証反面</div>      
  </div> 
    
 <div style="border-width:3px;border-style:dashed;border-color:#FFAC55;padding:5px;">
 <? if($row_Rt2['company_pic4']<>''){ ?>     
   <img name="img4" src="/logo_img/st_<?= $s07.'_4.'.$row_Rt2['company_pic4'] ?>" width="100%" alt="匯款存摺封面照片" />
      
  <? } ?> <div style="text-align:center;">匯款存摺封面照片</div>  
  </div>  
 
  <div style="border-width:3px;border-style:dashed;border-color:#FFAC55;padding:5px;">     
     <? if($row_Rt2['company_pic2']<>''){ ?>     
   <img name="img4" src="/logo_img/st_<?= $s07.'_2.'.$row_Rt2['company_pic2'] ?>" width="100%" alt="營業登記證" />     
   
  <? } ?> <div style="text-align:center;">營業登記證</div>   
  </div>  
  
  </div> 
<?php
mysql_free_result($Rt2);
?>
<script type="text/javascript">