function.php

<?php
	include_once "menu.php";
/*
	File: helloworld.php

	Test / example page demonstrating the basic xajax implementation.
	
	Title: Hello world sample page.
	
	Please see <copyright.inc.php> for a detailed description, copyright
	and license information.
*/

/*
	@package xajax
	@version $Id: helloworld.php 362 2007-05-29 15:32:24Z calltoconstruct $
	@copyright Copyright (c) 2005-2006 by Jared White & J. Max Wilson
	@license http://www.xajaxproject.org/bsd_license.txt BSD License
*/

/*
	Section: Standard xajax startup
	
	- include <xajax.inc.php>
	- instantiate main <xajax> object
*/
require ('./xajax_core/xajax.inc.php');
$xajax = new xajax();

/*
	- enable deubgging if desired
	- set the javascript uri (location of xajax js files)
*/
//$xajax->configure('debug', true);
$xajax->configure('javascript URI', './');


$tfoot[1002]=$tableD.'
<thead>
	<tr>
	<td class="style2">분류</td>
	<td class="style2">고객명</td>
	<td class="style2">현금</td>
	<td class="style2">현금영수증</td>
	<td class="style2">카드</td>
	<td class="style2">미납(통장)</td>
	<td class="style2" style="width:100px;">&nbsp;&nbsp;합계&nbsp;&nbsp;</td>
	<td class="style2">비고</td>
	<td class="style2"></td>
	</tr>
</thead>
<tfoot><input type="hidden" name="no" id="no" value="" >
<tr><input type="hidden" name="sale_code" id="sale_code" value="1002" >
<input type="hidden" name="insu_code" id="insu_code" value="-" >
<input type="hidden" name="rmst_code" id="rmst_code" value="-" >
<input type="hidden" name="rmdy_doct" id="rmdy_doct" value="-" >
<td class="tdStyle">
<input type="text" name="slit_code" id="slit_code" Onkeydown="CheckEnter(this)" class="clist">
</td>
<td class="tdStyle"><input type="text" name="customer" id="customer" size="7" Onkeydown="CheckEnter(this)" ></td>
<td class="tdStyle"><input type="text" name="cash" id="cash" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle"><input type="text" name="cash_r" id="cash_r" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle"><input type="text" name="card" id="card" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle"><input type="text" name="nopay" id="nopay" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle" id="sum" name="sum"></td>
<td class="tdStyle"><input type="text" name="etc" id="etc" size="5" Onkeydown="CheckEnter(this)" ></td>
<td class="tdStyle"><input type="button" id="ipBt" name="ipBt" onclick="CheckCont()" value="저장" ></td>
</tr>
</tfoot>
</table>';

$thead[1001]=$tableD.'
<thead>
	<tr>
	<!--<td class="style2">일자</td>-->
	<td class="style2">분류</td>
	<td class="style2">구분</td>
	<td class="style2">주요진단명</td>
	<td class="style2">진료실</td>
	<td class="style2">고객명</td>
	<td class="style2" style="width:100px;">현금</td>
	<td class="style2">현금영수증</td>
	<td class="style2">카드</td>
	<td class="style2">미납(통장)</td>
	<td class="style2">&nbsp;&nbsp;합계&nbsp;&nbsp;</td>
	<td class="style2">비고</td>
	<td class="style2"></td>
	</tr>
</thead>';

// 반복되는 구조 변수
$thead[1002]=$tableD.'
<thead>
	<tr>
	<td class="style2">분류</td>
	<td class="style2">고객명</td>
	<td class="style2" style="width:100px;">현금</td>
	<td class="style2">현금영수증</td>
	<td class="style2">카드</td>
	<td class="style2">미납(통장)</td>
	<td class="style2" width="70px;">&nbsp;&nbsp;합계&nbsp;&nbsp;</td>
	<td class="style2">비고</td>
	<td class="style2"></td>
	</tr>
</thead>';

$tfoot[1001]=$tableD.'
<thead>
	<tr>
	<td class="style2">분류</td>
	<td class="style2">구분</td>
	<td class="style2">주요진단명</td>
	<td class="style2">진료실</td>
	<td class="style2">고객명</td>
	<td class="style2">현금</td>
	<td class="style2">현금영수증</td>
	<td class="style2">카드</td>
	<td class="style2">미납(통장)</td>
	<td class="style2" style="width:100px;">&nbsp;&nbsp;합계&nbsp;&nbsp;</td>
	<td class="style2">비고</td>
	<td class="style2"></td>
	</tr>
</thead>
<tfoot><input type="hidden" name="no" id="no" value="" >
<tr><input type="hidden" name="sale_code" id="sale_code" value="1001" >
<td class="tdStyle">
<input type="text" name="slit_code" id="slit_code" Onkeydown="CheckEnter(this)" class="clist">
</td>
<td class="tdStyle">
<input type="text" name="insu_code" id="insu_code" Onkeydown="CheckEnter(this)" class="clist">
</td>
<td class="tdStyle">
<input type="text" name="rmst_code" id="rmst_code" Onkeydown="CheckEnter(this)" size="14" class="style1">
</td>
<td class="tdStyle">
<input type="text" name="rmdy_doct" id="rmdy_doct" Onkeydown="CheckEnter(this)" class="clist">
</td>
<td class="tdStyle"><input type="text" name="customer" id="customer" size="7" Onkeydown="CheckEnter(this)" ></td>
<td class="tdStyle"><input type="text" name="cash" id="cash" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle"><input type="text" name="cash_r" id="cash_r" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle"><input type="text" name="card" id="card" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle"><input type="text" name="nopay" id="nopay" size="7" onkeypress="Keycode(event,this);" Onkeydown="CheckEnter(this)" onkeyup="SumAmount(this);" style="ime-mode:disabled"></td>
<td class="tdStyle" id="sum" name="sum"></td>
<td class="tdStyle"><input type="text" name="etc" id="etc" size="5" Onkeydown="CheckEnter(this)" ></td>
<td class="tdStyle"><input type="button" onclick="CheckCont()" value="저장" id="ipBt" name="ipBt"></td>
</tr>
</tfoot>
</table>';

//메뉴
function menu($sale_code){
	global $tabColor,$extColor,$thColor, $acc;
	$style[1000]=' style="width:4%;background-color:'.$extColor.';"';
	$style[1001]=' style="width:48%;background-color:'.$extColor.';"';
	$style[1002]=' style="width:48%;background-color:'.$extColor.';"';
	$sCol[1001]='color:#FFFFFF;';
	$sCol[1002]='color:#FFFFFF;';
	$sCol[$sale_code]='color:'.$thColor.';';
//	$style[$sale_code]=' style="font-weight: bolder;background-color:'.$tabColor.';"';
	$selClass[$sale_code]='  class="tabS"';
	$menuTab='<table border="0" cellspacing="0" cellpadding="0" style="width:100%">
		  <tr>
			<td height="30" align="center"'.$style[1000].'></td>';
			
	if($acc['skin']){
		$menuTab=$menuTab.'<td height="30" align="center"'.$style[1001].'><div '.$selClass[1001].'><a href="#" onclick="document.location.replace(\'pay.php?sale_code=1001\')"><span style="'.$sCol[1001].'">일수입(피부과)</span></a></div></td>';
	}
	if($acc['cos']){
		$menuTab=$menuTab.'<td height="30" align="center"'.$style[1002].'><div '.$selClass[1002].'><a href="pay.php?sale_code=1002"><span style="'.$sCol[1002].'">일수입(코스메틱)<span></a></div></td>'; // 코스메틱 탭
	}
			
	$menuTab=$menuTab.'
		  </tr>	
		</table>';

	return $menuTab;
}
/*
	Function: parent
	
	parent
*/
function parent($sale_code){
	global $thead, $tfoot, $connect, $menu;
	$objResponse = new xajaxResponse();
	if(session_is_registered('reg_date')){
		$date_input=$_SESSION['session_reg_date'];//session에 저장된 날짜를 이용함.
		$setTime=substr($date_input,0,4);
		$setTime=$setTime."-".substr($date_input,4,2);
		$setTime=$setTime."-".substr($date_input,6,2);
	}else{
		$cTime=time();
		$setTime=date("Y-m-d",$cTime);
		$date_input=str_replace("-","",$setTime);// '-' 제거
	}
	$updated=selectSale($sale_code,$date_input,$date_input);
	$objResponse->assign('date_input', 'value', $setTime);

	$selSql="SELECT * FROM `toto_closedsale` where `reg_date` = ".$date_input;
	$result = mysql_query($selSql, $connect); 
	$rows = mysql_fetch_row($result);
	if($rows[30]=="Y"){
		$objResponse->assign('ipBt', 'disabled', TRUE);
		$objResponse->assign('ipBt', 'value', '마감됨');
	}else{
		$objResponse->assign('ipBt', 'disabled', FALSE);
		$objResponse->assign('ipBt', 'value', '저장');
	}
	$objResponse->assign('content', 'innerHTML', $updated);
	$objResponse->assign('menu', 'innerHTML', $menu);
	$msg=$_SESSION['sunap']."님은 ".$setTime."일자 자료입력 중입니다.";
	$objResponse->assign('msgDiv', 'innerHTML', $msg);
	$objResponse->assign('tabs2', 'innerHTML', menu($sale_code));
	$objResponse->call('pp');

	return $objResponse;
}
/*
	Function: editBt
	
	editBt
*/
function editBt($no,$sale_code)
{
	global $thead, $tfoot, $connect,$tableD;
	$objResponse = new xajaxResponse();
	$selSql="select * from toto_pay where `no` = ".$no;
	$result = mysql_query($selSql, $connect); 
	$row = mysql_fetch_row($result);
	$query="SELECT * FROM `toto_payc` order by `rmst_name` asc";
   	$resultC = mysql_query($query, $connect); 
	$totalC = mysql_num_rows($resultC); // 총 레코드 수
	$numC=0;
	while($totalC--){
		$numC++;
	$rowc = mysql_fetch_row($resultC);
		if($rowc[1]==$row[4]){
			if($numC<10)
				$no='0'.$numC;
			else
				$no=$numC;
			$row[4]=$no.". ".$rowc[2];
		}
	}

	$query="SELECT * FROM `toto_code` where `cate`='slit_code' order by `name` asc";
   	$resultC = mysql_query($query, $connect); 
	$totalC = mysql_num_rows($resultC); // 총 레코드 수
	$numC=0;
	while($totalC--){
		$numC++;
	$rowc = mysql_fetch_row($resultC);
		if($rowc[1]==$row[2]){
			if($numC<10)
				$no='0'.$numC;
			else
				$no=$numC;
			$row[2]=$no.". ".$rowc[2];
		}
	}

	$query="SELECT * FROM `toto_code` where `cate`='insu_code' order by `name` asc";
   	$resultC = mysql_query($query, $connect); 
	$totalC = mysql_num_rows($resultC); // 총 레코드 수
	$numC=0;
	while($totalC--){
		$numC++;
	$rowc = mysql_fetch_row($resultC);
		if($rowc[1]==$row[3]){
			if($numC<10)
				$no='0'.$numC;
			else
				$no=$numC;
			$row[3]=$no.". ".$rowc[2];
		}
	}

	$query="SELECT * FROM `toto_doctor` order by `doct_name` asc";
   	$resultC = mysql_query($query, $connect); 
	$totalC = mysql_num_rows($resultC); // 총 레코드 수
	$numC=0;
	while($totalC--){
		$numC++;
	$rowc = mysql_fetch_row($resultC);
		if($rowc[1]==$row[5]){
			if($numC<10)
				$no='0'.$numC;
			else
				$no=$numC;
			$row[5]=$no.". ".$rowc[2];
		}
	}

	$objResponse->assign('no', 'value', $row[0]);
	$objResponse->assign('sale_code', 'value', $row[1]);
	$objResponse->assign('slit_code', 'value', $row[2]);
	$objResponse->assign('insu_code', 'value', $row[3]);
	$objResponse->assign('rmst_code', 'value', $row[4]);
	$objResponse->assign('rmdy_doct', 'value', $row[5]);
	$objResponse->assign('customer', 'value', $row[7]);
	$objResponse->assign('cash', 'value', comma($row[8]));
	$objResponse->assign('cash_r', 'value', comma($row[9]));
	$objResponse->assign('card', 'value', comma($row[10]));
	$objResponse->assign('nopay', 'value', comma($row[11]));
	$objResponse->assign('sum', 'innerHTML', comma($row[8]+$row[9]+$row[10]+$row[11]));
	$objResponse->assign('etc', 'value', $row[16]);

	$reg_date=substr($row[14],0,4);
	$reg_date=$reg_date."-".substr($row[14],4,2);
	$reg_date=$reg_date."-".substr($row[14],6,2);
	$objResponse->assign('date_input', 'value', $reg_date);
//	$objResponse->assign('div2', 'innerHTML', $query);
	$objResponse->call('ttop');//div scolling
	return $objResponse;
}
/*
	Function: preview
	
	preview
*/
function preview($start_date,$end_date){
	global $thead, $tfoot, $connect;
	$objResponse = new xajaxResponse();
	$updated='<div style="width:400px;height:40px;text-align:right;background-color:white;"><br /><a href="#" onclick="previewH();">닫기 X</a><br /></div><table border="1" style="text-align:center;width:400px;background-color:white;">';
	$updated=$updated.'<tr>
	<td class="style2">카테고리</td>
	<td class="style2">항목</td>
	<td class="style2">합계</td>
	</tr>';
	
	$start_date=str_replace("-","",$start_date);// '-' 제거
	$end_date=str_replace("-","",$end_date);// '-' 제거

	//보험
	$selSql="select `cash_mony`,`cscd_mony`,`card_mony`,`yet__mony` from toto_pay where `sale_code` = '1001' and `insu_code` = '0101' and `reg_date` between '".$start_date."' and '".$end_date."'";
	$result = mysql_query($selSql, $connect); 
	$total = mysql_num_rows($result); // 총 레코드 수
	$num=$total;
while($total--){
	$row = mysql_fetch_row($result);
	$sum_cash=$sum_cash+$row[0];
	$sum_cscd=$sum_cscd+$row[1];
	$sum_card=$sum_card+$row[2];
	$sum_yet=$sum_yet+$row[3];
}
	$sum_ins=$sum_cash+$sum_cscd+$sum_card+$sum_yet;
	$updated=$updated.'<tr>
	<td class="tdStyle">보험</td>
	<td class="tdStyle">현금</td>
	<td class="tdStyle">'.comma($sum_cash).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">보험</td>
	<td class="tdStyle">현금영수증</td>
	<td class="tdStyle">'.comma($sum_cscd).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">보험</td>
	<td class="tdStyle">카드</td>
	<td class="tdStyle">'.comma($sum_card).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">보험</td>
	<td class="tdStyle">미납</td>
	<td class="tdStyle">'.comma($sum_yet).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="summ">보험</td>
	<td class="summ">소계</td>
	<td class="summ">'.comma($sum_ins).'</td>
	</tr>';

	//일반
	$selSql="select `cash_mony`,`cscd_mony`,`card_mony`,`yet__mony` from toto_pay where `sale_code` = '1001' and `insu_code` = '0102' and `reg_date` between '".$start_date."' and '".$end_date."'";
	$result = mysql_query($selSql, $connect); 
	$total = mysql_num_rows($result); // 총 레코드 수
	$num=$total;
	$sum_cash=0;
	$sum_cscd=0;
	$sum_card=0;
	$sum_yet=0;
while($total--){
	$row = mysql_fetch_row($result);
	$sum_cash=$sum_cash+$row[0];
	$sum_cscd=$sum_cscd+$row[1];
	$sum_card=$sum_card+$row[2];
	$sum_yet=$sum_yet+$row[3];
}
	$sum_nin=$sum_cash+$sum_cscd+$sum_card+$sum_yet;
	$updated=$updated.'<tr>
	<td class="tdStyle">일반</td>
	<td class="tdStyle">현금</td>
	<td class="tdStyle">'.comma($sum_cash).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">일반</td>
	<td class="tdStyle">현금영수증</td>
	<td class="tdStyle">'.comma($sum_cscd).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">일반</td>
	<td class="tdStyle">카드</td>
	<td class="tdStyle">'.comma($sum_card).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">일반</td>
	<td class="tdStyle">미납</td>
	<td class="tdStyle">'.comma($sum_yet).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="summ">일반</td>
	<td class="summ">소계</td>
	<td class="summ">'.comma($sum_nin).'</td>
	</tr>';

//진료실
	$docSql="select * from toto_doctor order by `no` asc";
	$docRes = mysql_query($docSql, $connect); 
	$docTot = mysql_num_rows($docRes); // 총 레코드 수
	$docNum=$docTot;
	$totSum=0;
	while($docTot--){
		$totSum=0;
		$docRow = mysql_fetch_row($docRes);
		$sumSql="SELECT SUM( cash_mony+cscd_mony+card_mony+yet__mony ) FROM  `toto_pay` WHERE `reg_date` =  '".$start_date."' AND `rmdy_doct` = '".$docRow[1]."' AND `sale_code` = '1001'";
		$sumRes = mysql_query($sumSql, $connect);
		$totSum = mysql_fetch_row($sumRes);

		$updated=$updated.'<tr>
		<td class="tdStyle">진료실</td>
		<td class="tdStyle">'.$docRow[2].'</td>
		<td class="tdStyle">'.comma($totSum[0]).'</td>
		</tr>';
	}
	$updated=$updated.'<tr>
	<td class="summ">진료실</td>
	<td class="summ">소계</td>
	<td class="summ">'.comma($sum_ins+$sum_nin).'</td>
	</tr>';

	//코스메틱
	$selSql="select `cash_mony`,`cscd_mony`,`card_mony`,`yet__mony` from toto_pay where `sale_code` = '1002' and `reg_date` between '".$start_date."' and '".$end_date."'";
	$result = mysql_query($selSql, $connect); 
	$total = mysql_num_rows($result); // 총 레코드 수
	$num=$total;
	$sum_cash=0;
	$sum_cscd=0;
	$sum_card=0;
	$sum_yet=0;
while($total--){
	$row = mysql_fetch_row($result);
	$sum_cash=$sum_cash+$row[0];
	$sum_cscd=$sum_cscd+$row[1];
	$sum_card=$sum_card+$row[2];
	$sum_yet=$sum_yet+$row[3];
}
	$updated=$updated.'<tr>
	<td class="tdStyle">코스메틱</td>
	<td class="tdStyle">현금</td>
	<td class="tdStyle">'.comma($sum_cash).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">코스메틱</td>
	<td class="tdStyle">현금영수증</td>
	<td class="tdStyle">'.comma($sum_cscd).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">코스메틱</td>
	<td class="tdStyle">카드</td>
	<td class="tdStyle">'.comma($sum_card).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="tdStyle">코스메틱</td>
	<td class="tdStyle">미납</td>
	<td class="tdStyle">'.comma($sum_yet).'</td>
	</tr>';
	$updated=$updated.'<tr>
	<td class="summ">코스메틱</td>
	<td class="summ">소계</td>
	<td class="summ">'.comma($sum_cash+$sum_cscd+$sum_card+$sum_yet).'</td>
	</tr>';

	$updated=$updated.'</table>';
	$objResponse->assign('pdiv', 'innerHTML', $updated);
//	$objResponse->assign('div2', 'innerHTML', $selSql);
	$objResponse->call('preview');
	return $objResponse;
}
/*
	Function: inquiry
	
	inquiry
*/
function inquiry($sale_code,$start_date,$end_date)
{
	global $thead, $tfoot, $connect;
	$objResponse = new xajaxResponse();
	$query="inquiry".$sale_code;
	$setTime=$start_date;
	$start_date=str_replace("-","",$start_date);// '-' 제거
	$end_date=str_replace("-","",$end_date);// '-' 제거
	$updated=selectSale($sale_code,$start_date,$end_date);
	$inputDiv=$tfoot[$sale_code];

	$selSql="SELECT * FROM `toto_closedsale` where `reg_date` = ".$start_date;
	$result = mysql_query($selSql, $connect); 
	$rows = mysql_fetch_row($result);
	$objResponse->call('fr.reset()');
	if($rows[30]=="Y"){
		$objResponse->assign('ipBt', 'disabled', TRUE);
		$objResponse->assign('ipBt', 'value', '마감됨');
	}else{
		$objResponse->assign('ipBt', 'disabled', FALSE);
		$objResponse->assign('ipBt', 'value', '저장');
	}
//	$objResponse->assign('div2', 'innerHTML', $rows[30]);
	$msg=$_SESSION['sunap']."님은 ".$setTime."일자 자료입력 중입니다.";
	$objResponse->assign('msgDiv', 'innerHTML', $msg);
	$objResponse->assign('content', 'innerHTML', $updated);
	$objResponse->call('bottom');//div scolling
	return $objResponse;
}

/*
	Function: selectSale
	
	seclectSale
*/
function selectSale($saleCode,$start_date,$end_date)
{
	global $thead, $tfoot,$connect, $acc;

	session_register("reg_date");
	$_SESSION['session_reg_date']=$start_date;

	$selSqlC="SELECT * FROM `toto_closedsale` where `reg_date` = ".$start_date;
	$resultC = mysql_query($selSqlC, $connect); 
	$rowc = mysql_fetch_row($resultC);//마감 여부

//모두 보기 권한이 없을 경우 자신이 입력한 내용만 볼 수 있다.2011-03-30
if(!$acc['all']){
	$addCond=" and `reg_user` = '".$_SESSION['sunap']."'";
}
	$selSql="select * from toto_pay where `sale_code` = '".$saleCode."' and `reg_date` between '".$start_date."' and '".$end_date."'".$addCond." order by `no` desc";
	$result = mysql_query($selSql, $connect); 
	$total = mysql_num_rows($result); // 총 레코드 수
	$num=$total;
	$updated=$thead[$saleCode].'<tbody>';
while($total--){
	$row = mysql_fetch_row($result);
	switch($row[2]){
		case "2001" :
			$row[2]="매출";
			break;
		case "2002" :
			$row[2]="외상입금";
			break;
		case "2003" :
			$row[2]="환불";
			break;
	}
	switch($row[3]){
		case "0101" :
			$row[3]="보험";
			break;
		case "0102" :
			$row[3]="일반";
			break;
	}
	
	$selSql2="select `rmst_name` from toto_payc where `rmst_code` = '".$row[4]."'";
	$result2 = mysql_query($selSql2, $connect); 
	$row2 = mysql_fetch_row($result2);
	$row[4]=$row2[0];

	$query="SELECT `doct_name` FROM `toto_doctor` where `doct_numb`='".$row[5]."'";
   	$resultC = mysql_query($query, $connect); 
	$rowc = mysql_fetch_row($resultC);
	$row[5]=$rowc[0];

	$row[15]=date("m/j",$row[15]);//실제 입력일
	$sum=$row[8]+$row[9]+$row[10]+$row[11];
	$sum_cash=$row[8]+$sum_cash;
	$sum_cscd=$row[9]+$sum_cscd;
	$sum_card=$row[10]+$sum_card;
	$sum_yet=$row[11]+$sum_yet;
	$reg_date=substr($row[14],2,2);
	$reg_date=$reg_date."/".substr($row[14],4,2);
	$reg_date=$reg_date."/".substr($row[14],6,2);
	if(($num-$total)%5){
		$ts="tdStyle";
	}else{
		$ts="fifthStyle";
	}
	$updated=$updated.'<tr>
	<!--<td class="'.$ts.'">'.$reg_date.'</td>-->
	<td class="'.$ts.'">'.$row[2].'</td>';

if($saleCode=="1001"){
	$updated=$updated.'<td class="'.$ts.'">'.$row[3].'</td>
	<td class="'.$ts.'">'.$row[4].'</td>
	<td class="'.$ts.'">'.$row[5].'</td>';
	}

	$updated=$updated.'<td class="'.$ts.'">'.$row[7].'</td>
	<td class="'.$ts.'">'.comma($row[8]).'</td>
	<td class="'.$ts.'">'.comma($row[9]).'</td>
	<td class="'.$ts.'">'.comma($row[10]).'</td>
	<td class="'.$ts.'">'.comma($row[11]).'</td>
	<td class="'.$ts.'">'.comma($sum).'</td>
	<td class="'.$ts.'">'.$row[16].'</td>';

	if($rowc[30]!="Y"){
		$updated=$updated.'<td class="'.$ts.'"><input type="button" value="E" onclick="xajax_editBt('.$row[0].','.$row[1].')" style="width:30px;"><input type="button" value="D" onclick="xajax_deleteId('.$row[0].','.$row[1].', xajax.$(\'date_input\').value,xajax.$(\'date_input\').value)" style="width:30px;"></td>';
	}else{
		$updated=$updated.'<td>마감(요청)</td>';
	}

	
	$updated=$updated.'</tr>';

	}
	if($num==0){
		$updated=$updated.'<tr><td colspan="12">자료가 없습니다</td></tr>';
	}else{
		if($saleCode==1001){
			$updated=$updated.'<tr>
				<td class="summ">합계</td>
				<td class="summ">-</td>
				<td class="summ">-</td>
				<td class="summ">-</td>
				<td class="summ">-</td>
				<td class="summ">'.comma($sum_cash).'</td>
				<td class="summ">'.comma($sum_cscd).'</td>
				<td class="summ">'.comma($sum_card).'</td>
				<td class="summ">'.comma($sum_yet).'</td>
				<td class="summ">'.comma($sum_cash+$sum_cscd+$sum_card+$sum_yet).'</td>
				<td class="summ">-</td>
				<td class="summ">-</td>
			</tr>';
		}else{
			$updated=$updated.'<tr>
				<td class="summ">합계</td>
				<td class="summ">-</td>
				<td class="summ">'.comma($sum_cash).'</td>
				<td class="summ">'.comma($sum_cscd).'</td>
				<td class="summ">'.comma($sum_card).'</td>
				<td class="summ">'.comma($sum_yet).'</td>
				<td class="summ">'.comma($sum_cash+$sum_cscd+$sum_card+$sum_yet).'</td>
				<td class="summ">-</td>
				<td class="summ">-</td>
			</tr>';
		}
	}
	$updated=$updated.'</tbody></table>';
	return $updated;
}
/*
	Function: deleteId
	
	delete
*/
function deleteId($id,$saleCode,$date_start,$date_end)
{
	global $thead, $tfoot, $connect;
	$objResponse = new xajaxResponse();
	$query="delete from `toto_pay` where `no`=".$id;
	$execQue = mysql_query($query, $connect);

	$date_start=str_replace("-","",$date_start);// '-' 제거
	$date_end=str_replace("-","",$date_end);// '-' 제거
	$updated=selectSale($saleCode,$date_start,$date_end);
	$inputDiv=$tfoot[$saleCode];

//	$objResponse->assign('div2', 'innerHTML', $query.$date_start);
	$objResponse->assign('content', 'innerHTML', $updated);
//	$objResponse->assign('input', 'innerHTML', $inputDiv);
	$objResponse->call('bottom');//div scolling
	return $objResponse;
}


/*
	Function: savePay
	
	save
*/
function savePay($no,$sale_code,$slit_code,$insu_code,$rmst_code,$rmdy_doct,$cust_name,$cash_mony,$cscd_mony,$card_mony,$yet__mony,$slit_desc,$etc,$date_input)
{
	global $thead, $tfoot, $connect;
	$objResponse = new xajaxResponse();
	$c_time=time();
	$cust_cnum="111";
	$cash_mony=str_replace(",","",$cash_mony);// ',' 제거
	$cscd_mony=str_replace(",","",$cscd_mony);// ',' 제거
	$card_mony=str_replace(",","",$card_mony);// ',' 제거
	$yet__mony=str_replace(",","",$yet__mony);// ',' 제거
	$setTime=$date_input;
	$date_input=str_replace("-","",$date_input);// '-' 제거
	//자동완성기능을 쓸 경우 문자열->코드
	$ec=explode(". ",$slit_code);// 번호가 넘어오더라도, 번호 앞을 무시하고, 뒤만 참고하므로, 순서는 상관없다
	$query="SELECT `code` FROM `toto_code` WHERE `name` = '".$ec[1]."'";
   	$resultC = mysql_query($query, $connect); 
	$rowc = mysql_fetch_row($resultC);
	$slit_code=$rowc[0];

if($sale_code=="1001"){
	$ec=explode(". ",$rmst_code);// 번호가 넘어오더라도, 번호 앞을 무시하고, 뒤만 참고하므로, 순서는 상관없다
	$query="SELECT `rmst_code` FROM `toto_payc` WHERE `rmst_name` = '".$ec[1]."'";
   	$resultC = mysql_query($query, $connect); 
	$rowc = mysql_fetch_row($resultC);
	$rmst_code=$rowc[0];
	
	$ec=explode(". ",$insu_code);// 번호가 넘어오더라도, 번호 앞을 무시하고, 뒤만 참고하므로, 순서는 상관없다
	$query="SELECT `code` FROM `toto_code` WHERE `name` = '".$ec[1]."'";
   	$resultC = mysql_query($query, $connect); 
	$rowc = mysql_fetch_row($resultC);
	$insu_code=$rowc[0];

	$ec=explode(". ",$rmdy_doct);// 번호가 넘어오더라도, 번호 앞을 무시하고, 뒤만 참고하므로, 순서는 상관없다
	$query="SELECT `doct_numb` FROM `toto_doctor` WHERE `doct_name` = '".$ec[1]."'";
   	$resultC = mysql_query($query, $connect); 
	$rowc = mysql_fetch_row($resultC);
	$rmdy_doct=$rowc[0];
}
	if($no){
		$query="UPDATE `toto_pay` SET `sale_code` = '".$sale_code."', `slit_code` = '".$slit_code."', `insu_code` = '".$insu_code."', `rmst_code` = '".$rmst_code."', `rmdy_doct` = '".$rmdy_doct."', `cust_cnum` = '111', `cust_name` = '".$cust_name."', `cash_mony` = '".$cash_mony."', `cscd_mony` = '".$cscd_mony."', `card_mony` = '".$card_mony."', `yet__mony` = '".$yet__mony."', `slit_desc` = '', `sort_numb` = '', `reg_date` = '".$date_input."', `date` = '".$c_time."', `etc` = '".$etc."' WHERE `no` =".$no;
	}else{
		$query="INSERT INTO `toto_pay` (`no`, `sale_code`, `slit_code`, `insu_code`, `rmst_code`, `rmdy_doct`, `cust_cnum`, `cust_name`, `cash_mony`, `cscd_mony`, `card_mony`, `yet__mony`, `slit_desc`, `sort_numb`, `reg_date`, `date`, `etc`, `reg_user`) VALUES (NULL, '".$sale_code."', '".$slit_code."', '".$insu_code."', '".$rmst_code."', '".$rmdy_doct."', '".$cust_cnum."', '".$cust_name."', '".$cash_mony."', '".$cscd_mony."', '".$card_mony."', '".$yet__mony."', '".$slit_desc."', '".$sum."', '".$date_input."', '".$c_time."', '".$etc."','".$_SESSION['sunap']."');";
	}
    $saveQue = mysql_query($query, $connect);

	$updated=selectSale($sale_code,$date_input,$date_input);

	$objResponse->call('fr.reset()');
//	$objResponse->assign('div2', 'innerHTML', $query);
	$objResponse->assign('content', 'innerHTML', $updated);
	$objResponse->call('sFocus()');//div scolling
	
	return $objResponse;
}

/*
	Section:  Register functions
	
	- <savePay>
	- <deleteId>
	- <cosmetic>
	- <preview>
*/
$reqSavePayBtn =& $xajax->registerFunction('savePay');

$reqDelBtn =& $xajax->registerFunction('deleteId');

$reqInquiry =& $xajax->registerFunction('inquiry');

$reqPreview =& $xajax->registerFunction('preview');

$reqParent =& $xajax->registerFunction('parent');

$reqEditBt =& $xajax->registerFunction('editBt');
/*
	Section: processRequest
	
	This will detect an incoming xajax request, process it and exit.  If this is
	not a xajax request, then it is a request to load the initial contents of the page
	(HTML).
	
	Everything prior to this statement will be executed upon each request (whether it
	is for the initial page load or a xajax request.  Everything after this statement
	will be executed only when the page is first loaded.
*/
$xajax->processRequest();

echo '<?xml version="1.0" encoding="UTF-8"?>';
?>