PHP comma Beispiele

Programmiersprache: PHP

Methode / Funktion: comma

Beispiele auf hotexamples.com: 23

PHP comma - 23 Beispiele gefunden. Dies sind die am besten bewerteten PHP Beispiele für die comma, die aus Open Source-Projekten extrahiert wurden. Sie können Beispiele bewerten, um die Qualität der Beispiele zu verbessern.

Beispiel #1

Datei anzeigen

Datei: terbilang.php Projekt: fredymr/sisfohad

function terbilang($number)
{
    $koma = ",";
    $before_comma = trim(to_word($number));
    $after_comma = trim(comma($number));
    $Hidden = explode(',', $number);
    if (in_array(1, $Hidden)) {
        return ucwords($results = $before_comma . ' koma ' . $after_comma);
    } else {
        return ucwords($results = $before_comma);
    }
}

Beispiel #2

Datei anzeigen

Datei: view-locations.php Projekt: sriram911/pls

 $sl_value = array_map("trim", $sl_value);
 // EDIT MODE
 // Show the edit form in a new row for the location that was selected.
 //
 if (isset($_GET['edit']) && $locID == $_GET['edit']) {
     print "<tr id='slp_location_edit_row'>" . "<td class='slp_locationinfoform_cell' colspan='" . (count($slpManageColumns) + 4) . "'>" . $slplus_plugin->AdminUI->createString_LocationInfoForm($sl_value, $locID) . '</td></tr>';
     // DISPLAY MODE
     //
 } else {
     // Custom Filters to set the links on special data like URLs and Email
     //
     $sl_value['sl_url'] = !$slplus_plugin->AdminUI->url_test($sl_value['sl_url']) && trim($sl_value['sl_url']) != "" ? "http://" . $sl_value['sl_url'] : $sl_value['sl_url'];
     $sl_value['sl_url'] = $sl_value['sl_url'] != "" ? "<a href='{$sl_value['sl_url']}' target='blank'>" . __("View", SLPLUS_PREFIX) . "</a>" : "";
     $sl_value['sl_email'] = $sl_value['sl_email'] != "" ? "<a href='mailto:{$sl_value['sl_email']}' target='blank'>" . __("Email", SLPLUS_PREFIX) . "</a>" : "";
     $sl_value['sl_image'] = $sl_value['sl_image'] != "" ? "<a href='{$sl_value['sl_image']}' target='blank'>" . __("View", SLPLUS_PREFIX) . "</a>" : "";
     $sl_value['sl_description'] = $sl_value['sl_description'] != "" ? "<a onclick='alert(\"" . comma($sl_value['sl_description']) . "\")' href='#'>" . __("View", SLPLUS_PREFIX) . "</a>" : "";
     print "<tr style='background-color:{$bgcol}'>" . "<th><input type='checkbox' name='sl_id[]' value='{$locID}'></th>" . "<th class='thnowrap'>" . "<a class='action_icon edit_icon' alt='" . __('edit', SLPLUS_PREFIX) . "' title='" . __('edit', SLPLUS_PREFIX) . "' \n                    href='" . preg_replace('/&edit=' . (isset($_GET['edit']) ? $_GET['edit'] : '') . '/', '', $_SERVER['REQUEST_URI']) . "&edit=" . $locID . "#a{$locID}'></a>" . "&nbsp;" . "<a class='action_icon delete_icon' alt='" . __('delete', SLPLUS_PREFIX) . "' title='" . __('delete', SLPLUS_PREFIX) . "' \n                    href='" . $_SERVER['REQUEST_URI'] . "&delete={$locID}' " . "onclick=\"confirmClick('" . sprintf(__('Delete %s?', SLPLUS_PREFIX), $sl_value['sl_store']) . "', this.href); return false;\"></a>";
     // Store Pages Active?
     // Show the create page button & fix up the sl_pages_url data
     //
     if ($slplus_plugin->license->packages['Store Pages']->isenabled) {
         $shortSPurl = preg_replace('/^.*?store_page=/', '', $sl_value['sl_pages_url']);
         $sl_value['sl_pages_url'] = "<a href='{$sl_value['sl_pages_url']}' target='cybersprocket'>{$shortSPurl}</a>";
         call_user_func_array(array('SLPlus_AdminUI', 'slpRenderCreatePageButton'), array($locID, $sl_value['sl_linked_postid']));
     }
     print "</th>";
     // Data Columns
     //
     foreach ($slpManageColumns as $slpField => $slpLabel) {
         print '<td>' . apply_filters('slp_column_data', $sl_value[$slpField], $slpField, $slpLabel) . '</td>';
     }

Beispiel #3

Datei anzeigen

Datei: add-locations.php Projekt: robbiespire/paQui

<?php

print "
<div class='wrap'>
<h2>".__("Add Locations", $text_domain)."</h2><br>";

global $wpdb;
initialize_variables();

//Inserting addresses by manual input
if ($_POST[sl_store] && $_GET[mode]!="pca") {
	foreach ($_POST as $key=>$value) {
		if (ereg("sl_", $key)) {
			$fieldList.="$key,";
			$value=comma($value);
			$valueList.="\"".stripslashes($value)."\",";
		}
	}
	$fieldList=substr($fieldList, 0, strlen($fieldList)-1);
	$valueList=substr($valueList, 0, strlen($valueList)-1);
	//$wpdb->query("INSERT into ". $wpdb->prefix . "store_locator (sl_store, sl_address, sl_city, sl_state, sl_zip) VALUES ('$_POST[sl_store]', '$_POST[sl_address]', '$_POST[sl_city]', '$_POST[sl_state]', '$_POST[sl_zip]')");
	//print "INSERT into ". $wpdb->prefix . "store_locator ($fieldList) VALUES ($valueList)"; exit;
	$wpdb->query("INSERT into ". $wpdb->prefix . "store_locator ($fieldList) VALUES ($valueList)");
	$address="$_POST[sl_address], $_POST[sl_city], $_POST[sl_state] $_POST[sl_zip]";
	do_geocoding($address);
	print "<div class='updated fade'>".__("Successful Addition",$text_domain).". $view_link</div> <!--meta http-equiv='refresh' content='0'-->"; //header("location:$_SERVER[HTTP_REFERER]");
}

//Importing addresses from an local or remote database
if ($_POST[remote] && trim($_POST[query])!="" || $_POST[finish_import]) {

Beispiel #4

Datei anzeigen

Datei: exps2010.php Projekt: asad345100/mis-pos

function selectSale($exps_code, $start_date, $end_date)
{
    global $thead, $connect;
    $selSql = "SELECT * FROM `t_closedsale` where `reg_date` = " . $start_date;
    $resultC = mysql_query($selSql, $connect);
    $rowc = mysql_fetch_row($resultC);
    $selSql = "select * from pearl_exp where `exps_code` = '" . $exps_code . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by reg_date asc";
    $result = mysql_query($selSql, $connect);
    $total = mysql_affected_rows();
    // 총 레코드 수
    $num = $total;
    $updated = $thead[$exps_code] . '<tbody>';
    while ($total--) {
        $row = mysql_fetch_row($result);
        switch ($row[2]) {
            case "0":
                $row[2] = "현금";
                break;
            case "1":
                $row[2] = "통장";
                break;
        }
        $selSql2 = "select `exps_name` from pearl_expc where `exps_cate` = '" . $row[3] . "'";
        $result2 = mysql_query($selSql2, $connect);
        $row2 = mysql_fetch_row($result2);
        $reg_date = substr($row[7], 2, 2);
        $reg_date = $reg_date . "/" . substr($row[7], 4, 2);
        $reg_date = $reg_date . "/" . substr($row[7], 6, 2);
        $updated = $updated . '<tr>
	<td class="style2">' . $reg_date . '</td>';
        if ($exps_code == 4000 || $exps_code == 4001) {
            $updated = $updated . '<td class="style2">' . $row[2] . '</td>';
        }
        $updated = $updated . '<td class="style2">' . $row2[0] . '</td>';
        $updated = $updated . '<td class="cash">' . $row[4] . '</td>';
        $updated = $updated . '<td class="style2">' . $row[5] . '</td>';
        $updated = $updated . '<td class="style2">' . comma($row[6]) . '</td>';
        if ($rowc[25] != "Y") {
            $updated = $updated . '<td class="style2"><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>';
    }
    $updated = $updated . "</table>";
    return $updated;
}

Beispiel #5

Datei anzeigen

Datei: dailys.php Projekt: asad345100/mis-pos

function inquiry($date_input)
{
    global $connect, $tableD;
    $objResponse = new xajaxResponse();
    $setTime = $date_input;
    $date_input = str_replace("-", "", $date_input);
    // '-' 제거
    if (session_is_registered('reg_date')) {
        $_SESSION['session_reg_date'] = $date_input;
        //세션에 저장
    }
    $selSql = "SELECT * FROM `toto_closedsale` where `reg_date` = " . $date_input;
    $result = mysql_query($selSql, $connect);
    $close = mysql_num_rows($result);
    $rows = mysql_fetch_row($result);
    //////////////////////////////////////////////////// 이전 날짜의 이월액 구하기 2011-03-13
    $year = substr($date_input, 0, 4);
    $month = substr($date_input, 4, 2);
    $day = substr($date_input, 6, 2);
    $foredate = date("Ymd", mktime(0, 0, 0, $month, $day - 1, $year));
    $selSqlC = "SELECT * FROM `toto_closedsale` where `reg_date`=" . $foredate;
    $resultC = mysql_query($selSqlC, $connect);
    $rowc = mysql_fetch_row($resultC);
    if ($rows[30] == "Y") {
        $updated = $tableD . '
	  <tr>
		<td colspan="2" class="style2">계정과목</td>
		<td class="style2" align="center">피부과</td>
		<td class="style2" align="center">코스메틱</td>
		<td class="style2" align="center">합계</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">전일이월</td>
		<td class="cashStyle">' . comma($rowc[1]) . '</td>
		<td class="cashStyle">' . comma($rowc[15]) . '</td>
		<td class="cashStyle">' . comma($rowc[1] + $rowc[15]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="6" class="style2" width="100">현금</td>
		<td width="100" class="style2">일반</td>
		<td class="cashStyle">' . comma($rows[2]) . '</td>
		<td class="cashStyle">' . comma($rows[16]) . '</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[16]) . '</td>
	  </tr>
	  <tr>
		<td><div align="left" class="style2">현금영수증</div></td>
		<td class="cashStyle">' . comma($rows[4]) . '</td>
		<td class="cashStyle">' . comma($rows[17]) . '</td>
		<td class="cashStyle">' . comma($rows[4] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</div></td>
		<td class="cashStyle">' . comma($rows[3]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[3]) . '</td></td>
	  </tr>
	  <tr>
		<td class="style2">보험현금영수증</td>
		<td class="cashStyle">' . comma($rows[5]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[5]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td></td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5]) . '</td>
		<td class="style4">' . comma($rows[16] + $rows[17]) . '</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[16] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">외상회수</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">현금수입계</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5]) . '</td>
		<td class="cashStyle">' . comma($rows[16] + $rows[17]) . '</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[16] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="5" class="style2">지출</td>
		<td class="style2">현금일반</td>
		<td class="cashStyle">' . comma($rows[11]) . '</td>
		<td class="cashStyle">' . comma($rows[22]) . '</td>
		<td class="cashStyle">' . comma($rows[11] + $rows[22]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">통장출금</td>
		<td class="cashStyle">' . comma($rows[12]) . '</td>
		<td class="cashStyle">' . comma($rows[23]) . '</td>
		<td class="cashStyle">' . comma($rows[12] + $rows[23]) . '</td>
	  </tr>
		<td class="style2">카드(법인)</td>
		<td class="cashStyle">' . comma($rows[13]) . '</td>
		<td class="cashStyle">' . comma($rows[24]) . '</td>
		<td class="cashStyle">' . comma($rows[13] + $rows[24]) . '</td>
	  </tr>
		<td class="style2">카드(개인)</td>
		<td class="cashStyle">' . comma($rows[14]) . '</td>
		<td class="cashStyle">' . comma($rows[25]) . '</td>
		<td class="cashStyle">' . comma($rows[14] + $rows[25]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">지출계</td>
		<td class="style4">' . comma($rows[11] + $rows[12] + $row[13] + $row[14]) . '</td>
		<td class="style4">' . comma($rows[22] + $rows[23] + $row[24] + $row[25]) . '</td>
		<td class="style4">' . comma($rows[11] + $rows[12] + $row[13] + $row[14] + $rows[22] + $rows[23] + $row[24] + $row[25]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2" align="center">원장인출</td>
		<td class="cashStyle">' . comma($rows[10]) . '</td>
		<td class="cashStyle">' . comma($rows[21]) . '</td>
		<td class="cashStyle">' . comma($rows[10] + $rows[21]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2" align="center">차일이월</td>
		<td class="cashStyle">' . comma($rows[1]) . '</td>
		<td class="cashStyle">' . comma($rows[15]) . '</td>
		<td class="cashStyle">' . comma($rows[1] + $rows[15]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="4" align="center" class="style2">카드</td>
		<td><div align="left" class="style2">일반</div></td>
		<td class="cashStyle">' . comma($rows[6]) . '</td>
		<td class="cashStyle">' . comma($rows[18]) . '</td><!-- 코스메틱 일반 카드 매출 -->
		<td class="cashStyle">' . comma($rows[6] + $rows[18]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</td>
		<td class="cashStyle">' . comma($rows[7]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[7]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td>
		<td class="cashStyle">' . comma($rows[6] + $rows[7]) . '</td><!--카드일반+카드보험-->
		<td class="cashStyle">' . comma($rows[18]) . '</td><!-- 코스메틱은 보험이 없음 -->
		<td class="cashStyle">' . comma($rows[6] + $rows[7] + $rows[18]) . '</td>
	  </tr>
	  <tr>
		<td><div align="left" class="style2">외상회수</div></td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
	  </tr>
	  <tr>
		<td colspan="2" align="center" class="style2">통장입금</td>
		<td class="cashStyle">' . comma($rows[8]) . '</td>
		<td class="cashStyle">' . comma($rows[19]) . '</td>
		<td class="cashStyle">' . comma($rows[8] + $rows[19]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" align="center" class="style2">매출환불(통장)</td>
		<td class="cashStyle">' . comma($rows[9]) . '</td>
		<td class="cashStyle">' . comma($rows[20]) . '</td>
		<td class="cashStyle">' . comma($rows[9] + $rows[20]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" align="center" class="style2">매출총계</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $rows[9]) . '</td>
		<td class="style4">' . comma($rows[16] + $rows[17] + $rows[18] + $rows[19] + $rows[20]) . '</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $rows[9] + $rows[16] + $rows[17] + $rows[18] + $rows[19] + $rows[20]) . '</td>
	  </tr>
	</table>';
        $objResponse->assign('divtable', 'innerHTML', $updated);
        $objResponse->assign('btn', 'disabled', TRUE);
        $objResponse->assign('btn', 'value', '저장됨');
        $objResponse->assign('btn', 'disabled', TRUE);
        $objResponse->assign('btn', 'value', '저장됨');
        $objResponse->assign('end', 'disabled', TRUE);
        $objResponse->assign('end', 'value', '일마감됨');
        $objResponse->assign('tt', 'innerHTML', '마감이 완료되었습니다. 자료수정은 관리자에게 문의하세요.');
    } else {
        //저장된 값이 아닐 경우 현재 저장된 매출, 지출 table에서 자료를 가져옴. 2011-03-13
        //원장 정산 저장 플래그
        $selSql = "SELECT `date` FROM `toto_balancedoctor` WHERE `reg_date`=" . $date_input;
        $result = mysql_query($selSql, $connect);
        $row = mysql_fetch_row($result);
        $bdsv_flag = $row[0];
        //피부과 일반 매출
        //김기출 수정 : 외입을 제외한 모든 항목은모두 일반 매출로 계산하여야함
        //$selSql="select `cash_mony`,`cscd_mony`,`card_mony`, `yet__mony` from toto_pay where `sale_code` = '1001' and `slit_code` = '2001' and `insu_code` = '0102' and `reg_date` between '".$date_input."' and '".$date_input."'";
        $selSql = "select `cash_mony`,`cscd_mony`,`card_mony`, `yet__mony` from toto_pay where `sale_code` = '1001' and `slit_code` <> '2002' and `insu_code` = '0102' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $gen_cash = $gen_cash + $row[0];
            $gen_cscd = $gen_cscd + $row[1];
            $gen_card = $gen_card + $row[2];
            if ($row[3] > 0) {
                $bank_in = $bank_in + $row[3];
            }
            if ($gen_yet > 0) {
                $gen_yet = $gen_yet + $row[3];
            }
        }
        //피부과 일반 외상입금
        $selSql = "select `cash_mony`,`cscd_mony`,`card_mony`, `yet__mony` from toto_pay where `sale_code` = '1001' and `slit_code` = '2002' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $gen_cash_del = $gen_cash_del + $row[0];
            $gen_cscd_del = $gen_cscd_del + $row[1];
            $gen_card_del = $gen_card_del + $row[2];
            $gen_yet_del = $gen_yet_del + $row[3];
        }
        //피부과 보험 매출
        //김기출 수정 : 외입을 제외한 모든 항목은모두 일반 매출로 계산하여야함
        //$selSql="select `cash_mony`,`cscd_mony`,`card_mony`, `yet__mony` from toto_pay where `sale_code` = '1001' and `slit_code` = '2001' and `insu_code` = '0101' and `reg_date` between '".$date_input."' and '".$date_input."'";
        $selSql = "select `cash_mony`,`cscd_mony`,`card_mony`, `yet__mony` from toto_pay where `sale_code` = '1001' and `slit_code` <> '2002' and `insu_code` = '0101' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $insu_cash = $insu_cash + $row[0];
            $insu_cscd = $insu_cscd + $row[1];
            $insu_card = $insu_card + $row[2];
            if ($row[3] > 0) {
                $bank_in = $bank_in + $row[3];
            }
            $insu_yet = $insu_yet + $row[3];
        }
        //코스메틱 매출
        //김기출 수정 : 외입을 제외한 모든 항목은모두 일반 매출로 계산하여야함
        //$selSql="select `cash_mony`,`cscd_mony`,`card_mony`,`yet__mony` from toto_pay where `sale_code` = '1002' and `slit_code` = '2001' and `reg_date` between '".$date_input."' and '".$date_input."'";
        $selSql = "select `cash_mony`,`cscd_mony`,`card_mony`,`yet__mony` from toto_pay where `sale_code` = '1002' and `slit_code` <> '2002' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $cos_cash = $cos_cash + $row[0];
            $cos_cscd = $cos_cscd + $row[1];
            $cos_card = $cos_card + $row[2];
            if ($row[3] > 0) {
                //통장 입금액 별도 저장 2011-04-15
                $cos_bank = $cos_bank + $row[3];
            }
            if ($cos_yet > 0) {
                $cos_yet = $cos_yet + $row[3];
            }
        }
        //코스메틱 외상입금
        $selSql = "select `cash_mony`,`cscd_mony`,`card_mony`,`yet__mony` from toto_pay where `sale_code` = '1002' and `slit_code` = '2002' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $cos_cash_del = $cos_cash_del + $row[0];
            $cos_cscd_del = $cos_cscd_del + $row[1];
            $cos_card_del = $cos_card_del + $row[2];
            $cos_yet_del = $cos_yet_del + $row[3];
        }
        //환불 피부과
        //김기출 : 환불표시는 미납(통장)에 있는 내용이 출력되어야 함
        //$selSql="select `cash_mony` from toto_pay where `sale_code` = '1001' and `slit_code` = '2003' and `reg_date` between '".$date_input."' and '".$date_input."'";
        $selSql = "select `yet__mony` from toto_pay where `sale_code` = '1001' and `slit_code` = '2003' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $d_refd = $d_refd + $row[0];
        }
        //환불 코스메틱
        //김기출 : 환불표시는 미납(통장)에 있는 내용이 출력되어야 함
        //$selSql="select `cash_mony` from toto_pay where `sale_code` = '1001' and `slit_code` = '2003' and `reg_date` between '".$date_input."' and '".$date_input."'";
        $selSql = "select `yet__mony` from toto_pay where `sale_code` = '1001' and `slit_code` = '2003' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $c_refd = $c_refd + $row[0];
        }
        //현금 지출 피부과
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4000' and `exps_gubn` = '0' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $exp_cash = $exp_cash + $row[0];
        }
        //통장 지출 피부과
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4000' and `exps_gubn` = '1' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $exp_bank = $exp_bank + $row[0];
        }
        //카드(법인) 지출 피부과
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4000' and `exps_gubn` = '2' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $exp_card_legal = $exp_card_legal + $row[0];
            $row = mysql_fetch_row($result);
        }
        //카드(개인) 지출 피부과
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4000' and `exps_gubn` = '3' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $exp_card_indiv = $exp_card_indiv + $row[0];
        }
        //현금 지출 코스메틱
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4001' and `exps_gubn` = '0' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $exp_cos_cash = $exp_cos_cash + $row[0];
        }
        //통장 지출 코스메틱
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4001' and `exps_gubn` = '1' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $exp_cos_bank = $exp_cos_bank + $row[0];
        }
        //카드(법인) 지출 코스메틱
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4001' and `exps_gubn` = '2' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $exp_cos_card_legal = $exp_cos_card_legal + $row[0];
        }
        //카드(개인) 지출 코스메틱
        $selSql = "select `cash_mony` from toto_exp where `exps_code` = '4001' and `exps_gubn` = '3' and `reg_date` between '" . $date_input . "' and '" . $date_input . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $total;
        while ($total--) {
            $row = mysql_fetch_row($result);
            $exp_cos_card_indiv = $exp_cos_card_indiv + $row[0];
        }
        //전일 이월금 구하기
        $rowc = 0;
        $year = substr($date_input, 0, 4);
        $month = substr($date_input, 4, 2);
        $day = substr($date_input, 6, 2);
        $foredate = date("Ymd", mktime(0, 0, 0, $month, $day - 1, $year));
        $selSqlC = "SELECT * FROM `toto_closedsale` where `reg_date` = '" . $foredate . "'";
        $resultC = mysql_query($selSqlC, $connect);
        $rowc = mysql_fetch_row($resultC);
        if ($close == 0) {
            $rows[1] = $gen_cash + $gen_cscd + $insu_cash + $insu_cscd - $exp_cash + $rowc[1];
            $rows[15] = $cos_cash + $cos_cscd - $exp_cos_cash;
        }
        $updated = $tableD . '
	  <tr>
		<td colspan="2" class="style2">계정과목</td>
		<td align="center" class="style2">피부과</td>
		<td align="center" class="style2">코스메틱</td>
		<td align="center" class="style2">합계</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">전일이월</td>
		<td class="cashStyle">' . comma($rowc[1]) . '</td>
		<td class="cashStyle">' . comma($rowc[15]) . '</td>
		<td class="cashStyle">' . comma($rowc[1] + $rowc[15]) . '</td>
	  </tr>
	  <tr>
		<td width="100" class="style2" rowspan="6">현금</td>
		<td width="100" class="style2">일반</td>
		<td class="cashStyle">' . comma($gen_cash) . '</td>
		<td class="cashStyle">' . comma($cos_cash) . '</td>
		<td class="cashStyle">' . comma($gen_cash + $cos_cash) . '</td>
	  </tr>
	  <tr>
		<td class="style2">현금영수증</td>
		<td class="cashStyle">' . comma($gen_cscd) . '</td>
		<td class="cashStyle">' . comma($cos_cscd) . '</td>
		<td class="cashStyle">' . comma($gen_cscd + $cos_cscd) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</div></td>
		<td class="cashStyle">' . comma($insu_cash) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($insu_cash) . '</td></td>
	  </tr>
	  <tr>
		<td class="style2">보험현금영수증</td>
		<td class="cashStyle">' . comma($insu_cscd) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($insu_cscd) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td></td>
		<td class="style4">' . comma($gen_cash + $gen_cscd + $insu_cash + $insu_cscd) . '</td>
		<td class="style4">' . comma($cos_cash + $cos_cscd) . '</td>
		<td class="style4">' . comma($gen_cash + $gen_cscd + $cos_cash + $cos_cscd + $insu_cash + $insu_cscd) . '</td>
	  </tr>
	  <tr>
		<td class="style2">외상회수</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">현금수입계</td>
		<td class="cashStyle">' . comma($gen_cash + $gen_cscd + $insu_cash + $insu_cscd) . '</td>
		<td class="cashStyle">' . comma($cos_cash + $cos_cscd) . '</td>
		<td class="cashStyle">' . comma($gen_cash + $gen_cscd + $cos_cash + $cos_cscd + $insu_cash + $insu_cscd) . '</td>
	  </tr>
	  <tr>
		<td rowspan="5" class="style2">지출</td>
		<td class="style2">현금일반</td>
		<td class="cashStyle">' . comma($exp_cash) . '</td>
		<td class="cashStyle">' . comma($exp_cos_cash) . '</td>
		<td class="cashStyle">' . comma($exp_cash + $exp_cos_cash) . '</td>
	  </tr>
	  <tr>
		<td class="style2">통장출금</td>
		<td class="cashStyle">' . comma($exp_bank) . '</td>
		<td class="cashStyle">' . comma($exp_cos_bank) . '</td>
		<td class="cashStyle">' . comma($exp_bank + $exp_cos_bank) . '</td>
	  </tr>
	  <tr>
		<td class="style2">카드(법인)</td>
		<td class="cashStyle">' . comma($exp_card_legal) . '</td>
		<td class="cashStyle">' . comma($exp_cos_card_legal) . '</td>
		<td class="cashStyle">' . comma($exp_card_legal + $exp_cos_card_legal) . '</td>
	  </tr>
	  <tr>
		<td class="style2">카드(개인)</td>
		<td class="cashStyle">' . comma($exp_card_indiv) . '</td>
		<td class="cashStyle">' . comma($exp_cos_card_indiv) . '</td>
		<td class="cashStyle">' . comma($exp_card_indiv + $exp_cos_card_indiv) . '</td>
	  </tr>
	  <tr>
		<td class="style2">지출계</td>
		<td class="style4">' . comma($exp_cash + $exp_bank + $exp_card_legal + $exp_card_indiv) . '</td>
		<td class="style4">' . comma($exp_cos_cash + $exp_cos_bank + $exp_cos_card_legal + $exp_cos_card_indiv) . '</td>
		<td class="style4">' . comma($exp_cash + $exp_cos_cash + $exp_bank + $exp_cos_bank + $exp_card_legal + $exp_cos_card_legal + $exp_card_indiv + $exp_cos_card_indiv) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">원장인출</td>
		<td class="cashStyle"><input type="text" class="style3" id="d_doct_mony" name="d_doct_mony" onkeypress="Keycode(event,this);"  onkeyup="SumAmount(' . ($gen_cash + $gen_cscd + $insu_cash + $insu_cscd - $exp_cash + $rowc[1]) . ',this);" Onkeydown="CheckEnter(this)" style="ime-mode:disabled" value="' . comma($rows[10]) . '"></td>
		<td class="cashStyle"><input type="text" class="style3" id="c_doct_mony" name="c_doct_mony" onkeypress="Keycode(event,this);"  onkeyup="SumAmount2(' . ($cos_cash + $cos_cscd - $exp_cos_cash) . ',this);" style="ime-mode:disabled" value="' . comma($rows[21]) . '"></td>
		<td class="cashStyle" id="doct_mony" name="doct_mony">' . comma($rows[10] + $rows[21]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">차일이월</td>
		<td class="cashStyle"><input type="text" class="style3" id="d_afdy_mony" id="d_afdy_mony" value="' . comma($rows[1]) . '" disabled></td>
		<td class="cashStyle"><input type="text" class="style3" id="c_afdy_mony" id="c_afdy_mony" value="' . comma($rows[15]) . '" disabled></td>
		<td class="cashStyle" id="afdy_mony" name="afdy_mony">' . comma($rows[1] + $rows[15]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="4" class="style2">카드</td>
		<td><div align="left" class="style2">일반</div></td>
		<td class="cashStyle">' . comma($gen_card) . '</td>
		<td class="cashStyle">' . comma($cos_card) . '</td>
		<td class="cashStyle">' . comma($gen_card + $cos_card) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</td>
		<td class="cashStyle">' . comma($insu_card) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($insu_card) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td>
		<td class="cashStyle">' . comma($gen_card + $insu_card) . '</td>
		<td class="cashStyle">' . comma($cos_card) . '</td>
		<td class="cashStyle">' . comma($gen_card + $cos_card + $insu_card) . '</td>
	  </tr>
	  <tr>
		<td class="style2">외상회수</td>
		<td class="cashStyle">' . comma($gen_cash_del + $gen_cscd_del + $gen_card_del + $gen_yet__del) . '</td>
		<td class="cashStyle">' . comma($cos_cash_del + $cos_cscd_del + $cos_card_del + $cos_yet__del) . '</td>
		<td class="cashStyle">' . comma($gen_cash_del + $gen_cscd_del + $gen_card_del + $gen_yet__del + $cos_cash_del + $cos_cscd_del + $cos_card_del + $cos_yet__del) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">통장입금</td>
		<td class="cashStyle">' . comma($bank_in) . '</td>
		<td class="cashStyle">' . comma($cos_bank) . '</td>
		<td class="cashStyle">' . comma($bank_in + $cos_bank) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">매출환불(통장)</td>
		<td class="cashStyle">' . comma($d_refd) . '</td>
		<td class="cashStyle">' . comma($c_refd) . '</td>
		<td class="cashStyle">' . comma($d_refd + $c_refd) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">매출총계</td>
		<td class="style4">' . comma($gen_cash + $gen_cscd + $insu_cash + $insu_cscd + $gen_card + $insu_card + $gen_yet + $insu_yet + $gen_cash_del + $gen_cscd_del + $gen_card_del + $gen_yet__del + $d_refd + $bank_in) . '</td>
		<td class="style4">' . comma($cos_cash + $cos_cscd + $cos_card + $cos_yet + $cos_cash_del + $cos_cscd_del + $cos_card_del + $cos_yet__del + $cos_bank + $c_refd) . '</td>
		<td class="style4">' . comma($gen_cash + $gen_cscd + $cos_cash + $cos_cscd + $insu_cash + $insu_cscd + $gen_card + $cos_card + $insu_card + $gen_yet + $insu_yet + $cos_yet + $gen_cash_del + $gen_cscd_del + $gen_card_del + $gen_yet__del + $cos_cash_del + $cos_cscd_del + $cos_card_del + $cos_yet__del + $bank_in + $cos_bank + $d_refd + $c_refd) . '</td>
	  </tr>
	</table>';
        if ($rowc[0]) {
            if ($rows[1] != $gen_cash + $gen_cscd + $insu_cash + $insu_cscd - $exp_cash + $rowc[1] - $rows[10]) {
                $objResponse->assign('detable', 'innerHTML', '저장금액과 계산 금액이 일치하지 않습니다');
            } else {
                $objResponse->assign('detable', 'innerHTML', '');
            }
        } else {
            $objResponse->assign('detable', 'innerHTML', '');
        }
        if ($rows[29] == 'Y') {
            $objResponse->assign('btn', 'disabled', FALSE);
            $objResponse->assign('btn', 'value', '수정');
            $objResponse->assign('no', 'value', $rows[0]);
            $objResponse->assign('end', 'disabled', TRUE);
            $objResponse->assign('end', 'value', '일마감요청됨');
            $objResponse->assign('tt', 'innerHTML', '일일마감요청중입니다.');
        } else {
            if ($rows[0]) {
                $objResponse->assign('btn', 'disabled', FALSE);
                $objResponse->assign('btn', 'value', '수정');
                $objResponse->assign('end', 'disabled', FALSE);
                $objResponse->assign('end', 'value', '일마감요청');
                $objResponse->assign('tt', 'innerHTML', '일일마감요청전입니다. 수정 버튼을 눌러 일일마감요청을 하세요.');
            } else {
                $objResponse->assign('btn', 'disabled', FALSE);
                $objResponse->assign('btn', 'value', '저장');
                $objResponse->assign('end', 'disabled', TRUE);
                $objResponse->assign('end', 'value', '일마감요청');
                $objResponse->assign('tt', 'innerHTML', '일마감 작성중입니다. 작성후 저장을 누르면 일일마감요청을 할 수 있습니다.');
            }
        }
        $objResponse->assign('no', 'value', $rows[0]);
        $objResponse->assign('divtable', 'innerHTML', $updated);
        $msg = $_SESSION['sunap'] . "님은 " . $setTime . "일자 자료입력 중입니다.";
        $objResponse->assign('msgDiv', 'innerHTML', $msg);
    }
    return $objResponse;
}

Beispiel #6

Datei anzeigen

Datei: function_old.php Projekt: asad345100/mis-pos

function selectSale($saleCode, $start_date, $end_date)
{
    global $thead, $tfoot, $connect;
    $selSqlC = "SELECT * FROM `t_closedsale` where `reg_date` = " . $start_date;
    $resultC = mysql_query($selSqlC, $connect);
    $rowc = mysql_fetch_row($resultC);
    //마감 여부
    $selSql = "select * from pearl_pay where `sale_code` = '" . $saleCode . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by reg_date asc";
    $result = mysql_query($selSql, $connect);
    $total = mysql_affected_rows();
    // 총 레코드 수
    $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;
        }
        switch ($row[4]) {
            case "3001":
                $row[4] = "레이저";
                break;
            case "3002":
                $row[4] = "기미제거";
                break;
            case "3003":
                $row[4] = "스킨스케일링";
                break;
            case "3004":
                $row[4] = "여드름치료";
                break;
            case "3005":
                $row[4] = "주름살제거";
                break;
            case "3006":
                $row[4] = "크리스탈필링";
                break;
            case "3007":
                $row[4] = "모발(털제거)";
                break;
            case "3008":
                $row[4] = "액취증수술";
                break;
            case "3009":
                $row[4] = "피부박피";
                break;
            case "3010":
                $row[4] = "기타";
                break;
            case "3011":
                $row[4] = "보험";
                break;
        }
        $query = "SELECT `doct_name` FROM `t_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];
        $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);
        $updated = $updated . '<tr>
	<!--<td class="style2">' . $reg_date . '</td>-->
	<td class="style2">' . $row[2] . '</td>';
        if ($saleCode == "1001") {
            $updated = $updated . '<td class="style2">' . $row[3] . '</td>
	<td class="style2">' . $row[4] . '</td>
	<td class="style2">' . $row[5] . '</td>';
        }
        $updated = $updated . '<td class="style2">' . $row[7] . '</td>
	<td class="cash">' . comma($row[8]) . '</td>
	<td class="cscd">' . comma($row[9]) . '</td>
	<td class="card">' . comma($row[10]) . '</td>
	<td class="style2">' . comma($row[11]) . '</td>
	<td class="style2">' . comma($sum) . '</td>
	<td class="style2">' . $row[16] . '</td>';
        if ($rowc[25] != "Y") {
            $updated = $updated . '<td class="style2"><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>';
    }
    $updated = $updated . '</tbody></table>';
    return $updated;
}

Beispiel #7

Datei anzeigen

Datei: processLocationData.php Projekt: linkelric/new-district-master

 $field_value_str = "";
 foreach ($_POST as $key => $value) {
     if (preg_match("@\\-{$_GET['edit']}@", $key)) {
         $key = str_replace("-{$_GET['edit']}", "", $key);
         // stripping off number at the end (giving problems when constructing address string below)
         if ($key == "sl_tags") {
             //print "before: $value <br><br>";
             $value = sl_prepare_tag_string($value);
             //print "after: $value \r\n"; die();
         }
         if (is_array($value)) {
             $value = serialize($value);
             //for arrays being submitted
             $field_value_str .= $key . "='{$value}',";
         } else {
             $field_value_str .= $key . "=" . $wpdb->prepare("%s", trim(comma(stripslashes($value)))) . ", ";
         }
         $_POST["{$key}"] = $value;
     }
 }
 $field_value_str = substr($field_value_str, 0, strlen($field_value_str) - 2);
 $edit = $_GET['edit'];
 extract($_POST);
 $the_address = "{$sl_address}, {$sl_address2}, {$sl_city}, {$sl_state} {$sl_zip}";
 if (empty($_POST['no_geocode']) || $_POST['no_geocode'] != 1) {
     //no_geocode sent by addons that manually edit the the coordinates. Prevents sl_do_geocoding() from overwriting the manual edit.
     $old_address = $wpdb->get_results("SELECT * FROM " . SL_TABLE . " WHERE sl_id='" . esc_sql($_GET['edit']) . "'", ARRAY_A);
 }
 //die("UPDATE ".SL_TABLE." SET $field_value_str WHERE sl_id='%d'");
 //$wpdb->query($wpdb->prepare("UPDATE ".SL_TABLE." SET $field_value_str WHERE sl_id='%d'", $_GET['edit']));
 $wpdb->query($wpdb->prepare("UPDATE " . SL_TABLE . " SET " . str_replace("%", "%%", $field_value_str) . " WHERE sl_id='%d'", $_GET['edit']));

Beispiel #8

Datei anzeigen

Datei: rep.php Projekt: asad345100/mis-pos

function selectAll($sale_code, $start_date, $end_date)
{
    global $thead, $connect, $tableD;
    $selSql1 = "select `reg_date` from toto_pay where `sale_code` = '" . $sale_code . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by reg_date asc";
    $result = mysql_query($selSql1, $connect);
    $total1 = mysql_num_rows($result);
    // 총 레코드 수
    $num = $total1;
    // 병원이름 출력 2011-03-31
    $docSql = "select * from toto_doctor order by `no` asc";
    $docRes = mysql_query($docSql, $connect);
    $docTot = mysql_num_rows($docRes);
    // 총 레코드 수
    $docNum = $docTot;
    $docRow = mysql_fetch_row($docRes);
    $hosp_name = $docRow[3];
    if ($total1) {
        while ($total1--) {
            $row = mysql_fetch_row($result);
            if ($row[0] == $cur_date) {
            } else {
                $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);
                $reged_date = $reged_date . "|" . $row[0];
                //입력된 reg_date 구하기
            }
            $cur_date = $row[0];
        }
        $reg_arr = explode("|", $reged_date);
        $arr_size = count($reg_arr);
        $num = 0;
        for ($ac = $start_date; $ac <= $end_date; $ac++) {
            //피부과 자료 정리
            $numOfList++;
            $selSql = "select sum(cash_mony+cscd_mony+card_mony+yet__mony), sum(card_mony), sum(cash_mony+cscd_mony) from toto_pay where `sale_code` = '" . $sale_code . "' and rmdy_doct = '" . $docRow[1] . "' and `reg_date` = '" . $ac . "' order by reg_date asc";
            $result = mysql_query($selSql, $connect);
            $total = mysql_num_rows($result);
            // 총 레코드 수
            $num = $total;
            while ($total--) {
                $row = mysql_fetch_row($result);
                $income = $row[0];
                $card_in = $row[1];
                //카드 총합
                $income_sum = $income_sum + $row[0];
                //총합
                $card_income = $card_income + $row[1];
                //카드 총합
                $cash_income = $cash_income + $row[2];
                //현금 총합
            }
            if ($sale_code == 1001) {
                //병원 합계 일 때 만 지출 계산
                $selSql2 = "select `cash_mony` from toto_exp where `exps_code` = '4000' and `reg_date` = '" . $ac . "' order by reg_date asc";
                $result2 = mysql_query($selSql2, $connect);
                $total2 = mysql_num_rows($result2);
                // 총 레코드 수
                $outcome_today = 0;
                while ($total2--) {
                    $row2 = mysql_fetch_row($result2);
                    $outcome_today = $outcome_today + $row2[0];
                    $outcome = $outcome + $row2[0];
                }
            }
        }
        $updated = $updated . '<tr>
				<td class="tdStyle">' . $hosp_name . '</td>';
        $updated = $updated . '<td class="tdStyle">' . comma($income) . '</td>';
        if ($sale_code == 1001) {
            //병원 합계 일 때 만 지출 계산
            $updated = $updated . '<td class="tdStyle">' . comma($outcome_today) . '</td>';
        }
        $updated = $updated . '<td class="tdStyle">' . comma($income_sum) . '</td>';
        if ($sale_code == 1001) {
            //병원 합계 일 때 만 지출 계산
            $updated = $updated . '<td class="tdStyle">' . comma($outcome) . '</td>';
        }
        $updated = $updated . '<td class="tdStyle">' . comma($cash_income) . '</td>';
        if ($income == 0) {
            //당일 매출이 없을 경우 2011-08-30
            $ccrate = "-";
        } else {
            $ccrate = round_up($card_income / $income, 3);
        }
        $updated = $updated . '<td class="tdStyle">' . $ccrate . '</td></tr>';
        $updated = $updated . '<tr>
				<td class="tdStyle">합계</td>';
        $updated = $updated . '<td class="tdStyle">' . comma($income) . '</td>';
        if ($sale_code == 1001) {
            //병원 합계 일 때 만 지출 계산
            $updated = $updated . '<td class="tdStyle">' . comma($outcome_today) . '</td>';
        }
        $updated = $updated . '<td class="tdStyle">' . comma($income_sum) . '</td>';
        if ($sale_code == 1001) {
            //병원 합계 일 때 만 지출 계산
            $updated = $updated . '<td class="tdStyle">' . comma($outcome) . '</td>';
        }
        $updated = $updated . '<td class="tdStyle">' . comma($cash_income) . '</td>';
        $updated = $updated . '<td class="tdStyle">' . $ccrate . '</td></tr>';
        $updated = $updated;
    } else {
        $updated = '자료가 없습니다';
    }
    return $updated;
}

Beispiel #9

Datei anzeigen

Datei: terbilang_helper.php Projekt: triasfahrudin/siska21

 function number_to_words($number)
 {
     $before_comma = trim(to_word($number));
     $after_comma = trim(comma($number));
     return ucwords($results = $before_comma . ' koma ' . $after_comma);
 }

Beispiel #10

Datei anzeigen

Datei: is_cont.php Projekt: asad345100/mis-pos

function inquiry($date_input)
{
    global $connect;
    $objResponse = new xajaxResponse();
    if ($date_input != "") {
        $setTime = $date_input;
        $date_input = str_replace("-", "", $date_input);
        // '-' 제거
        session_register("reg_date");
        $_SESSION['session_reg_date'] = $date_input;
    } else {
        //전체 저장을 위해 최초 저장된 레코드의 날짜 구함.
        $que = "SELECT min(reg_date)  FROM `toto_pay`";
        $result = mysql_query($que, $connect);
        $row = mysql_fetch_array($result);
        $m = substr($row[0], 4, 2);
        $first_date = date("Ymd", mktime(0, 0, 0, $m, 1, substr($row[0], 0, 4)));
        //최초 저장달의 1일
        $is_not_first_day = 0;
        while (date("Ym", $next_date) < date("Ym", time())) {
            $curr_date = mktime(0, 0, 0, $m - 1, 1, substr($row[0], 0, 4));
            $next_date = mktime(0, 0, 0, $m++, 1, substr($row[0], 0, 4));
            //$str=$str.date("Ym",$next_date);//새롭게 업데이트 된 월들의 스트링
            if ($is_not_first_day) {
                saveAll(date("Y-m-d", $next_date), date("Y-m-d", $curr_date));
            } else {
                saveAll(date("Y-m-d", $next_date), 1);
            }
            $is_not_first_day = 1;
        }
        $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);
    }
    // 날짜 계산 부분
    $start_date = $setTime;
    $m = substr($start_date, 5, 2);
    $limit_m = $m;
    //금년 출력에서 이전 달까지만 출력하기 위한 변수로 활용
    $end_date = date("Ymd", mktime(0, 0, 0, $m + 1, 0, substr($start_date, 0, 4)));
    $start_date = date("Ymd", mktime(0, 0, 0, $m, 1, substr($start_date, 0, 4)));
    $pre_end_date = mktime(0, 0, 0, $m + 1, 0, substr($start_date, 0, 4));
    //이전 달을 구하기 위한 준비
    $pre_start_date = mktime(0, 0, 0, $m, 1, substr($start_date, 0, 4));
    //이전 달을 구하기 위한 준비
    $start_month = date("Y-m", mktime(0, 0, 0, $m, 1, substr($start_date, 0, 4)));
    $start_year = substr($start_date, 0, 4);
    $date_input = str_replace("-", "", $setTime);
    // '-' 제거
    //항목 코드 배열 생성
    $selSql = "SELECT * FROM `toto_is_code` WHERE `is_active` =  '1' ORDER BY  `no` ASC";
    //피부과와 코스메틱 모두 출력
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 사용하는 계정 항목의 총 수
    while ($total--) {
        $is_row[] = mysql_fetch_array($result);
        // 항목 코드 번호를 알기 위한 fetch
    }
    //table의 시작
    $updated = $divSize . '<center><table border="1" style="text-align:center;background-color:#FFFFFF;border-color:#CA2F32;" cellspacing="0" cellpadding="1"><tr><td>';
    //메인 리스트로 항목 이름을 담고 있는 컬럼이다.
    $mlist = "<div style='text-align:left;border: 1px solid #CA2F32;'>\n\t <ul style='width:120px;text-align:left;border: 0px solid #CA2F32;float:left;list-style-type:none;height:980px;'>";
    //저장된 손익계산표를 출력하는 table
    $slist = "<div style='text-align:left;border: 1px solid #CA2F32;overflow:scroll;overflow-y:hidden;width:800px;height:1000px;'>\n\t \n<div name='mainDiv' id='mainDiv' style='width:4400px;'>";
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;background-color:#FFE3E2;text-align:center;'><b>과목</b></li>";
    //전전년 출력
    $selSqlc = "SELECT * FROM `toto_is_table` where `is_year` = " . ($start_year - 2);
    $is_result = mysql_query($selSqlc, $connect);
    $close = mysql_num_rows($is_result);
    for ($cnt = 0; $cnt < $close; $cnt++) {
        $rows[$cnt] = mysql_fetch_row($is_result);
        //서브 리스트로 손익계산 테이블을 출력한다.
        $slist = $slist . "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-" . (40 + $cnt * 10) . "px;z-index:" . (100 - $cnt) . "'>";
        //저장된 월별 매출액의 출력
        $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;background-color:#FFE3E2;text-align:center;list-style-type:none;' type='none'><b>" . $rows[$cnt][19] . "년 " . $rows[$cnt][18] . "월</b></li>";
        for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
            $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][$cnt2]) . "원</li>";
        }
        $is_list = explode(";", $rows[$cnt][8]);
        //항목별 매출액이 든 컬럼
        for ($cnt3 = 0; $cnt3 < count($is_list); $cnt3++) {
            if ($is_list[$cnt3] > 0) {
                $year = $rows[$cnt][19];
                $m = $rows[$cnt][18];
                $item_end_date = date("Ymd", mktime(0, 0, 0, $m + 1, 0, $year));
                $item_start_date = date("Ymd", mktime(0, 0, 0, $m, 1, $year));
                $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'><a href='#' onclick=\"ajax_showTooltip(window.event,'ajax-tooltip/is_detail.php?code=" . $is_row[$cnt3][2] . "&sdate=" . $item_start_date . "&edate=" . $item_end_date . "',this);return false\" >" . comma($is_list[$cnt3]) . "원</a></li>";
            } else {
                $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($is_list[$cnt3]) . "원</li>";
            }
        }
        //영업이익
        $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][9]) . "원</li>";
        for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
            //이하 영역
            $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][$cnt2 + 9]) . "원</li>";
        }
        $slist = $slist . "</ul>";
    }
    //전년 출력
    $selSqlc = "SELECT * FROM `toto_is_table` where `is_year` = '" . ($start_year - 1) . "' order by `is_month` asc;";
    $is_result = mysql_query($selSqlc, $connect);
    $close = mysql_num_rows($is_result);
    for ($cnt = 0; $cnt < $close; $cnt++) {
        $rows[$cnt] = mysql_fetch_row($is_result);
        //서브 리스트로 손익계산 테이블을 출력한다.
        $slist = $slist . "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-" . (40 + $cnt * 10) . "px;z-index:" . (100 - $cnt) . "'>";
        //저장된 월별 매출액의 출력
        $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;background-color:#FFE3E2;text-align:center;list-style-type:none;' type='none'><b>" . $rows[$cnt][19] . "년 " . $rows[$cnt][18] . "월</b></li>";
        for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
            $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][$cnt2]) . "원</li>";
        }
        $is_list = explode(";", $rows[$cnt][8]);
        //항목별 매출액이 든 컬럼
        for ($cnt3 = 0; $cnt3 < count($is_list); $cnt3++) {
            if ($is_list[$cnt3] > 0) {
                $year = $rows[$cnt][19];
                $m = $rows[$cnt][18];
                $item_end_date = date("Ymd", mktime(0, 0, 0, $m + 1, 0, $year));
                $item_start_date = date("Ymd", mktime(0, 0, 0, $m, 1, $year));
                $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'><a href='#' onclick=\"ajax_showTooltip(window.event,'ajax-tooltip/is_detail.php?code=" . $is_row[$cnt3][2] . "&sdate=" . $item_start_date . "&edate=" . $item_end_date . "',this);return false\" >" . comma($is_list[$cnt3]) . "원</a></li>";
            } else {
                $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($is_list[$cnt3]) . "원</li>";
            }
        }
        //영업이익
        $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][9]) . "원</li>";
        for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
            //이하 영역
            $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][$cnt2 + 9]) . "원</li>";
        }
        $slist = $slist . "</ul>";
    }
    //금년 출력
    $selSqlc = "SELECT * FROM `toto_is_table` where `is_year` = '" . $start_year . "' and `is_month` between '01' and '" . $limit_m . "' order by `is_month` asc";
    $is_result = mysql_query($selSqlc, $connect);
    $close = mysql_num_rows($is_result) - 1;
    //선택 달 이전 까지만 출력하도록 한다.
    //현재 월(月)리스트로 저장을 위한 작업을 위해 출력한다.
    $clist = "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-50px;z-index:100'>";
    //전월 대비 리스트
    $plist = "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-60px;z-index:99'>";
    //전년 대비 리스트
    $yplist = "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-70px;z-index:98'>";
    //금년 합계 리스트
    $sumlist = "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-80px;z-index:97'>";
    //비중 리스트
    $ratelist = "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-90px;z-index:96'>";
    $selSql = "SELECT * FROM `toto_is_code` WHERE `is_active` =  '1' ORDER BY  `no` ASC";
    //피부과와 코스메틱 모두 출력
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 사용하는 계정 항목의 총 수
    while ($total--) {
        $is_row[] = mysql_fetch_array($result);
        // 항목 코드 번호를 알기 위한 fetch
    }
    for ($cnt = 0; $cnt < $close; $cnt++) {
        $rows[$cnt] = mysql_fetch_row($is_result);
        //서브 리스트로 손익계산 테이블을 출력한다.
        $slist = $slist . "<ul style='width:70px;border: 0px solid #CA2F32;text-align:right;float:left;position:relative;left:-" . (40 + $cnt * 10) . "px;z-index:" . (100 - $cnt) . "'>";
        //저장된 월별 매출액의 출력
        $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;background-color:#FFE3E2;text-align:center;list-style-type:none;' type='none'><b>" . $rows[$cnt][19] . "년 " . $rows[$cnt][18] . "월</b></li>";
        for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
            $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][$cnt2]) . "원</li>";
        }
        $is_list = explode(";", $rows[$cnt][8]);
        //항목별 매출액이 든 컬럼
        for ($cnt3 = 0; $cnt3 < count($is_list); $cnt3++) {
            if ($is_list[$cnt3] > 0) {
                $year = $rows[$cnt][19];
                $m = $rows[$cnt][18];
                $item_end_date = date("Ymd", mktime(0, 0, 0, $m + 1, 0, $year));
                $item_start_date = date("Ymd", mktime(0, 0, 0, $m, 1, $year));
                $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'><a href='#' onclick=\"ajax_showTooltip(window.event,'ajax-tooltip/is_detail.php?code=" . $is_row[$cnt3][2] . "&sdate=" . $item_start_date . "&edate=" . $item_end_date . "',this);return false\" >" . comma($is_list[$cnt3]) . "원</a></li>";
            } else {
                $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($is_list[$cnt3]) . "원</li>";
            }
            $sum_item_row[$cnt3] = $sum_item_row[$cnt3] + $is_list[$cnt3];
            //항목별 합계를 구하는 배열
        }
        //영업이익
        $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][9]) . "원</li>";
        for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
            //이하 영역
            $slist = $slist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($rows[$cnt][$cnt2 + 9]) . "원</li>";
        }
        $slist = $slist . "</ul>";
    }
    // 선택된 월의 값을 데이타베이스의 저장된 값으로 가져온다.
    $rows[++$cnt] = mysql_fetch_row($is_result);
    $cash_mony = $rows[$cnt][2];
    //현금
    $icard_mony = $rows[$cnt][3];
    //보험카드
    $icash_mony = $rows[$cnt][4];
    //보험현금
    $card_mony = $rows[$cnt][5];
    //카드
    $cosmetic_sale = $rows[$cnt][6];
    //코스메틱
    $exps_sums = $rows[$cnt][7];
    //판매비와 관리비
    $current_item = $rows[$cnt][8];
    //항목별 지출
    $ebit_mony = $rows[$cnt][9];
    //영업 이익
    $accu_sale_sums = $rows[$cnt][14];
    //누적 매출
    $accu_exps_sums = $rows[$cnt][15];
    //누적 지출
    $accu_ebit_sums = $rows[$cnt][16];
    //누적 영업이익
    $sale_sums = $rows[$cnt][1];
    //매출액
    //////////////////////////////////////// 전 월 /////////////////////////////////////////////////
    $selSqlc = "SELECT * FROM `toto_is_table` where `is_year` = '" . $start_year . "' and `is_month`='" . $m . "';";
    $is_result = mysql_query($selSqlc, $connect);
    $close = mysql_num_rows($is_result);
    $rows[$cnt] = mysql_fetch_row($is_result);
    //서브 리스트로 손익계산 테이블을 출력한다.
    for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
        $p_arr[] = $rows[$cnt][$cnt2];
    }
    $p_list = explode(";", $rows[$cnt][8]);
    //항목별 매출액이 든 컬럼
    $psale_sums = $p_arr[0];
    $pcash_mony = $p_arr[1];
    $picard_mony = $p_arr[2];
    $picash_mony = $p_arr[3];
    $pcard_mony = $p_arr[4];
    $pcosm_mony = $p_arr[5];
    $pexps_sums = $p_arr[6];
    $p_eibt = $rows[$cnt][9];
    //전월 영업이익
    $p_tax = $rows[$cnt][10];
    //전월 세금
    $p_net = $rows[$cnt][11];
    //전월 당기 순이익
    $p_bank = $rows[$cnt][12];
    //전월 통장 현금 보유
    $p_balance = $rows[$cnt][13];
    //전월 보유 잔액
    $p_cumu_incom = $rows[$cnt][14];
    //전월 당기 순이익
    $p_cumu_exps = $rows[$cnt][16];
    //전월 통장 현금 보유
    $p_cumu_ebit = $rows[$cnt][17];
    //전월 보유 잔액
    //////////////////////////////////////// 전 월 /////////////////////////////////////////////////
    //////////////////////////////////////// 전 년 /////////////////////////////////////////////////
    if ($m == "12") {
        $is_month = 1;
        $start_year++;
    } else {
        $is_month = intval($m) + 1;
    }
    if ($is_month < 10) {
        $is_month = "0" . $is_month;
    }
    $selSqlc = "SELECT * FROM `toto_is_table` where `is_year` = '" . ($start_year - 1) . "' and `is_month`='" . $is_month . "';";
    $is_result = mysql_query($selSqlc, $connect);
    $close = mysql_num_rows($is_result);
    $rows[$cnt] = mysql_fetch_row($is_result);
    //서브 리스트로 손익계산 테이블을 출력한다.
    for ($cnt2 = 1; $cnt2 < 8; $cnt2++) {
        $yp_arr[] = $rows[$cnt][$cnt2];
    }
    $yp_list = explode(";", $rows[$cnt][8]);
    //항목별 매출액이 든 컬럼
    $ypsale_sums = $yp_arr[0];
    $ypcash_mony = $yp_arr[1];
    $ypicard_mony = $yp_arr[2];
    $ypicash_mony = $yp_arr[3];
    $ypcard_mony = $yp_arr[4];
    $ypcosm_mony = $yp_arr[5];
    $ypexps_sums = $yp_arr[6];
    $yp_eibt = $rows[$cnt][9];
    //////////////////////////////////////// 전 년 /////////////////////////////////////////////////
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;background-color:#FFFFFF;' type='none'><b>Ⅰ. 매출액</b></li>\t";
    // 현재 년월
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;background-color:#FFE3E2' type='none'><b>" . str_replace("-", "년 ", $start_month) . "월</b></li>";
    // 전월대비
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;background-color:#FFFFFF' type='none'><b>전월 대비</b></li>";
    //전년 대비
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;background-color:#FFFFFF' type='none'><b>전년 대비</b><input text id='focusBox' style='width:0px;height:1px;'></li>";
    //금년 합계
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;background-color:#FFFFFF' type='none'><b>" . substr($start_month, 0, 4) . "년 합계</b></li>";
    //비중
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;background-color:#FFFFFF' type='none'><b>비중</b></li>";
    //금년 합계
    $sum_sql = "select sum(`is_sale`), sum(`is_cash`), sum(`is_insu_card`), sum(`is_insu_cash`), sum(`is_card`), sum(`is_cosmetic`), sum(`is_exps`), sum(`is_ebit`) from `toto_is_table` where `is_year`='" . $start_year . "' and `is_month` between '01' and '" . $m . "'";
    $sum_res = mysql_query($sum_sql, $connect);
    $sum_row = mysql_fetch_row($sum_res);
    // 매출액
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sale_sums) . "원</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($sale_sums - $psale_sums) / $psale_sums, 2) . "%</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($sale_sums - $ypsale_sums) / $ypsale_sums, 2) . "%</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[0]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($sale_sums / $sum_row[0], 2) . "%</li>";
    //현금
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'>현금</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($cash_mony - $ypcash_mony) / $ypcash_mony, 2) . "%</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($cash_mony - $pcash_mony) / $pcash_mony, 2) . "%</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($cash_mony) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[1]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($cash_mony / $sum_row[1], 2) . "%</li>";
    //보험카드
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'>보험카드</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($icard_mony - $ypicard_mony) / $ypicard_mony, 2) . "%</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($icard_mony - $picard_mony) / $picard_mony, 2) . "%</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($icard_mony) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[2]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($icard_mony / $sum_row[2], 2) . "%</li>";
    //보험현금
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'>보험현금</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($icash_mony - $picash_mony) / $picash_mony, 2) . "%</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($icash_mony - $ypicash_mony) / $ypicash_mony, 2) . "%</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($icash_mony) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[3]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($icash_mony / $sum_row[3], 2) . "%</li>";
    //카드
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'>카드</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($card_mony - $ypcard_mony) / $ypcard_mony, 2) . "%</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($card_mony - $pcard_mony) / $pcard_mony, 2) . "%</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($card_mony) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[4]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($card_mony / $sum_row[4], 2) . "%</li>";
    //코스메틱
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'>코스메틱</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($cosmetic_sale - $ypcosm_mony) / $ypcosm_mony, 2) . "%</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($cosmetic_sale - $pcosm_mony) / $pcosm_mony, 2) . "%</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($cosmetic_sale) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[5]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($cosmetic_sale / $sum_row[5], 2) . "%</li>";
    // 등록된 항목 중 사용하는 항목(is_active=1)만 출력하기 위한 쿼리
    $selSql = "SELECT * FROM `toto_is_code` WHERE `skin_cos` = '4000' AND `is_active` =  '1' ORDER BY  `no` ASC";
    $selSql = "SELECT * FROM `toto_is_code` WHERE `is_active` =  '1' ORDER BY  `no` ASC";
    //피부과와 코스메틱 모두 출력
    $iscnt = 0;
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 사용하는 계정 항목의 총 수
    $citems = explode(";", $current_item);
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>Ⅳ. 판매비와 관리비</b></li>";
    while ($total--) {
        $row = mysql_fetch_row($result);
        $sums = $citems[$iscnt];
        $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'>" . $row[1] . "</li>";
        //항목 값 출력
        if ($citems[$iscnt]) {
            //항목이 있으면, 세부항목을 볼 수 있도록 tooltip을 제공한다.
            $clist_sale = $clist_sale . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'><a href='#' onclick=\"ajax_showTooltip(window.event,'ajax-tooltip/is_detail.php?code=" . $row[2] . "&sdate=" . $start_date . "&edate=" . $end_date . "',this);return false\" >" . comma($sums) . "원</a></li>";
        } else {
            $clist_sale = $clist_sale . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sums) . "원</li>";
        }
        // 금년 합계와 비중 리스트 추가 2012-10-04
        $sum_item_row[$iscnt] = $sum_item_row[$iscnt] + $sums;
        //항목별 합계를 구하는 배열
        $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_item_row[$iscnt]) . "원</li>";
        if ($sum_item_row[$iscnt] == 0) {
            $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>-%</li>";
        } else {
            $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($sums / $sum_item_row[$iscnt], 2) . "%</li>";
        }
        //전월 대비와 전년 대비에서 div by 0 예외 처리
        if ($yp_list[$iscnt] == 0) {
            $yplist_sale = $yplist_sale . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>-%</li>";
        } else {
            $yplist_sale = $yplist_sale . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($sums - $yp_list[$iscnt]) / $yp_list[$iscnt], 2) . "%</li>";
        }
        if ($p_list[$iscnt] == 0) {
            $plist_sale = $plist_sale . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>-%</li>";
        } else {
            $plist_sale = $plist_sale . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round(($sums - $p_list[$iscnt]) / $p_list[$iscnt], 2) . "%</li>";
        }
        $iscnt++;
        //항목 array 용 cnt
    }
    //판매비와 관리비
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($exps_sums) . "원</li>" . $clist_sale;
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>-%</li>" . $yplist_sale;
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>-%</li>" . $plist_sale;
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[6]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($exps_sums / $sum_row[6], 2) . "%</li>";
    //영업이익
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>Ⅴ.영업 이익</b></li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>-%</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>-%</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($ebit_mony) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($sum_row[7]) . "원</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . 100 * round($ebit_mony / $sum_row[7], 2) . "%</li>";
    //세금
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>Ⅸ.세금</b></li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "원</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    //당기 순이익
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>Ⅹ.당기 순이익</b></li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    //통장 현금 보유
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>통장 현금 보유</b></li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    //보유 잔액
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>보유잔액</b></li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    //누적 매출
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>누적매출</b></li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($accu_sale_sums) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    //누적 지출
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>누적지출</b></li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($accu_exps_sums) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    //누적 영업 이익
    $mlist = $mlist . "<li style='border: 1px solid #CA2F32;' type='none'><b>누적영업이익</b></li>";
    $yplist = $yplist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $plist = $plist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $clist = $clist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . comma($accu_ebit_sums) . "원</li>";
    $sumlist = $sumlist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "-" . "</li>";
    $ratelist = $ratelist . "<li style='width:100px;text-align:left;border: 1px solid #CA2F32;text-align:right;list-style-type:none;' type='none'>" . "&nbsp;" . "</li>";
    $clist = $clist . "</ul>";
    $plist = $plist . "</ul>";
    $yplist = $yplist . "</ul>";
    $sumlist = $sumlist . "</ul>";
    $ratelist = $ratelist . "</ul>";
    $mlist = $updated . $mlist . "</ul></div></td><td>\n\t" . $slist . $clist . $plist . $yplist . $sumlist . $ratelist . "\t\n</div>\t\n</div>\n";
    $updated = $mlist . "</td></tr></table>";
    $msg = $_SESSION['sunap'] . "님은 " . $setTime . "일자 자료입력 중입니다.";
    $objResponse->assign('msgDiv', 'innerHTML', $msg);
    $objResponse->assign('divtable', 'innerHTML', $updated);
    $objResponse->call('scrollDiv()');
    return $objResponse;
}

Beispiel #11

Datei anzeigen

Datei: views.php Projekt: asad345100/mis-pos

function endView($end_gubn)
{
    global $connect, $tableD;
    $objResponse = new xajaxResponse();
    switch ($end_gubn) {
        case 0:
            $selSql = "SELECT * FROM `toto_closedsale` where `ask__chck` = 'Y' and `clos_chck` = '' order by `no` asc";
            break;
        case 1:
            $selSql = "SELECT * FROM `toto_closedsale` where `ask__chck` = 'Y' and `clos_chck` = 'Y' order by `no` asc";
            break;
        case 2:
            $selSql = "SELECT * FROM `toto_closedsale` where `ask__chck` = '' and `clos_chck` = '' order by `no` asc";
            break;
    }
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 총 레코드 수
    $num = $total;
    $list = $tableD . '
  <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">현금지출</td>
    <td class="style2">통장지출</td>
    <td class="style2">카드(법인)</td>
    <td class="style2">카드(개인)</td>
    <td class="style2">피부과매출</td>
    <td class="style2">상태</td>
  </tr>';
    $pre = 0;
    while ($total--) {
        $rows = mysql_fetch_row($result);
        $reg_date = substr($rows[31], 0, 4);
        $reg_date = $reg_date . "-" . substr($rows[31], 4, 2);
        $reg_date = $reg_date . "-" . substr($rows[31], 6, 2);
        if ($rows[30] == "Y") {
            $status = "마감완료";
        } else {
            if ($rows[29] == "Y") {
                $status = "마감요청";
            } else {
                $status = "작성중";
            }
        }
        $year = substr($rows[31], 0, 4);
        $month = substr($rows[31], 4, 2);
        $day = substr($rows[31], 6, 2);
        $foredate = date("Ymd", mktime(0, 0, 0, $month, $day - 1, $year));
        $selSqlP = "SELECT `d_afdy_mony` FROM `toto_closedsale` where `reg_date`='" . $foredate . "'";
        $resultP = mysql_query($selSqlP, $connect);
        $rowP = mysql_fetch_row($resultP);
        $list = $list . '<tr>
    <td class="style2"><a href="#" onclick=xajax_selDate("' . $reg_date . '")>' . $reg_date . '</td>
    <td class="tdStyle">' . comma($rowP[0]) . '</td>
    <td class="tdStyle">' . comma($rows[2] + $rows[3] + $rows[16]) . '</td><!--현금일반+현금보험+현금코스메틱-->
    <td class="tdStyle">' . comma($rows[4] + $rows[5] + $rows[17]) . '</td><!--현금영수증일반+현금영수증보험+현금영수증코스메틱-->
    <td class="tdStyle">' . comma($rows[6] + $rows[7] + $rows[18]) . '</td><!--카드일반+카드보험+카드코스메틱-->
    <td class="tdStyle">-</td><!--피부과 외상입금+코스메틱 외상입금-->
    <td class="tdStyle">' . comma($rows[9] + $rows[20]) . '</td>
    <td class="tdStyle">' . comma($rows[10] + $rows[21]) . '</td><!--피부과원장인출+코스메틱원장인출-->
    <td class="tdStyle">' . comma($rows[1] + $rows[17]) . '</td><!--피부과이월+코스메틱이월-->
    <td class="tdStyle">' . comma($rows[11] + $rows[22]) . '</td>
    <td class="tdStyle">' . comma($rows[12] + $rows[23]) . '</td>
    <td class="tdStyle">' . comma($rows[13]) . '</td>
    <td class="tdStyle">' . comma($rows[14]) . '</td>
    <td class="tdStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $rows[9]) . '</td>
    <td class="tdStyle">' . $status . '</td>
  </tr>';
        $pre = $rows[1];
    }
    $list = $list . '</table>';
    $updated = $tableD . '
	  <tr>
		<td colspan="2" class="style2">계정과목</td>
		<td class="style2">피부과</td>
		<td class="style2">코스메틱</td>
		<td class="style2">합계</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">전일이월</td>
		<td class="cashStyle">' . comma($rowP[0]) . '</td>
		<td class="cashStyle">' . comma($rowc[15]) . '</td>
		<td class="cashStyle">' . comma($rowc[1] + $rowc[15]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="6" class="style2" width="100">현금</td>
		<td width="100" class="style2">일반</td>
		<td class="cashStyle">' . comma($rows[2]) . '</td>
		<td class="cashStyle">' . comma($rows[16]) . '</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[16]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">현금영수증</td>
		<td class="cashStyle">' . comma($rows[4]) . '</td>
		<td class="cashStyle">' . comma($rows[17]) . '</td>
		<td class="cashStyle">' . comma($rows[4] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</div></td>
		<td class="cashStyle">' . comma($rows[3]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[3]) . '</td></td>
	  </tr>
	  <tr>
		<td class="style2">보험현금영수증</td>
		<td class="cashStyle">' . comma($rows[5]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[5]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td></td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5]) . '</td>
		<td class="style4">' . comma($rows[16] + $rows[17]) . '</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[16] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">외상회수</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2" align="center">현금수입계</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5]) . '</td>
		<td class="cashStyle">' . comma($rows[16] + $rows[17]) . '</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[16] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="5" class="style2">지출</td>
		<td class="style2">현금일반</td>
		<td class="cashStyle">' . comma($rows[11]) . '</td>
		<td class="cashStyle">' . comma($rows[22]) . '</td>
		<td class="cashStyle">' . comma($rows[11] + $rows[22]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">통장출금</td>
		<td class="cashStyle">' . comma($rows[12]) . '</td>
		<td class="cashStyle">' . comma($rows[23]) . '</td>
		<td class="cashStyle">' . comma($rows[12] + $rows[23]) . '</td>
	  </tr>
		<td class="style2">카드(법인)</td>
		<td class="cashStyle">' . comma($rows[13]) . '</td>
		<td class="cashStyle">' . comma($rows[24]) . '</td>
		<td class="cashStyle">' . comma($rows[13] + $rows[24]) . '</td>
	  </tr>
		<td class="style2">카드(개인)</td>
		<td class="cashStyle">' . comma($rows[14]) . '</td>
		<td class="cashStyle">' . comma($rows[25]) . '</td>
		<td class="cashStyle">' . comma($rows[14] + $rows[25]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">지출계</td>
		<td class="style4">' . comma($rows[11] + $rows[12] + $row[13] + $row[14]) . '</td>
		<td class="style4">' . comma($rows[22] + $rows[23] + $row[24] + $row[25]) . '</td>
		<td class="style4">' . comma($rows[11] + $rows[12] + $row[13] + $row[14] + $rows[22] + $rows[23] + $row[24] + $row[25]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">원장인출</td>
		<td class="cashStyle">' . comma($rows[10]) . '</td>
		<td class="cashStyle">' . comma($rows[21]) . '</td>
		<td class="cashStyle">' . comma($rows[10] + $rows[21]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">차일이월</td>
		<td class="cashStyle">' . comma($rows[1]) . '</td>
		<td class="cashStyle">' . comma($rows[15]) . '</td>
		<td class="cashStyle">' . comma($rows[1] + $rows[15]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="4" class="style2">카드</td>
		<td><div align="left" class="style2">일반</div></td>
		<td class="cashStyle">' . comma($rows[6]) . '</td>
		<td class="cashStyle">' . comma($rows[16]) . '</td>
		<td class="cashStyle">' . comma($rows[6] + $rows[16]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</td>
		<td class="cashStyle">' . comma($rows[7]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[7]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td>
		<td class="cashStyle">' . comma($rows[6] + $rows[7]) . '</td><!--카드일반+카드보험-->
		<td class="cashStyle">' . comma($rows[18]) . '</td>
		<td class="cashStyle">' . comma($rows[6] + $rows[7] + $rows[18]) . '</td>
	  </tr>
	  <tr>
		<td><div class="style2">외상회수</div></td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">통장입금</td>
		<td class="cashStyle">' . comma($rows[8]) . '</td>
		<td class="cashStyle">' . comma($rows[19]) . '</td>
		<td class="cashStyle">' . comma($rows[8] + $rows[19]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">매출환불(통장)</td>
		<td class="cashStyle">' . comma($rows[9]) . '</td>
		<td class="cashStyle">' . comma($rows[20]) . '</td>
		<td class="cashStyle">' . comma($rows[9] + $rows[20]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">매출총계</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $row[9] + $row[10]) . '</td>
		<td class="style4">' . comma($rows[16] + $rows[17] + $rows[18] + $rows[19] + $row[20]) . '</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $row[9] + $row[10] + $rows[16] + $rows[17] + $rows[18] + $rows[19] + $row[20]) . '</td>
	  </tr>
	</table>';
    $selSql = "SELECT `clos_chck` FROM `toto_closedsale` where `no`=" . ($rows[0] - 1);
    $result = mysql_query($selSql, $connect);
    $row0 = mysql_fetch_row($result);
    if ($row0[0] != "Y") {
        $objResponse->assign('end', 'disabled', TRUE);
        $objResponse->assign('end', 'value', '이전 근무일 마감 필요');
    } else {
        if ($rows[30] == "Y") {
            $objResponse->assign('end', 'disabled', TRUE);
            $objResponse->assign('end', 'value', '일마감완료');
        } else {
            if ($rows[29] == "Y") {
                $objResponse->assign('end', 'disabled', FALSE);
                $objResponse->assign('end', 'value', '일마감');
            }
        }
    }
    $msg = $_SESSION['sunap'] . "님은 " . $reg_date . "일자 자료입력 중입니다.";
    $objResponse->assign('msgDiv', 'innerHTML', $msg);
    $objResponse->assign('divtable', 'innerHTML', $updated);
    $objResponse->assign('selDate', 'value', $reg_date);
    $objResponse->assign('wlist', 'innerHTML', $list);
    return $objResponse;
}

Beispiel #12

Datei anzeigen

Datei: months.php Projekt: asad345100/mis-pos

function selectSale($exps_code, $start_date, $end_date)
{
    global $thead, $connect;
    $selSql = "select * from toto_exp where `exps_code` = '" . $exps_code . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by reg_date asc";
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 총 레코드 수
    $num = $total;
    $updated = $thead[$exps_code] . '<tbody>';
    while ($total--) {
        $row = mysql_fetch_row($result);
        $selSql2 = "select `exps_sort`, `exps_name` from toto_expc where `exps_cate` = '" . $row[3] . "'";
        $result2 = mysql_query($selSql2, $connect);
        $row2 = mysql_fetch_row($result2);
        $reg_date = substr($row[7], 2, 2);
        $reg_date = $reg_date . "-" . substr($row[7], 4, 2);
        $reg_date = $reg_date . "-" . substr($row[7], 6, 2);
        //// 소계 출력 2011-04-16
        if ($reg_date == $pre_date || $pre_date == "") {
            $sum_date = $sum_date + $row[6];
        } else {
            if ($sum_date == 0) {
                $sum_date = $pre_val;
            }
            $updated = $updated . '<tr>';
            $updated = $updated . '<td class="summ">' . $pre_date . '</td>';
            $updated = $updated . '<td class="summ">소계</td>';
            $updated = $updated . '<td class="summ" colspan="4">' . comma($sum_date) . '</td>
		</tr>';
            $sum = $sum + $sum_date;
            $sum_date = $row[6];
        }
        if (($num - $total) % 5) {
            $ts = "tdStyle";
        } else {
            $ts = "tdStyle";
        }
        $updated = $updated . '<tr>
	<td class="' . $ts . '">' . $reg_date . '</td>';
        $updated = $updated . '<td class="' . $ts . '">' . $row2[0] . '</td>';
        $updated = $updated . '<td class="' . $ts . '">' . $row2[1] . '</td>';
        $updated = $updated . '<td class="' . $ts . '">' . $row[4] . '</td>';
        $updated = $updated . '<td class="' . $ts . '">' . $row[5] . '</td>';
        $updated = $updated . '<td class="' . $ts . '">' . comma($row[6]) . '</td>
	</tr>';
        // 오류 수정 2011-08-02
        if ($total == 0) {
            if ($reg_date == $pre_date) {
                $sum_date = $sum_date + $row[6];
            }
            $last = $last . '<tr>';
            $last = $last . '<td class="summ">' . $pre_date . '</td>';
            $last = $last . '<td class="summ">소계</td>';
            $last = $last . '<td class="summ" colspan="4">' . comma($sum_date) . '</td>
			</tr>';
            $sum = $sum + $sum_date;
            $last = $last . '<tr>';
            $last = $last . '<td class="summ">지출</td>';
            $last = $last . '<td class="summ">합계</td>';
            $last = $last . '<td class="summ" colspan="4">' . comma($sum) . '</td>
			</tr>';
        }
        $pre_date = $reg_date;
        $pre_val = $row[6];
    }
    if ($num == 0) {
        $updated = $updated . '<tr><td colspan="6">자료가 없습니다</td></tr>';
    }
    $updated = $updated . $last . "</table>";
    return $updated;
}

Beispiel #13

Datei anzeigen

Datei: exps.php Projekt: asad345100/mis-pos

function selectSale($exps_code, $start_date, $end_date)
{
    global $thead, $connect, $_SESSION, $acc;
    $selSql = "SELECT * FROM `toto_closedsale` where `reg_date` = " . $start_date;
    $resultC = mysql_query($selSql, $connect);
    $rowc = mysql_fetch_row($resultC);
    if (session_is_registered('reg_date')) {
        $_SESSION['session_reg_date'] = $start_date;
        //세션에 저장
    }
    //모두 보기 권한이 없을 경우 자신이 입력한 내용만 볼 수 있다.2011-03-30
    if (!$acc['all']) {
        $addCond = " and `reg_user` = '" . $_SESSION['sunap'] . "'";
    }
    $selSql = "select * from toto_exp where `exps_code` = '" . $exps_code . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "'" . $addCond . " order by reg_date asc";
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 총 레코드 수
    $num = $total;
    $updated = $thead[$exps_code] . '<tbody>';
    while ($total--) {
        $row = mysql_fetch_row($result);
        switch ($row[2]) {
            case "0":
                $row[2] = "현금";
                break;
            case "1":
                $row[2] = "통장";
                break;
            case "2":
                $row[2] = "카드(법인)";
                break;
            case "3":
                $row[2] = "카드(개인)";
                break;
        }
        $selSql2 = "select `exps_name` from toto_expc where `exps_cate` = '" . $row[3] . "'";
        $result2 = mysql_query($selSql2, $connect);
        $row2 = mysql_fetch_row($result2);
        $reg_date = substr($row[7], 2, 2);
        $reg_date = $reg_date . "/" . substr($row[7], 4, 2);
        $reg_date = $reg_date . "/" . substr($row[7], 6, 2);
        $updated = $updated . '<tr>';
        if ($exps_code == 4000 || $exps_code == 4001) {
            $updated = $updated . '<td class="tdStyle">' . $row[2] . '</td>';
        }
        $updated = $updated . '<td class="tdStyle">' . $row2[0] . '</td>';
        $updated = $updated . '<td class="tdStyle">' . $row[4] . '</td>';
        $updated = $updated . '<td class="tdStyle">' . $row[5] . '</td>';
        $updated = $updated . '<td class="tdStyle">' . comma($row[6]) . '</td>';
        if ($rowc[30] != "Y") {
            $updated = $updated . '<td class="style2"><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="6">자료가 없습니다</td></tr>';
    }
    $updated = $updated . "</table>";
    return $updated;
}

Beispiel #14

Datei anzeigen

Datei: view-locations.php Projekt: robbiespire/paQui

if (get_option('sl_location_table_view')!="Normal") {
print "<td><input name='description-$value[sl_id]' value='$value[sl_description]'></td>
<td><input name='url-$value[sl_id]' value='$value[sl_url]'></td>
<td><input name='hours-$value[sl_id]' value='$value[sl_hours]'></td>
<td><input name='phone-$value[sl_id]' value='$value[sl_phone]'></td>
<td><input name='image-$value[sl_id]' value='$value[sl_image]'></td>";
}

print "<td>($value[sl_latitude],&nbsp;$value[sl_longitude])</td>";*/
print "</tr>";
			}
			else {
			$value[sl_url]=(!url_test($value[sl_url]) && trim($value[sl_url])!="")? "http://".$value[sl_url] : $value[sl_url] ;
			$value[sl_url]=($value[sl_url]!="")? "<a href='$value[sl_url]' target='blank'>".__("View", $text_domain)."</a>" : "" ;
			$value[sl_image]=($value[sl_image]!="")? "<a href='$value[sl_image]' target='blank'>".__("View", $text_domain)."</a>" : "" ;
			$value[sl_description]=($value[sl_description]!="")? "<a onclick='alert(\"".comma($value[sl_description])."\")' href='#'>".__("View", $text_domain)."</a>" : "" ;
			
			print "<tr style='background-color:$bgcol'>
			<th><input type='checkbox' name='sl_id[]' value='$value[sl_id]'></th>
			<th><a href='".ereg_replace("&edit=$_GET[edit]", "",$_SERVER[REQUEST_URI])."&edit=" . $value[sl_id] ."#a$value[sl_id]'>".__("Edit", $text_domain)."</a>&nbsp;|&nbsp;<a href='$_SERVER[REQUEST_URI]&delete=$value[sl_id]' onclick=\"confirmClick('Sure?', this.href); return false;\">".__("Delete", $text_domain)."</a></th>
			<th> $value[sl_id] </th>
			<td> $value[sl_store] </td>
<td>$value[sl_address]</td>
<td>$value[sl_address2]</td>
<td>$value[sl_city]</td>
<td>$value[sl_state]</td>
<td>$value[sl_zip]</td>
<td>$value[sl_tags]</td>";

if (get_option('sl_location_table_view')!="Normal") {
print "<td>$value[sl_description]</td>

Beispiel #15

Datei anzeigen

Datei: sl-functions.php Projekt: juansalvatella/dosnoventa

function sl_readme_parse($path_to_readme, $path_to_env)
{
    include $path_to_env;
    //print "<span style='font-size:14px; font-family:Helvetica'>";
    ob_start();
    include $path_to_readme;
    $txt = ob_get_contents();
    ob_clean();
    //TOC pt.1
    $toc = $txt;
    preg_match_all("@\\=\\=\\=[ ]([^\\=\\=\\=]+)[ ]\\=\\=\\=@", $toc, $toc_match_0);
    preg_match_all("@\\=\\=[ ]([^\\=\\=]+)[ ]\\=\\=@", $toc, $toc_match_1);
    //var_dump($toc_match_1); die();
    preg_match_all("@\\=[ ]([^\\=]+)[ ]\\=@", $toc, $toc_match_2);
    //var_dump($toc_match_2); die();
    $toc_cont = "";
    foreach ($toc_match_2[1] as $heading) {
        if (!in_array($heading, $toc_match_1[1]) && !in_array($heading, $toc_match_0[1]) && !preg_match("@^[0-9]+\\.[0-9]+@", $heading)) {
            $toc_cont .= "<li style='margin-left:30px; list-style-type:circle'><a href='#" . comma($heading) . "' style='text-decoration:none'>{$heading}</a></li></li>";
        } elseif (!in_array($heading, $toc_match_0[1]) && !preg_match("@^[0-9]+\\.[0-9]+@", $heading)) {
            //!preg_match("@^[0-9]+\.[0-9]+@", $heading) prevents changelog numbers from showing up
            $toc_cont .= "<li style='margin-left:15px; list-style-type:disc'><b><a href='#" . comma($heading) . "' style='text-decoration:none'>{$heading}</a></b></li>";
        }
    }
    //parsing
    $th_start = "<th style='font-size:125%; font-weight:bold;'>";
    $h2_start = "<h2 style='font-family:Georgia; margin-bottom:0.05em;'>";
    $h3_start = "<h3 style='font-family:Georgia; margin-bottom:0.05em; margin-top:0.3em'>";
    $txt = str_replace("=== ", "{$h2_start}", $txt);
    $txt = str_replace(" ===", "</h2>", $txt);
    //$txt=str_replace("== ", "<div id='wphead' style='color:black; background: -moz-linear-gradient(center bottom, #D7D7D7, #E4E4E4) repeat scroll 0 0 transparent'><h1 id='site-heading'><span id='site-title'>", $txt);
    $txt = str_replace("== ", "<table class='widefat' ><thead>{$th_start}", $txt);
    $txt = str_replace(" ==", "</th></thead></table><!--a style='float:right' href='#readme_toc'>Table of Contents</a-->", $txt);
    $txt = str_replace("= ", "{$h3_start}", $txt);
    $txt = str_replace(" =", "</h3><a style='float:right; position:relative; top:-1.5em; font-size:10px' href='#readme_toc'>" . __("table of contents", SL_TEXT_DOMAIN) . "</a>", $txt);
    $txt = preg_replace("@Tags:[ ]?[^\r\n]+\r\n@", "", $txt);
    //TOC pt. 2
    $txt = str_replace("</h2>", "</h2><a name='readme_toc'></a><div style='float:right;  width:500px; border-radius:1em; border:solid silver 1px; padding:7px; padding-top:0px; margin:10px; margin-right:0px;'><h3>" . __("Table of Contents", SL_TEXT_DOMAIN) . "</h2>{$toc_cont}</div>", $txt);
    $txt = preg_replace_callback("@{$h2_start}<u>([^<.]*)</u></h1>@s", create_function('$matches', 'return "<h2 style=\'font-family:Georgia; margin-bottom:0.05em;\'><a name=\'".comma($matches[1])."\'></a>$matches[1]</u></h1>";'), $txt);
    $txt = preg_replace_callback("@{$th_start}([^<.]*)</th>@s", create_function('$matches', 'return "<th style=\'font-size:125%; font-weight:bold;\'><a name=\'".comma($matches[1])."\'></a>$matches[1]</th>";'), $txt);
    $txt = preg_replace_callback("@{$h3_start}( )*([^<.]*)( )*</h3>@s", create_function('$matches', 'return "<h3 style=\'font-family:Georgia; margin-bottom:0.05em; margin-top:0.3em\'><a name=\\"".comma($matches[2])."\\"></a>{$matches[1]}$matches[2]</h3>";'), $txt);
    //creating hyperlinks on top of labeled URLs (ones preceded w/a label in brackets)
    $txt = preg_replace("@\\[([a-zA-Z0-9_/?&amp;\\&\\ \\.%20,=\\-\\+\\-\\']+)*\\]\\(([a-zA-Z]+://)(([.]?[a-zA-Z0-9_/?&amp;%20,=\\-\\+\\-\\#]+)*)\\)@s", "<a onclick=\"window.parent.open('\\2'+'\\3');return false;\" href=\"#\">\\1</a>", $txt);
    //converting asterisked lines into HTML list items
    /*$txt=preg_replace("@\*[ ]?[ ]?([a-zA-Z0-9_/?&amp;\&\ \.%20,=\-\+\-\(\)\{\}\`\'\<\>\"\#\:]+)*(\r\n)?@s", "<li style='margin-left:15px; margin-bottom:0px;'>\\1</li>", $txt);*/
    $txt = preg_replace("@\\*[ ]?[ ]?([^\r\n]+)*(\r\n)?@s", "<li style='margin-left:15px; margin-bottom:0px;'>\\1</li>", $txt);
    //additional formatting
    $txt = preg_replace("@`([^`]+)*`@", "<strong class='sl_code code' style='padding:2px; border:0px'>\\1</strong>", $txt);
    $txt = preg_replace("@__([^__]+)__@", "<strong>\\1</strong>", $txt);
    $txt = preg_replace("@\r\n([0-9]\\.)@", "\r\n&nbsp;&nbsp;&nbsp;\\1", $txt);
    $txt = preg_replace("@([A-Za-z-0-9\\/\\&;# ]+): @", "<strong>\\1: </strong>", $txt);
    //$txt=preg_replace("@\[(.*)\]\(([a-zA-Z]+\://[.]?[a-zA-Z0-9_/?&amp;%20,=-\+-])*\)@s", "<a href=\"\\2\" target=_blank>\\1</a>", $txt);
    //creating hyperlinks out of text URLs (which have 'http:' in the front)
    $txt = do_hyperlink($txt, "'_blank'", "protocol");
    print nl2br($txt);
    //print "</span>";
}

Beispiel #16

Datei anzeigen

Datei: function0212.php Projekt: asad345100/mis-pos

function selectSale($saleCode, $start_date, $end_date)
{
    global $thead, $tfoot, $connect;
    session_register("reg_date");
    $_SESSION['session_reg_date'] = $start_date;
    $selSqlC = "SELECT * FROM `t_closedsale` where `reg_date` = " . $start_date;
    $resultC = mysql_query($selSqlC, $connect);
    $rowc = mysql_fetch_row($resultC);
    //마감 여부
    $selSql = "select * from pearl_pay where `sale_code` = '" . $saleCode . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by `no` desc";
    $result = mysql_query($selSql, $connect);
    $total = mysql_affected_rows();
    // 총 레코드 수
    $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 pearl_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 `t_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];
        $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);
        $updated = $updated . '<tr>
	<!--<td class="tdStyle">' . $reg_date . '</td>-->
	<td class="tdStyle">' . $row[2] . '</td>';
        if ($saleCode == "1001") {
            $updated = $updated . '<td class="tdStyle">' . $row[3] . '</td>
	<td class="tdStyle">' . $row[4] . '</td>
	<td class="tdStyle">' . $row[5] . '</td>';
        }
        $updated = $updated . '<td class="tdStyle">' . $row[7] . '</td>
	<td class="tdStyle">' . comma($row[8]) . '</td>
	<td class="tdStyle">' . comma($row[9]) . '</td>
	<td class="tdStyle">' . comma($row[10]) . '</td>
	<td class="tdStyle">' . comma($row[11]) . '</td>
	<td class="tdStyle">' . comma($sum) . '</td>
	<td class="tdStyle">' . $row[16] . '</td>';
        if ($rowc[30] != "Y") {
            $updated = $updated . '<td class="tdStyle"><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>';
    }
    $updated = $updated . '</tbody></table>';
    return $updated;
}

Beispiel #17

Datei anzeigen

Datei: stat.php Projekt: asad345100/mis-pos

function selectSale($exps_code, $start_date, $end_date)
{
    global $thead, $connect;
    $selSql = "select * from toto_exp where `exps_code` = '" . $exps_code . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by reg_date asc";
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 총 레코드 수
    $num = $total;
    $updated = $thead[$exps_code] . '<tbody>';
    while ($total--) {
        $row = mysql_fetch_row($result);
        $selSql2 = "select `exps_sort`, `exps_name` from toto_expc where `exps_cate` = '" . $row[3] . "'";
        $result2 = mysql_query($selSql2, $connect);
        $row2 = mysql_fetch_row($result2);
        $reg_date = substr($row[7], 2, 2);
        $reg_date = $reg_date . "-" . substr($row[7], 4, 2);
        $reg_date = $reg_date . "-" . substr($row[7], 6, 2);
        $updated = $updated . '<tr>
	<td class="tdStyle">' . $reg_date . '</td>';
        if ($exps_code == 4000 || $exps_code == 4001) {
            $updated = $updated . '<td class="tdStyle">' . $row2[0] . '</td>';
        }
        $updated = $updated . '<td class="tdStyle">' . $row2[1] . '</td>';
        $updated = $updated . '<td class="tdStyle">' . $row[4] . '</td>';
        $updated = $updated . '<td class="tdStyle">' . $row[5] . '</td>';
        $updated = $updated . '<td class="tdStyle">' . comma($row[6]) . '</td>

	</tr>';
    }
    if ($num == 0) {
        $updated = $updated . '<tr><td colspan="6">자료가 없습니다</td></tr>';
    }
    $updated = $updated . "</table>";
    return $updated;
}

Beispiel #18

Datei anzeigen

Datei: function.php Projekt: asad345100/mis-pos

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;
}

Beispiel #19

Datei anzeigen

Datei: national_parks.php Projekt: jeromericks/Codeup_Exercises

    echo $park['url'];
    ?>
"><?php 
    echo Input::escape($park['name']);
    ?>
</a></td>
			<td><?php 
    echo Input::escape($park['location']);
    ?>
</td>
			<td><?php 
    echo Input::escape($park['date_established']);
    ?>
</td>
			<td><?php 
    echo comma(Input::escape($park['area_in_acres']));
    ?>
</td>
			<td><?php 
    echo Input::escape($park['description']);
    ?>
</td>
			<td><a href="?pageNumber=<?php 
    echo $pageNumber;
    ?>
&id=<?php 
    echo $park['id'];
    ?>
" class="btn btn-danger">Delete</a></td>
		</tr>
	<?php

Beispiel #20

Datei anzeigen

Datei: rep2.php Projekt: asad345100/mis-pos

function selectAll($sale_code, $start_date, $end_date)
{
    global $thead, $connect, $tableD;
    $selSql = "select `reg_date` from toto_pay where `sale_code` = '" . $sale_code . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by reg_date asc";
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 총 레코드 수
    $num = $total;
    //코스 메틱 내역이 있는지 확인
    $docSql = "select * from t_doctor order by `no` asc";
    $docRes = mysql_query($docSql, $connect);
    $docTot = mysql_num_rows($docRes);
    // 총 레코드 수
    $docNum = $docTot;
    if ($total) {
        //코스메틱
        if ($sale_code == 1002) {
            $docRow = mysql_fetch_row($docRes);
            $hosp_name = $docRow[3];
            while ($total--) {
                $row = mysql_fetch_row($result);
                if ($row[0] == $cur_date) {
                } else {
                    $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);
                    $reged_date = $reged_date . "|" . $row[0];
                    //입력된 reg_date 구하기
                }
                $cur_date = $row[0];
            }
            $reg_arr = explode("|", $reged_date);
            $arr_size = count($reg_arr);
            $num = 0;
            for ($ac = $start_date; $ac <= $end_date; $ac++) {
                //피부과 자료 정리
                $numOfList++;
                $selSql = "select sum(cash_mony+cscd_mony+card_mony+yet__mony) from toto_pay where `sale_code` = '" . $sale_code . "' and `reg_date` = '" . $ac . "' order by reg_date asc";
                $result = mysql_query($selSql, $connect);
                $total = mysql_num_rows($result);
                // 총 레코드 수
                $num = $total;
                while ($total--) {
                    $row = mysql_fetch_row($result);
                    $income = $row[0];
                    $income_sum = $income_sum + $row[0];
                    //총합
                }
            }
            $updated = $updated . '<tr>
					<td class="tdStyle">' . $hosp_name . '</td>';
            $updated = $updated . '<td class="tdStyle">' . comma($income) . '</td>';
            if ($sale_code == 1001) {
                //병원 합계 일 때 만 지출 계산
                $updated = $updated . '<td class="tdStyle">' . comma($outcome) . '</td>';
            }
            $updated = $updated . '<td class="tdStyle">' . comma($income_sum) . '</td>';
            if ($sale_code == 1001) {
                //병원 합계 일 때 만 지출 계산
                $updated = $updated . '<td class="tdStyle">' . comma($outcome) . '</td>';
            }
            $updated = $updated . '<td class="tdStyle">' . comma($cash_income + $cscd_income) . '</td>';
            if ($income == 0) {
                //2012-03-11 income이 0이면 erorr 수정
                $updated = $updated . '<td class="tdStyle">-</td></tr>';
            } else {
                $updated = $updated . '<td class="tdStyle">' . round_up($card_income / $income, 3) . '</td></tr>';
            }
            $updated = $updated . '<tr>
					<td class="tdStyle">합계</td>';
            $updated = $updated . '<td class="tdStyle">' . comma($income) . '</td>';
            if ($sale_code == 1001) {
                //병원 합계 일 때 만 지출 계산
                $updated = $updated . '<td class="tdStyle">' . comma($outcome) . '</td>';
            }
            $updated = $updated . '<td class="tdStyle">' . comma($income_sum) . '</td>';
            if ($sale_code == 1001) {
                //병원 합계 일 때 만 지출 계산
                $updated = $updated . '<td class="tdStyle">' . comma($outcome) . '</td>';
            }
            $updated = $updated . '<td class="tdStyle">' . comma($cash_income + $cscd_income) . '</td>';
            if ($income == 0) {
                //2012-03-11 income이 0이면 erorr 수정
                $updated = $updated . '<td class="tdStyle">-</td></tr>';
            } else {
                $updated = $updated . '<td class="tdStyle">' . round_up($card_income / $income, 3) . '</td></tr>';
            }
            $updated = $updated . '</table>';
        } else {
            //피부과
            while ($docTot--) {
                $docNo++;
                $docRow = mysql_fetch_row($docRes);
                $income_sum = 0;
                $insu_sum = 0;
                $gner_sum = 0;
                $selSql = "select `reg_date` from toto_pay where `sale_code` = '" . $sale_code . "' and `slit_code`='2001' and rmdy_doct = '" . $docRow[1] . "' and `reg_date` between '" . $start_date . "' and '" . $end_date . "' order by reg_date asc";
                $result = mysql_query($selSql, $connect);
                $total = mysql_num_rows($result);
                // 총 레코드 수
                $num = $total;
                while ($total--) {
                    $row = mysql_fetch_row($result);
                    if ($row[0] == $cur_date) {
                    } else {
                        $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);
                        $reged_date = $reged_date . "|" . $row[0];
                        //입력된 reg_date 구하기
                    }
                    $cur_date = $row[0];
                }
                $reg_arr = explode("|", $reged_date);
                $arr_size = count($reg_arr);
                $num = 0;
                for ($ac = $start_date; $ac <= $end_date; $ac++) {
                    //피부과 자료 정리
                    $numOfList++;
                    $selSql = "select sum(cash_mony+cscd_mony+card_mony+yet__mony) from toto_pay where `sale_code` = '" . $sale_code . "' and rmdy_doct = '" . $docRow[1] . "' and `reg_date` = '" . $ac . "' order by reg_date asc";
                    $result = mysql_query($selSql, $connect);
                    $total = mysql_num_rows($result);
                    // 총 레코드 수
                    $num = $total;
                    while ($total--) {
                        $row = mysql_fetch_row($result);
                        $income = $row[0];
                        $income_sum = $income_sum + $row[0];
                        //총합
                    }
                    $selSql2 = "select count(*) from toto_pay where `sale_code` = '" . $sale_code . "' and `reg_date` = '" . $ac . "' and rmdy_doct = '" . $docRow[1] . "' and insu_code='0101'";
                    $result2 = mysql_query($selSql2, $connect);
                    $row2 = mysql_fetch_row($result2);
                    $insu_num = $row2[0];
                    // 보험 고객수
                    $insu_sum = $insu_sum + $row2[0];
                    $selSql2 = "select count(*) from toto_pay where `sale_code` = '" . $sale_code . "' and `reg_date` = '" . $ac . "' and rmdy_doct = '" . $docRow[1] . "' and insu_code='0102'";
                    $result2 = mysql_query($selSql2, $connect);
                    $row2 = mysql_fetch_row($result2);
                    $gner_num = $row2[0];
                    // 일반 고객수
                    $gner_sum = $gner_sum + $row2[0];
                    $reg_date = substr($ac, 0, 4);
                    $reg_date = $reg_date . "-" . substr($ac, 4, 2);
                    $reg_date = $reg_date . "-" . substr($ac, 6, 2);
                    $reged_date = $reged_date . "|" . $row[0];
                    //입력된 reg_date 구하기
                    if ($numOfList % 5) {
                        $ts = "tdStyle";
                    } else {
                        $ts = "tdStyle";
                    }
                }
                $updated = $updated . '<tr>
						<td class="' . $ts . '">' . $docRow[2] . '</td>';
                $updated = $updated . '<td class="' . $ts . '">' . comma($income) . '</td>';
                $updated = $updated . '<td class="' . $ts . '">' . comma($income_sum) . '</td>';
                $updated = $updated . '<td class="' . $ts . '">' . comma($gner_num) . '</td>';
                $updated = $updated . '<td class="' . $ts . '">' . comma($gner_sum) . '</td>';
                $updated = $updated . '<td class="' . $ts . '">' . comma($insu_num) . '</td>';
                $updated = $updated . '<td class="' . $ts . '">' . comma($insu_sum) . '</td>';
                $updated = $updated . '</tr>';
                //합계를 위한 계산 2011-04-11
                $t_income = $income + $t_income;
                $t_income_sum = $income_sum + $t_income_sum;
                $t_gner_num = $gner_num + $t_gner_num;
                $t_gner_sum = $gner_sum + $t_gner_sum;
                $t_insu_num = $insu_num + $t_insu_num;
                $t_insu_sum = $insu_sum + $t_insu_sum;
            }
            //진료실 개별 출력 끝
            $summation = $summation . '<tr><td class="summ">합계</td>';
            $summation = $summation . '<td class="summ">' . comma($t_income) . '</td>';
            $summation = $summation . '<td class="summ">' . comma($t_income_sum) . '</td>';
            $summation = $summation . '<td class="summ">' . comma($t_gner_num) . '</td>';
            $summation = $summation . '<td class="summ">' . comma($t_gner_sum) . '</td>';
            $summation = $summation . '<td class="summ">' . comma($t_insu_num) . '</td>';
            $summation = $summation . '<td class="summ">' . comma($t_insu_sum) . '</td></tr>';
            $summation = $summation . '<tr><td class="summ">평균</td>';
            $summation = $summation . '<td class="summ">' . comma(ceil($t_income / $docNum)) . '</td>';
            $summation = $summation . '<td class="summ">' . comma(ceil($t_income_sum / $docNum)) . '</td>';
            $summation = $summation . '<td class="summ">' . comma(ceil($t_gner_num / $docNum)) . '</td>';
            $summation = $summation . '<td class="summ">' . comma(ceil($t_gner_sum / $docNum)) . '</td>';
            $summation = $summation . '<td class="summ">' . comma(ceil($t_insu_num / $docNum)) . '</td>';
            $summation = $summation . '<td class="summ">' . comma(ceil($t_insu_sum / $docNum)) . '</td></tr>';
        }
    } else {
        $updated = "자료가 없습니다.";
    }
    return $summation . $updated . $summation;
}

Beispiel #21

Datei anzeigen

Datei: views2.php Projekt: asad345100/mis-pos

function endView($end_gubn)
{
    global $connect, $tableD;
    $objResponse = new xajaxResponse();
    switch ($end_gubn) {
        case 0:
            $selSql = "SELECT * FROM `toto_closedsale` where `ask__chck` = 'Y' and `clos_chck` = '' order by `no` asc";
            break;
        case 1:
            $selSql = "SELECT * FROM `toto_closedsale` where `ask__chck` = 'Y' and `clos_chck` = 'Y' order by `no` asc";
            break;
        case 2:
            $selSql = "SELECT * FROM `toto_closedsale` where `ask__chck` = '' and `clos_chck` = '' order by `no` asc";
            break;
    }
    $result = mysql_query($selSql, $connect);
    $total = mysql_num_rows($result);
    // 총 레코드 수
    $num = $total;
    $list = $tableD . '
  <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">현금지출</td>
    <td class="style2">통장지출</td>
    <td class="style2">카드(법인)</td>
    <td class="style2">카드(개인)</td>
    <td class="style2">피부과매출</td>
    <td class="style2">상태</td>
  </tr>';
    $pre = 0;
    while ($total--) {
        $rows = mysql_fetch_row($result);
        $reg_date = substr($rows[31], 0, 4);
        $reg_date = $reg_date . "-" . substr($rows[31], 4, 2);
        $reg_date = $reg_date . "-" . substr($rows[31], 6, 2);
        $date_input = $rows[31];
        //2011-04-13
        if ($rows[30] == "Y") {
            $status = "마감완료";
        } else {
            if ($rows[29] == "Y") {
                $status = "마감요청";
            } else {
                $status = "작성중";
            }
        }
        $year = substr($rows[31], 0, 4);
        $month = substr($rows[31], 4, 2);
        $day = substr($rows[31], 6, 2);
        $foredate = date("Ymd", mktime(0, 0, 0, $month, $day - 1, $year));
        $selSqlP = "SELECT `d_afdy_mony`,`clos_chck` FROM `toto_closedsale` where `reg_date`='" . $foredate . "'";
        $resultP = mysql_query($selSqlP, $connect);
        $rowP = mysql_fetch_row($resultP);
        $list = $list . '<tr>
    <td class="style2"><a href="#" onclick=xajax_selDate("' . $reg_date . '")>' . $reg_date . '</td>
    <td class="tdStyle">' . comma($rowP[0]) . '</td>
    <td class="tdStyle">' . comma($rows[2] + $rows[3] + $rows[16]) . '</td><!--현금일반+현금보험+현금코스메틱-->
    <td class="tdStyle">' . comma($rows[4] + $rows[5] + $rows[17]) . '</td><!--현금영수증일반+현금영수증보험+현금영수증코스메틱-->
    <td class="tdStyle">' . comma($rows[6] + $rows[7] + $rows[18]) . '</td><!--카드일반+카드보험+카드코스메틱-->
    <td class="tdStyle">-</td><!--피부과 외상입금+코스메틱 외상입금-->
    <td class="tdStyle">' . comma($rows[9] + $rows[20]) . '</td>
    <td class="tdStyle">' . comma($rows[10] + $rows[21]) . '</td><!--피부과원장인출+코스메틱원장인출-->
    <td class="tdStyle">' . comma($rows[1] + $rows[17]) . '</td><!--피부과이월+코스메틱이월-->
    <td class="tdStyle">' . comma($rows[11] + $rows[22]) . '</td>
    <td class="tdStyle">' . comma($rows[12] + $rows[23]) . '</td>
    <td class="tdStyle">' . comma($rows[13]) . '</td>
    <td class="tdStyle">' . comma($rows[14]) . '</td>
    <td class="tdStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $rows[9]) . '</td>
    <td class="tdStyle">' . $status . '</td>
  </tr>';
        $pre = $rows[1];
    }
    $list = $list . '</table>';
    // 피부과 통장
    $selBI = "SELECT * FROM `toto_bankbookinfo` where `use_flag` = '01'";
    $resBI = mysql_query($selBI, $connect);
    $totBI = mysql_num_rows($resBI);
    // 총 레코드 수
    $bank_info = '<br /><br /><table cellpadding="0" cellspacing="0" border="1">
					<tr>
						<td width="100" class="style2">
						</td>
						<td width="100" class="style2">전일이월</td>
						<td width="100" class="style2">입금</td>
						<td width="100" class="style2">지출</td>
						<td width="100" class="style2">잔액</td>
					</tr>';
    while ($rowBI = mysql_fetch_row($resBI)) {
        $bnum++;
        $cnum = $bnum - 1;
        $selBank = "SELECT * FROM `toto_bankbook` where `reg_date` = '" . $foredate . "' and bkbk_idid='" . $rowBI[0] . "'";
        $resBank = mysql_query($selBank, $connect);
        $rowBank[] = mysql_fetch_row($resBank);
        //전일 내역
        $selBank = "SELECT * FROM `toto_bankbook` where `reg_date` = '" . $date_input . "' and bkbk_idid='" . $rowBI[0] . "'";
        $resBank = mysql_query($selBank, $connect);
        $rowBankC[] = mysql_fetch_row($resBank);
        //현재 내역
        //통장 내역 출력
        $bank_info = $bank_info . '<tr><td class="style2">' . $rowBI[1] . '</td><td class="style3">' . comma($rowBank[$cnum][4]) . '</td><td class="style3">' . comma($rowBankC[$cnum][2]) . '</td><td class="style3">' . comma($rowBankC[$cnum][3]) . '</td><td class="style3">' . comma($rowBankC[$cnum][4]) . '</td></tr>';
        $sum[1] = $rowBank[$cnum][4] + $sum[1];
        //전일 내역 합계
        $sum[2] = $rowBankC[$cnum][2] + $sum[2];
        //입금 내역 합계
        $sum[3] = $rowBankC[$cnum][3] + $sum[3];
        //출금 내역 합계
        $sum[4] = $rowBankC[$cnum][4] + $sum[4];
        //잔액 내역 합계
    }
    // 코스메틱 통장
    $selBI = "SELECT * FROM `toto_bankbookinfo` where `use_flag` = '02'";
    $resBI = mysql_query($selBI, $connect);
    $totBI = mysql_num_rows($resBI);
    // 총 레코드 수
    $bnum = 0;
    while ($rowBI = mysql_fetch_row($resBI)) {
        $bnum++;
        $cnum = $bnum - 1;
        $selBank = "SELECT * FROM `toto_bankbook` where `reg_date` = '" . $foredate . "' and bkbk_idid='" . $rowBI[0] . "'";
        $resBank = mysql_query($selBank, $connect);
        $rowBank2[] = mysql_fetch_row($resBank);
        //전일 내역
        $selBank = "SELECT * FROM `toto_bankbook` where `reg_date` = '" . $date_input . "' and bkbk_idid='" . $rowBI[0] . "'";
        $resBank = mysql_query($selBank, $connect);
        $rowBankC2[] = mysql_fetch_row($resBank);
        //현재 내역
        //통장 내역 출력
        $bank_info = $bank_info . '<tr><td class="style2">' . $rowBI[1] . '</td><td class="style3">' . comma($rowBank2[$cnum][4]) . '</td><td class="style3">' . comma($rowBankC2[$cnum][2]) . '</td><td class="style3">' . comma($rowBankC2[$cnum][3]) . '</td><td class="style3">' . comma($rowBankC2[$cnum][4]) . '</td></tr>';
        $sum[1] = $rowBank2[$cnum][4] + $sum[1];
        //전일 내역 합계
        $sum[2] = $rowBankC2[$cnum][2] + $sum[2];
        //입금 내역 합계
        $sum[3] = $rowBankC2[$cnum][3] + $sum[3];
        //출금 내역 합계
        $sum[4] = $rowBankC2[$cnum][4] + $sum[4];
        //잔액 내역 합계
    }
    //통장 내역 합계
    $bank_info = $bank_info . '<tr><td class="style2">합계</td><td class="style3">' . comma($sum[1]) . '</td><td class="style3">' . comma($sum[2]) . '</td><td class="style3">' . comma($sum[3]) . '</td><td class="style3">' . comma($sum[4]) . '</td></tr></table>';
    $updated = $tableD . '
	  <tr>
		<td colspan="2" class="style2">계정과목</td>
		<td class="style2">피부과</td>
		<td class="style2">코스메틱</td>
		<td class="style2">합계</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">전일이월</td>
		<td class="cashStyle">' . comma($rowP[0]) . '</td>
		<td class="cashStyle">' . comma($rowc[15]) . '</td>
		<td class="cashStyle">' . comma($rowc[1] + $rowc[15]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="6" class="style2" width="100">현금</td>
		<td width="100" class="style2">일반</td>
		<td class="cashStyle">' . comma($rows[2]) . '</td>
		<td class="cashStyle">' . comma($rows[16]) . '</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[16]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">현금영수증</td>
		<td class="cashStyle">' . comma($rows[4]) . '</td>
		<td class="cashStyle">' . comma($rows[17]) . '</td>
		<td class="cashStyle">' . comma($rows[4] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</div></td>
		<td class="cashStyle">' . comma($rows[3]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[3]) . '</td></td>
	  </tr>
	  <tr>
		<td class="style2">보험현금영수증</td>
		<td class="cashStyle">' . comma($rows[5]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[5]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td></td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5]) . '</td>
		<td class="style4">' . comma($rows[16] + $rows[17]) . '</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[16] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">외상회수</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2" align="center">현금수입계</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5]) . '</td>
		<td class="cashStyle">' . comma($rows[16] + $rows[17]) . '</td>
		<td class="cashStyle">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[16] + $rows[17]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="5" class="style2">지출</td>
		<td class="style2">현금일반</td>
		<td class="cashStyle">' . comma($rows[11]) . '</td>
		<td class="cashStyle">' . comma($rows[22]) . '</td>
		<td class="cashStyle">' . comma($rows[11] + $rows[22]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">통장출금</td>
		<td class="cashStyle">' . comma($rows[12]) . '</td>
		<td class="cashStyle">' . comma($rows[23]) . '</td>
		<td class="cashStyle">' . comma($rows[12] + $rows[23]) . '</td>
	  </tr>
		<td class="style2">카드(법인)</td>
		<td class="cashStyle">' . comma($rows[13]) . '</td>
		<td class="cashStyle">' . comma($rows[24]) . '</td>
		<td class="cashStyle">' . comma($rows[13] + $rows[24]) . '</td>
	  </tr>
		<td class="style2">카드(개인)</td>
		<td class="cashStyle">' . comma($rows[14]) . '</td>
		<td class="cashStyle">' . comma($rows[25]) . '</td>
		<td class="cashStyle">' . comma($rows[14] + $rows[25]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">지출계</td>
		<td class="style4">' . comma($rows[11] + $rows[12] + $row[13] + $row[14]) . '</td>
		<td class="style4">' . comma($rows[22] + $rows[23] + $row[24] + $row[25]) . '</td>
		<td class="style4">' . comma($rows[11] + $rows[12] + $row[13] + $row[14] + $rows[22] + $rows[23] + $row[24] + $row[25]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">원장인출</td>
		<td class="cashStyle">' . comma($rows[10]) . '</td>
		<td class="cashStyle">' . comma($rows[21]) . '</td>
		<td class="cashStyle">' . comma($rows[10] + $rows[21]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">차일이월</td>
		<td class="cashStyle">' . comma($rows[1]) . '</td>
		<td class="cashStyle">' . comma($rows[15]) . '</td>
		<td class="cashStyle">' . comma($rows[1] + $rows[15]) . '</td>
	  </tr>
	  <tr>
		<td rowspan="4" class="style2">카드</td>
		<td><div align="left" class="style2">일반</div></td>
		<td class="cashStyle">' . comma($rows[6]) . '</td>
		<td class="cashStyle">' . comma($rows[16]) . '</td>
		<td class="cashStyle">' . comma($rows[6] + $rows[16]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">보험</td>
		<td class="cashStyle">' . comma($rows[7]) . '</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">' . comma($rows[7]) . '</td>
	  </tr>
	  <tr>
		<td class="style2">소계</td>
		<td class="cashStyle">' . comma($rows[6] + $rows[7]) . '</td><!--카드일반+카드보험-->
		<td class="cashStyle">' . comma($rows[18]) . '</td>
		<td class="cashStyle">' . comma($rows[6] + $rows[7] + $rows[18]) . '</td>
	  </tr>
	  <tr>
		<td><div class="style2">외상회수</div></td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
		<td class="cashStyle">-</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">통장입금</td>
		<td class="cashStyle">' . comma($rows[8]) . '</td>
		<td class="cashStyle">' . comma($rows[19]) . '</td>
		<td class="cashStyle">' . comma($rows[8] + $rows[19]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">매출환불(통장)</td>
		<td class="cashStyle">' . comma($rows[9]) . '</td>
		<td class="cashStyle">' . comma($rows[20]) . '</td>
		<td class="cashStyle">' . comma($rows[9] + $rows[20]) . '</td>
	  </tr>
	  <tr>
		<td colspan="2" class="style2">매출총계</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $row[9] + $row[10]) . '</td>
		<td class="style4">' . comma($rows[16] + $rows[17] + $rows[18] + $rows[19] + $row[20]) . '</td>
		<td class="style4">' . comma($rows[2] + $rows[3] + $rows[4] + $rows[5] + $rows[6] + $rows[7] + $rows[8] + $row[9] + $row[10] + $rows[16] + $rows[17] + $rows[18] + $rows[19] + $row[20]) . '</td>
	  </tr>
	</table>' . $bank_info;
    if ($rowP[1] != "Y") {
        $objResponse->assign('end', 'disabled', TRUE);
        $objResponse->assign('end', 'value', '이전 근무일 마감 필요');
    } else {
        if ($rows[30] == "Y") {
            $objResponse->assign('end', 'disabled', TRUE);
            $objResponse->assign('end', 'value', '일마감완료');
        } else {
            if ($rows[29] == "Y") {
                $objResponse->assign('end', 'disabled', FALSE);
                $objResponse->assign('end', 'value', '일마감');
            }
        }
    }
    $msg = $_SESSION['sunap'] . "님은 " . $reg_date . "일자 자료입력 중입니다.";
    $objResponse->assign('msgDiv', 'innerHTML', $msg);
    $objResponse->assign('divtable', 'innerHTML', $updated);
    $objResponse->assign('selDate', 'value', $reg_date);
    $objResponse->assign('wlist', 'innerHTML', $list);
    return $objResponse;
}

Beispiel #22

Datei anzeigen

Datei: manage-locations.php Projekt: juansalvatella/dosnoventa

     $colspan = $sl_vars['location_table_view'] != "Normal" ? count($sl_columns) - count($sl_omitted_columns) + 4 : count($sl_normal_columns) - 3 + 4;
 } else {
     $colspan = $sl_vars['location_table_view'] != "Normal" ? 18 : 11;
 }
 $bgcol = "";
 foreach ($locales as $value) {
     $bgcol = $bgcol === "" || $bgcol == "#eee" ? "#fff" : "#eee";
     $bgcol = $value['sl_latitude'] == "" || $value['sl_longitude'] == "" ? "salmon" : $bgcol;
     $value = array_map("trim", $value);
     if (!empty($_GET['edit']) && $value['sl_id'] == $_GET['edit']) {
         sl_single_location_info($value, $colspan, $bgcol);
     } else {
         $value['sl_url'] = !url_test($value['sl_url']) && trim($value['sl_url']) != "" ? "http://" . $value['sl_url'] : $value['sl_url'];
         $value['sl_url'] = $value['sl_url'] != "" ? "<a href='{$value['sl_url']}' target='blank'>" . __("View", SL_TEXT_DOMAIN) . "</a>" : "";
         $value['sl_image'] = $value['sl_image'] != "" ? "<a href='{$value['sl_image']}' target='blank'>" . __("View", SL_TEXT_DOMAIN) . "</a>" : "";
         $value['sl_description'] = $value['sl_description'] != "" ? "<a href='#description-{$value['sl_id']}' rel='sl_pop'>" . __("View", SL_TEXT_DOMAIN) . "</a><div id='description-{$value['sl_id']}' style='display:none;'>" . comma($value['sl_description']) . "</div>" : "";
         if (empty($_GET['edit'])) {
             $_GET['edit'] = "";
         }
         $edit_link = str_replace("&edit={$_GET['edit']}", "", $_SERVER['REQUEST_URI']) . "&edit=" . $value['sl_id'] . "#a{$value['sl_id']}'";
         print "<tr style='background-color:{$bgcol}' id='sl_tr-{$value['sl_id']}'>\n\t\t\t<th><input type='checkbox' name='sl_id[]' value='{$value['sl_id']}'></th>\n\t\t\t<td><a class='edit_loc_link' href='" . $edit_link . " id='{$value['sl_id']}'>" . __("Edit", SL_TEXT_DOMAIN) . "</a>&nbsp;|&nbsp;<a class='del_loc_link' href='" . wp_nonce_url("{$_SERVER['REQUEST_URI']}&delete={$value['sl_id']}", "delete-location_" . $value['sl_id']) . "' onclick=\"confirmClick('Sure?', this.href); return false;\" id='{$value['sl_id']}'>" . __("Delete", SL_TEXT_DOMAIN) . "</a></td>\n\t\t\t<td> {$value['sl_id']} </td>";
         if (function_exists("do_sl_hook") && !empty($sl_columns)) {
             do_sl_location_table_body($value);
         } else {
             if ($is_normal_view) {
                 //tco = td_close_open
                 $tco_address = $tco_address2 = $tco_city = $tco_state = $tco_zip = "</td>\n<td>";
                 $strong_addr_open = $strong_addr_close = "";
             } else {
                 $tco_address = !empty($value['sl_address']) && !empty($value['sl_store']) ? "<br>" : "";
                 $tco_address2 = !empty($value['sl_address2']) ? ", " : "";

Beispiel #23

Datei anzeigen

Datei: sums.php Projekt: asad345100/mis-pos

function inquiry($date_input)
{
    global $connect, $tableD;
    $objResponse = new xajaxResponse();
    $setTime = $date_input;
    $date_input = str_replace("-", "", $date_input);
    // '-' 제거
    session_register("reg_date");
    $_SESSION['session_reg_date'] = $date_input;
    $selSqlc = "SELECT * FROM `toto_closedsale` where `reg_date` = " . $date_input;
    $result = mysql_query($selSqlc, $connect);
    $rows = mysql_fetch_row($result);
    $close = mysql_num_rows($result);
    $updated = $tableD . '
   <tr>
     <td class="style2">진료실</td>
     <td class="style2">정산표상금액' . $rowb[2] . '</td>
     <td class="style2">원장님별정산' . $rowb[3] . '</td>
     <td class="style2">일반고객수' . $rowb[4] . '</td>
     <td class="style2">보험고객수' . $rowb[5] . '</td>
   </tr>';
    // 병원이름 출력 2011-03-31
    $docSql = "select * from toto_doctor order by `no` asc";
    $docRes = mysql_query($docSql, $connect);
    $docTot = mysql_num_rows($docRes);
    // 총 레코드 수
    $docNum = $docTot;
    $docNo = 0;
    // 출력 번호
    while ($docTot--) {
        $docNo++;
        /// 저장 여부 확인 2011-04-01
        $docRow = mysql_fetch_row($docRes);
        $selSqlb = "SELECT * FROM `toto_balancedoctor` where `reg_date` = '" . $date_input . "' and `rmdy_doct` =  '" . $docRow[1] . "'";
        $resultb = mysql_query($selSqlb, $connect);
        $closeb = mysql_num_rows($resultb);
        $rowb = mysql_fetch_row($resultb);
        /// 각 필드의 합
        $t_rowb[5] = $rowb[5] + $t_rowb[5];
        $t_rowb[4] = $rowb[4] + $t_rowb[4];
        $t_rowb[3] = $rowb[3] + $t_rowb[3];
        $t_rowb[2] = $rowb[2] + $t_rowb[2];
        $selSql = "select `cash_mony`,`cscd_mony`,`card_mony`,`yet__mony` from toto_pay where `reg_date` between '" . $date_input . "' and '" . $date_input . "' and `rmdy_doct` =  '" . $docRow[1] . "'";
        $result = mysql_query($selSql, $connect);
        $total = mysql_num_rows($result);
        // 총 레코드 수
        $num = $num + $total;
        //최소한의 자료가 있는지 확인(원장 한명의 자료라도 확인 되면 $num은 1보다 크다)
        while ($total--) {
            $row0 = mysql_fetch_row($result);
            $sum = $sum + $row0[0] + $row0[1] + $row0[2] + $row0[3];
            //정산 금액
        }
        $sums = $sum + $sums;
        $selSql = "select count(*) from toto_pay where `insu_code` = '0102' and  `reg_date` between '" . $date_input . "' and '" . $date_input . "' and `rmdy_doct` =  '" . $docRow[1] . "'";
        $result = mysql_query($selSql, $connect);
        $row1 = mysql_fetch_row($result);
        $insu[0] = $row1[0] + $insu[0];
        //일반 고객 수
        $selSql = "select count(*) from toto_pay where `insu_code` = '0101' and  `reg_date` between '" . $date_input . "' and '" . $date_input . "' and `rmdy_doct` =  '" . $docRow[1] . "'";
        $result = mysql_query($selSql, $connect);
        $row2 = mysql_fetch_row($result);
        $insu[1] = $row2[0] + $insu[1];
        //보험 고객 수
        if ($rowb[7]) {
            if ($t_rowb[2] == $sums && $t_rowb[3] == $sums && $t_rowb[4] == $insu[0] && $t_rowb[5] == $insu[1]) {
                $msg = date("Y-m-d H:i:s", $rowb[7]);
                $objResponse->assign('tt', 'innerHTML', $msg . ' 에 저장된 자료와 동일합니다.');
            } else {
                $msg = date("Y-m-d H:i:s", $rowb[7]);
                $objResponse->assign('tt', 'innerHTML', $msg . ' 에 저장된 자료와 상이합니다.' . $t_rowb[2] . '-' . $sums . '-' . $t_rowb[3] . '-' . $sums . '-' . $t_rowb[4] . '-' . $insu[0] . '-' . $t_rowb[5] . '-' . $insu[1]);
            }
        } else {
            $objResponse->assign('tt', 'innerHTML', '아직 저장되지 않았습니다.');
        }
        // 다수 진료실 정산 구현 2011-03-31
        $updated = $updated . '<tr><input type="hidden" id="no_' . $docNo . '" name="no_' . $docNo . '" value="' . $rowb[0] . '">
		 <td class="style2">' . $docRow[2] . '</td><input type="hidden" id="rmdy_doct_' . $docNo . '" name="rmdy_doct_' . $docNo . '" value="' . $docRow[1] . '">
		 <td class="tdStyle"><input type="text" id="bfor_mony_' . $docNo . '" name="bfor_mony_' . $docNo . '" class="tdStyle" value="' . comma($sum) . '"></td>
		 <td class="tdStyle"><input type="text" id="aftr_mony_' . $docNo . '" name="aftr_mony_' . $docNo . '" class="tdStyle" value="' . comma($sum) . '"></td>
		 <td class="tdStyle"><input type="text" id="gner_cont_' . $docNo . '" name="gner_cont_' . $docNo . '" class="tdStyle" value="' . $row1[0] . '"></td>
		 <td class="tdStyle"><input type="text" id="insu_cont_' . $docNo . '" name="insu_cont_' . $docNo . '" class="tdStyle" value="' . $row2[0] . '"></td>
	   </tr>';
        $sum = 0;
    }
    $updated = $updated . '<tr>
     <td class="style2">합계</td>
     <td class="tdStyle"><input type="text" class="tdStyle" value="' . comma($sums) . '" id="sum_bfor_mony" name="sum_bfor_mony" disabled="true"></td>
     <td class="tdStyle"><input type="text" class="tdStyle" value="' . comma($sums) . '" id="sum_aftr_mony" name="sum_aftr_mony" disabled="true"></td>
     <td class="tdStyle"><input type="text" class="tdStyle" value="' . $insu[0] . '" id="sum_gner_cont" name="sum_gner_cont" disabled="true"></td>
     <td class="tdStyle"><input type="text" class="tdStyle" value="' . $insu[1] . '" id="sum_insu_cont" name="sum_insu_cont" disabled="true"></td>
   </tr>
 </table>';
    $msg = $_SESSION['sunap'] . "님은 " . $setTime . "일자 자료입력 중입니다.";
    $objResponse->assign('msgDiv', 'innerHTML', $msg);
    $objResponse->assign('divtable', 'innerHTML', $updated);
    if ($rows[30] == "Y") {
        $objResponse->assign('bfor_mony', 'disabled', TRUE);
        $objResponse->assign('aftr_mony', 'disabled', TRUE);
        $objResponse->assign('gner_cont', 'disabled', TRUE);
        $objResponse->assign('insu_cont', 'disabled', TRUE);
        $objResponse->assign('btn', 'disabled', TRUE);
        $objResponse->assign('btn', 'value', '마감되었습니다');
        $objResponse->assign('tt', 'innerHTML', '');
    } else {
        if ($closeb) {
            $objResponse->assign('btn', 'disabled', FALSE);
            $objResponse->assign('btn', 'value', '수정');
        } else {
            if ($num) {
                $objResponse->assign('bfor_mony', 'disabled', FALSE);
                $objResponse->assign('aftr_mony', 'disabled', FALSE);
                $objResponse->assign('gner_cont', 'disabled', FALSE);
                $objResponse->assign('insu_cont', 'disabled', FALSE);
                $objResponse->assign('btn', 'disabled', FALSE);
                $objResponse->assign('btn', 'value', '저장');
            } else {
                $objResponse->assign('bfor_mony', 'disabled', TRUE);
                $objResponse->assign('aftr_mony', 'disabled', TRUE);
                $objResponse->assign('gner_cont', 'disabled', TRUE);
                $objResponse->assign('insu_cont', 'disabled', TRUE);
                $objResponse->assign('btn', 'disabled', TRUE);
                $objResponse->assign('btn', 'value', '자료가 없습니다');
                $objResponse->assign('tt', 'innerHTML', '');
            }
        }
    }
    return $objResponse;
}