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);
// '-' 제거
if ($no) {
$query = "UPDATE `pearl_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 `pearlclinic`.`pearl_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`) 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 . "');";
}
$saveQue = mysql_query($query, $connect);
$updated = selectSale($sale_code, $date_input, $date_input);
$inputDiv = $tfoot[$sale_code];
// $objResponse->assign('div2', 'innerHTML', $query);
$objResponse->assign('content', 'innerHTML', $updated);
$objResponse->assign('input', 'innerHTML', $inputDiv);
$objResponse->call('bottom');
//div scolling
return $objResponse;
}
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;
}
function inquiry($sale_code, $end_date)
{
global $menu2, $thead, $menu, $extColor, $tabColor, $thColor;
$objResponse = new xajaxResponse();
$style[1000] = ' style="width:4%;background-color:' . $extColor . ';"';
$selTab[11001] = ' style="width:24%;"';
$selTab[11002] = ' style="width:24%;"';
$selTab[1001] = ' style="width:24%;"';
$selTab[1002] = ' style="width:24%;"';
// $selTab[$exps_code]=' style="font-weight: bolder;background-color:'.$tabColor.';width:24%;"';
$selClass[$sale_code] = ' class="tabS"';
$sCol[11001] = 'color:#FFFFFF;';
$sCol[11002] = 'color:#FFFFFF;';
$sCol[1001] = 'color:#FFFFFF;';
$sCol[1002] = 'color:#FFFFFF;';
$sCol[$sale_code] = 'color:' . $thColor . ';';
$setTime = $end_date;
if (session_is_registered('reg_date')) {
$date_input = str_replace("-", "", $end_date);
// '-' 제거
$_SESSION['session_reg_date'] = $date_input;
}
$menuDiv = '<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center"' . $style[1000] . '></td>
<td width="150" height="30" align="center" ' . $selTab[11001] . '><div ' . $selClass[11001] . '><a href="report.php"><span style="' . $sCol[11001] . '">일매출전체(피부과)</span></a></div></td>
<td width="150" height="30" align="center" ' . $selTab[1001] . '><div ' . $selClass[1001] . '><a href="#" onclick="xajax_inquiry(1001,\'' . $end_date . '\')"><span style="' . $sCol[1001] . '">일매출병원(피부과)</span></a></div></td>
<td width="150" height="30" align="center" ' . $selTab[11002] . '><div ' . $selClass[11002] . '><a href="#" onclick="xajax_inquiry(11002,\'' . $end_date . '\')"><span style="' . $sCol[11002] . '">일매출병원(코스메틱)</span></a></div></td>
<td width="150" height="30" align="center" ' . $selTab[1002] . '><div ' . $selClass[1002] . '><a href="#" onclick="xajax_inquiry(1002,\'' . $end_date . '\')"><span style="' . $sCol[1002] . '">일매출전체(코스메틱)</span></a></div></td>
<td width="100" height="30" align="center" class="box_Bottomline"> </td>
</tr>
</table>';
$m = substr($end_date, 5, 2);
$start_date = date("Y-m-d", mktime(0, 0, 0, $m, 1, substr($end_date, 0, 4)));
$query = "inquiry" . $start_date . $end_date . ' ' . $m;
$objResponse->assign('date_start', 'value', $start_date);
$objResponse->assign('date_end', 'value', $end_date);
$objResponse->assign('sale_code', 'value', $sale_code);
$start_date = str_replace("-", "", $start_date);
// '-' 제거
$end_date = str_replace("-", "", $end_date);
// '-' 제거
if ($sale_code > 10000) {
$updated = $thead[$sale_code] . '<tbody>';
$sale_code = $sale_code - 10000;
$updated = $updated . selectAll($sale_code, $start_date, $end_date) . '</table>';
} else {
$updated = selectSale($sale_code, $start_date, $end_date) . '</table>';
}
// $objResponse->assign('div2', 'innerHTML', $date_input);
$objResponse->assign('content', 'innerHTML', $updated);
$objResponse->call('bottom');
//div scolling
$objResponse->assign('menu', 'innerHTML', $menu);
$msg = $_SESSION['sunap'] . "님은 " . $setTime . "일자 자료입력 중입니다.";
$objResponse->assign('msgDiv', 'innerHTML', $msg);
$objResponse->assign('tabs2', 'innerHTML', $menuDiv);
return $objResponse;
}
function savePay($no, $exps_code, $exps_gubn, $exps_cate, $exps_cust, $exps_caus, $cash_mony, $reg_date, $etc)
{
global $thead, $tfoot, $theadE, $tfootE, $connect;
$objResponse = new xajaxResponse();
$c_time = time();
$date_input = str_replace("-", "", $reg_date);
// '-' 제거
$cash_mony = str_replace(",", "", $cash_mony);
// ',' 제거
//자동완성기능을 쓸 경우 문자열->코드
if ($exps_code == 4000) {
$ec = explode(". ", $exps_cate);
$query = "SELECT `exps_cate` FROM `pearl_expc` WHERE `exps_name` = '" . $ec[1] . "'";
$resultC = mysql_query($query, $connect);
$rowc = mysql_fetch_row($resultC);
$exps_cate = $rowc[0];
}
$exps_cust = htmlspecialchars($exps_cust);
$exps_caus = htmlspecialchars($exps_caus);
if ($no) {
$query = "UPDATE `pearl_exp` SET `exps_code` = '" . $exps_code . "', `exps_gubn` = '" . $exps_gubn . "', `exps_cate` = '" . $exps_cate . "',`exps_cust` = '" . $exps_cust . "',`exps_caus` = '" . $exps_caus . "',`reg_date` = '" . $date_input . "',`date` = '" . $c_time . "',`etc` = '" . $etc . "' WHERE `no` =" . $no;
} else {
$query = "INSERT INTO `pearl_exp` ( `no` , `exps_code` , `exps_gubn` , `exps_cate` , `exps_cust` , `exps_caus` , `cash_mony` , `reg_date` , `date` , `etc` ) VALUES ('', '" . $exps_code . "', '" . $exps_gubn . "', '" . $exps_cate . "', '" . $exps_cust . "', '" . $exps_caus . "', '" . $cash_mony . "', '" . $date_input . "', '" . $c_time . "', '" . $etc . "');";
}
$saveQue = mysql_query($query, $connect);
$inputDiv = $thead[$exps_code] . $tfoot[$exps_code] . '</table>';
$updated = $updated . selectSale($exps_code, $date_input, $date_input) . '</table>';
$objResponse->call('fr.reset()');
$objResponse->assign('div2', 'innerHTML', $query);
$objResponse->assign('content', 'innerHTML', $updated);
$objResponse->call('bottom');
//div scolling
return $objResponse;
}
function parent($exps_code, $date_input)
{
global $thead, $tfoot, $connect, $menu, $tabColor, $extColor, $thColor, $acc;
$objResponse = new xajaxResponse();
$setTime = $date_input;
$date_input = str_replace("-", "", $date_input);
// '-' 제거
if (session_is_registered('reg_date')) {
$_SESSION['session_reg_date'] = $date_input;
//세션에 저장
}
$date_start = date("Y-m-d", mktime(0, 0, 0, substr($date_input, 4, 2), 1, substr($date_input, 0, 4)));
$updated = selectSale($exps_code, $date_input, $date_input) . '</table>';
$style[1000] = ' style="width:4%;background-color:' . $extColor . ';"';
$selTab[4000] = ' style="width:24%;"';
$selTab[4001] = ' style="width:24%;"';
$selTab["inquery"] = ' style="width:24%;"';
// $selTab[$exps_code]=' style="font-weight: bolder;background-color:'.$tabColor.';width:24%;"';
$selClass[$exps_code] = ' class="tabS"';
$sCol[4001] = 'color:#FFFFFF;';
$sCol[4000] = 'color:#FFFFFF;';
$sCol[$exps_code] = 'color:' . $thColor . ';';
$menuDiv = '<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center"' . $style[1000] . '></td>';
if ($acc['skin']) {
$menuDiv = $menuDiv . '<td height="30" align="center" ' . $selTab[4000] . '><div ' . $selClass[4000] . '><a href="static.php?exps_code=4000"><span style="' . $sCol[4000] . '">일별지출(피부과)</span></a></div></td>';
}
if ($acc['cos']) {
$menuDiv = $menuDiv . '<td height="30" align="center" ' . $selTab[4001] . '><div ' . $selClass[4001] . '><a href="#" onclick="xajax_parent(4001,\'' . $setTime . '\')"><span style="' . $sCol[4001] . '">일별지출(코스메틱)</span></a></div></td>';
}
if ($acc['skin']) {
$menuDiv = $menuDiv . '<td height="30" align="center" ' . $selTab["inquery"] . '><a href="month.php?exps_code=4000"><span style="color:#FFFFFF">월별지출(피부과)</span></a></td>';
}
if ($acc['cos']) {
$menuDiv = $menuDiv . '<td height="30" align="center" ' . $selTab["inquery"] . '><a href="month.php?exps_code=4001"><span style="color:#FFFFFF">월별지출(코스메틱)</a></td>';
}
$menuDiv = $menuDiv . '<td width="100" height="30" align="center" class="box_Bottomline"> </td>
</tr>
</table>';
$objResponse->assign('exps_code', 'value', $exps_code);
$objResponse->assign('date_start', 'value', $setTime);
$objResponse->assign('date_end', 'value', $setTime);
$objResponse->assign('content', 'innerHTML', $updated);
$objResponse->assign('menu', 'innerHTML', $menu);
$objResponse->assign('tabs2', 'innerHTML', $menuDiv);
$msg = $_SESSION['sunap'] . "님은 " . $setTime . "일자 자료입력 중입니다.";
$objResponse->assign('msgDiv', 'innerHTML', $msg);
$objResponse->call('pp');
return $objResponse;
}
function savePay($no, $exps_code, $exps_gubn, $exps_cate, $exps_cust, $exps_caus, $cash_mony, $reg_date, $etc)
{
global $thead, $tfoot, $theadE, $tfootE, $connect, $_SESSION;
$objResponse = new xajaxResponse();
$c_time = time();
$date_input = str_replace("-", "", $reg_date);
// '-' 제거
$cash_mony = str_replace(",", "", $cash_mony);
// ',' 제거
//자동완성기능을 쓸 경우 문자열->코드
$ec = explode(". ", $exps_gubn);
// 번호가 넘어오더라도, 번호 앞을 무시하고, 뒤만 참고하므로, 순서는 상관없다
$queryC = "SELECT `code` FROM `toto_code` WHERE `name` = '" . $ec[1] . "' and `cate`='exps_gubn'";
$resultC = mysql_query($queryC, $connect);
$rowc = mysql_fetch_row($resultC);
$exps_gubn = $rowc[0];
$ec = explode(". ", $exps_cate);
// 번호가 넘어오더라도, 번호 앞을 무시하고, 뒤만 참고하므로, 순서는 상관없다
$query1 = "SELECT `exps_cate` FROM `toto_expc` WHERE `exps_name` = '" . $ec[1] . "' and `exps_code`='" . $exps_code . "'";
$resultC = mysql_query($query1, $connect);
$rowc = mysql_fetch_row($resultC);
$exps_cate = $rowc[0];
$exps_cust = htmlspecialchars($exps_cust);
$exps_caus = htmlspecialchars($exps_caus);
if ($no) {
$query = "UPDATE `toto_exp` SET `exps_code` = '" . $exps_code . "', `exps_gubn` = '" . $exps_gubn . "', `exps_cate` = '" . $exps_cate . "',`exps_cust` = '" . $exps_cust . "',`exps_caus` = '" . $exps_caus . "',`cash_mony` = '" . $cash_mony . "',`reg_date` = '" . $date_input . "',`date` = '" . $c_time . "',`etc` = '" . $etc . "' WHERE `no` =" . $no;
} else {
$query = "INSERT INTO `toto_exp` ( `no` , `exps_code` , `exps_gubn` , `exps_cate` , `exps_cust` , `exps_caus` , `cash_mony` , `reg_date` , `date` , `etc`, `reg_user` ) VALUES ('', '" . $exps_code . "', '" . $exps_gubn . "', '" . $exps_cate . "', '" . $exps_cust . "', '" . $exps_caus . "', '" . $cash_mony . "', '" . $date_input . "', '" . $c_time . "', '" . $etc . "', '" . $_SESSION['sunap'] . "');";
}
$saveQue = mysql_query($query, $connect);
$inputDiv = $thead[$exps_code] . $tfoot[$exps_code] . '</table>';
$updated = $updated . selectSale($exps_code, $date_input, $date_input) . '</table>';
$objResponse->call('fr.reset()');
// $objResponse->assign('div2', 'innerHTML', $query);
$objResponse->assign('exps_code', 'value', $exps_code);
$objResponse->assign('content', 'innerHTML', $updated);
$objResponse->call('sFocus()');
//focus 이동
return $objResponse;
}
