webadmin.php

/var/www/(Del)eizo.hkosl.com/global/webadmin/customer_warranty_modifyform.php

<?php
    include 'config.php';

    // Check if the user is logged in

    if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) {
        header("Location: login.php");
        exit;
    }

    $customer_id = (int)$_GET["customer_id"];

    $sth1 = $dbh->prepare("SELECT * FROM customer_warranty WHERE customer_id=? ");
    $parameter = array($customer_id);
    if (!$sth1->execute($parameter))
        throw new Exception('[' . $sth1->errorCode() . ']: ' . print_r($sth1->errorInfo()));

    $row = $sth1->fetch(PDO::FETCH_ASSOC);

    $sql99 = "SELECT * FROM sys_cms_login WHERE cmsloginid=?";
    $sth99 = $dbh->prepare($sql99);
    $sth99->execute(array((int)$row{'lastupby'}));
    $row99 = $sth99->fetch(PDO::FETCH_ASSOC);

    //data decryption
    //include_once('../phpseclib0.3.6/Crypt/RSA.php');
    set_include_path(get_include_path() . PATH_SEPARATOR . 'phpseclib0.3.6');

    include('Crypt/RSA.php');

    $rsa = new Crypt_RSA();

    $private_key = "MIICXAIBAAKBgQDH0i//hwmPSCUNAS9UiD3wSH43NxwRKwGtHQKGarANuYNacSXb +rS2N0WKihz+aSkevePj5GZPtu21Fpx0Tt541DBlUrYL0vPK4S6QUX8I5vsOQ/Xu Iyh9NKcD2fbmf/1QrC+q7pv6xa6ctaV8u1RPGI7CAIPtMCrh9Pbg+EFo0wIDAQAB AoGATSi2HRMtV1UR7YggGSG03SR5DGQs49o5/vldQL9QtTQF6zYW2u9fuZ71LO5x DLJZzQOhTJ4k/bIS7yLIjkboM4x75DlRpG14Umi+d2GePB+r9UiqeZ67Zh7OvKFU 1CIkNC2J9G0U2G4RSG2UAZKkimIofmptq7dXa5oYYNL74t0CQQDi4RHoxIhqh9mw rLxvawgcq6gseKuY5zEgJMHGtNQTIGqn1LgxCCwNx5473xc7jW6GQbgCtDVwGqeb VkejSSsFAkEA4XgGfrAFHSQdZ9+GkNsT+eZioX5wyxP78b3csTRPPii4NudJmyeu yHmmhhJV6fknQ9ZsYqLwHH3gJpzXeH/79wJAEL3S+H4oItRLeAIHFaGsQ5FXI5Dz +KB2u4x60BLf41ltBV1pChU0SwAD6R8ZM8fH9Bg9X9W0a8VLwOao+p+XkQJBANG3 MGNaGgeW9fsOAD5wZ85Dqm4IC6X4upmKPeJdg2+PtHjs/Jvid0JlVKzUFTGB3DHP GhVM9QWrV3jS3eBpOtUCQB6Fyf7bkMHxRwa2QLoB3bM/gvk0mJPCBFpILfI5RZZG XezjDt3Xo/MqppBr8nybC42OxjbID9ALPPe/VX9AVmA=";

    $rsa->loadKey($private_key); // private key
?>
<html>
<head>
    <link rel="stylesheet" type="text/css" href="css/style.css"/>
    <link rel="stylesheet" type="text/css" href="css/warranty_style.css"/>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
    <title>Content Management System (CMS) - Powered by One Solution Limited</title>
    <!--- Select Calendar Date --->
    <link type="text/css" href="css/smoothness/jquery-ui-1.8.18.custom.css" rel="stylesheet"/>
    <script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
    <link rel="stylesheet" href="//code.jquery.com/ui/1.10.4/themes/smoothness/jquery-ui.css">
    <script src="//code.jquery.com/jquery-1.10.2.js"></script>
    <script src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
    <script type="text/javascript" src="../hongkong/warranty/js/jquery.chained.min.js" ></script>
    <script type="text/javascript">
        $(function(){
            $("#model").chained("#series");
        });
    </script>

    <script type="text/javascript">
        $(function() {
            $( "#date_of_purchase" ).datepicker( {
                dateFormat: 'yy-mm-dd',
                showOn: "both",
                buttonImage: "../hongkong/warranty/images/calendar_icon.jpg",
                buttonImageOnly: true,
                maxDate: "0"
            } );

        });

    </script>
    <!--- End Select Calendar Date --->

    <script type="text/javascript">

    function isEmpty(str) {
        return (!str || 0 === str.length);
    }

    function isInt(value) {
        return !isNaN(value) && parseInt(value) == value;
    }

    $(function(){
        $( "#customer_name" ).change(function() {
            if($(".error_msg")[0]){
                check_form(0);
            }
        });

        $( "#gender" ).change(function() {
            if($(".error_msg")[0]){
                check_form(0);
            }
        });

        $( "#email" ).change(function() {
            if($(".error_msg")[0]){
                check_form(0);
            }
        });

        $( "#contact_number" ).change(function() {
            if($(".error_msg")[0]){
                check_form(0);
            }
        });

        $( "#address1" ).change(function() {
            if($(".error_msg")[0]){
                check_form(0);
            }
        });

        $( "#date_of_purchase" ).change(function() {
            if($(".error_msg")[0]){
                check_form(0);
            }
        });

        $( "#merchant_name" ).change(function() {
            if($(".error_msg")[0]){
                check_form(0);
            }
        });


    });


    function check_form(click_submit) {

        $( ".error_msg" ).remove();
        var form_ok = true, error_msg = "";

        if (isEmpty($("#customer_name").val())) {
            form_ok = false;
            $("#customer_name").after( "<span class='error_msg'>姓名不能漏空</span>" );
            //error_msg += "客戶名稱不能漏空\n\n";
        }

        if (isEmpty($("#gender").val())) {
            form_ok = false;
            $("#gender").after( "<span class='error_msg'>稱謂不能漏空</span>" );
            //error_msg += "稱謂不能漏空\n\n";
        }

        if (isEmpty($("#email").val())) {
            form_ok = false;
            $("#email").after( "<span class='error_msg'>電子信箱不能漏空</span>" );
            //error_msg += "電子信箱不能漏空\n\n";
        } else {
            var email = $("#email").val();

            var checking = /^(([^<>()[\]\\.,;:\s@\"]+(\.[^<>()[\]\\.,;:\s@\"]+)*)|(\".+\"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/;
            if (!checking.test(email)) {
                form_ok = false;
                $("#email").after( "<span class='error_msg'>電子信箱格式錯誤</span>" );
                //error_msg += "電子信箱格式錯誤\n\n";
            }
        }

        if (isEmpty($("#contact_number").val())) {
            form_ok = false;
            $("#contact_number").after( "<span class='error_msg'>聯絡電話不能漏空</span>" );
            //error_msg += "聯絡電話不能漏空\n\n";
        } else {
            if (!isInt) {
                form_ok = false;
                $("#contact_number").after( "<span class='error_msg'>聯絡電話應是數字</span>" );
                //error_msg += "聯絡電話應是數字\n\n";
            }
        }

        if (isEmpty($("#address1").val())) {
            form_ok = false;
            $("#address1").after( "<span class='error_msg'>通訊地址不能漏空</span>" );
            //error_msg += "郵寄地址不能漏空\n\n";
        }

        if (isEmpty($("#date_of_purchase").val())) {
            form_ok = false;
            $("#date_of_purchase_error").after( "<span class='error_msg'>購買日期不能漏空</span>" );
            //error_msg += "購買日期不能漏空\n\n";
        }

        if (isEmpty($("#merchant_name").val())) {
            form_ok = false;
            $("#merchant_name").after( "<span class='error_msg'>商戶名稱不能漏空</span>" );
            //error_msg += "商戶名稱不能漏空\n\n";
        }

        /*if (!form_ok) {
         //alert(error_msg);
         } else {
         $("#warranty_form").submit();
         }*/

        if(click_submit != 0 && form_ok){
            $("#warranty_form").submit();
        }
    }

    </script>

    <style>
        .table_title{
            width: 185px;
        }
    </style>
</head>
<body>

<form action="customer_warranty_modify.php" method="post" id="warranty_form" name="modifyform" enctype="multipart/form-data">

    <input type="hidden" name="customer_id" value="<?= $row{'customer_id'}; ?>">
    <table width="800" border="0" cellpadding="0" cellspacing="0">
        <tr>
            <td height="70" align="right" valign="middle" class="icontxt">
                <table border="0" cellpadding="0" cellspacing="0">
                    <tr>
                        <td width="50" align="center" style="font-size: 13px;">
                            <input type="image" alt="submit" src="images/iconSave.png" width="32" height="32" border="0"><br> &nbsp;Save&nbsp;&nbsp;
                        </td>
                        <td width="50" align="center">
                            <a href="customer_warranty_index.php?msg=Cancel"><img src="images/iconCancel.png" alt="Cancel" width="32" height="32" border="0"><br> &nbsp;Cancel&nbsp;&nbsp;
                            </a></td>
                        <td>&nbsp;</td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                <span style="float:left;" class="pagetitletxt">&nbsp;&nbsp;<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> Modify: Customer Warranty
                    </b></span><span style="float:right;" class="msg">Last Update: <?= $row99{'cmsloginname'} . '&nbsp;&nbsp;&nbsp;' . $row{'lastupdate'}; ?></span>
            </td>
        </tr>
        <tr>
            <td align="left" valign="middle"><!-- Content -->
            <form action="warranty_form_post.php" method="post" name="warranty_from" id="warranty_from" enctype="multipart/form-data">

            <div class="css_table" style="margin-left: 10px;">

            <div class="css_tr" >
                <div class="css_td table_part_title" >
                    產品資料
                </div>

                <div class="css_td required_text">

                </div>
            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    產品系列<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <!--<select id="series" name="series" disabled>

                        <option value="">-請選擇-</option>

                        <?php
                            /*$sql = "select * from series where status = ? and deleted = ? order by sort ASC";
                            if (!($sth = $dbh->prepare($sql))) {
                                throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
                            }

                            if (!$sth->execute(array("1", "0"))) {
                                throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
                            }

                            $all_series = $sth->fetchAll();

                            foreach($all_series as $series){
                                if($series["series_code"] == $row{"series_code"}){
                                    $this_selected = "selected";
                                }else{
                                    $this_selected = "";
                                }
                                echo '<option value="'.$series["series_code"].'" '.$this_selected.'>'.$series["series_code"].'</option>';
                            }
*/
                        ?>

                    </select>-->
                    <?=$row{"series_code"}?>
                </div>

            </div>


            <div class="css_tr">
                <div class="css_td table_title">
                    型號<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <!--<select id="model" name="model" disabled>
                        <option value="">-請選擇-</option>
                        <?php
                            /*$sql = "select * from model model, series series where model.series_id = series.series_id and model.status = ? and model.deleted = ? and series.status = ? and series.deleted = ? order by series.series_code ASC, model.model_code ASC";
                            if (!($sth = $dbh->prepare($sql))) {
                                throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
                            }

                            if (!$sth->execute(array("1", "0","1", "0"))) {
                                throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
                            }

                            $all_model = $sth->fetchAll();

                            foreach($all_model as $model){
                                if($model["model_code"] == $row{"model_code"}){
                                    $this_selected = "selected";
                                }else{
                                    $this_selected = "";
                                }
                                echo '<option value="'.$model["model_code"].'" class="'.$model["series_code"].'" '.$this_selected.'>'.$model["model_code"].'</option>';
                            }
*/
                        ?>

                    </select>-->
                    <?=$row{"model_code"}?>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    產品序號<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <!--<input type="text" name="serial_num" value="<?=$row{"serial_number"}?>" style="width: 300px;" disabled/>-->
                    <?=$row{"serial_number"}?>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    購買地區<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <?php
                        if($row{"region"} == "CN") echo "中國";
                        if($row{"region"} == "HK") echo "香港";
                        if($row{"region"} == "MO") echo "澳門";
                    ?>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    購買日期<span style="color: red">* </span>
                </div>

                <div class="css_td td_input" style="display: inline;">
                    <!--<input id="date_of_purchase" type="text" name="date_of_purchase" value="<?=$row{"date_of_purchase"}?>" style="width: 180px;margin-right: 10px;" required/>-->
                    <?=$row{"date_of_purchase"}?>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    商戶名稱<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <!--<input type="text" name="merchant_name" value="<?=$row{"merchant_name"}?>" style="width: 300px;" required/>-->
                    <?=$row{"merchant_name"}?>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    免費上門色彩校準服務<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <!--<input type="radio" name="free_mix_color" value="1" <?php if($row{"free_mix_color"} == 1) echo "checked"; ?> required/><label>有</label>
                    <input type="radio" name="free_mix_color" value="0" <?php if($row{"free_mix_color"} == 0) echo "checked"; ?> required/><label>無</label>-->
                    <?php if($row{"free_mix_color"} == 1) echo "有"; else echo "無"; ?>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    固定保養年期<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <!--<input type="text" name="fixed_warranty_year" value="<?=$row{"fixed_warranty_year"}?>" style="width: 300px;" disabled/>-->
                    <?=$row{"fixed_warranty_year"}?>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    保養延長優惠(月)<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <!--<input type="text" name="extend_warranty_year" value="<?=$row{"extend_warranty_year"}?>" style="width: 300px;" disabled/>-->
                    <?=$row{"extend_warranty_year"}?>
                </div>

            </div>

            <div style="height: 25px"></div>

            <div class="css_tr">
                <div class="css_td table_part_title" >
                    聯絡資料
                </div>

                <div class="css_td required_text">
                    <span style="color: red">* </span>必填
                </div>
            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    姓名<span style="color: red">* </span>
                </div>

                <div class="css_td td_input" style="display: inline;">
                    <input type="text" name="customer_name" value="<?=$rsa->decrypt(base64_decode($row{"customer_name"}))?>" style="width: 200px;" required/>

                    <div style="margin-left: 25px;display: inline;">
                        性別<span style="color: red">* </span>

                        <select name="gender" required>
                            <option value="男" <?php if($row{"gender"} == "男" || $row{"gender"} == "Male") echo "selected";?>>男</option>
                            <option value="女" <?php if($row{"gender"} == "女" || $row{"gender"} == "Female") echo "selected";?>>女</option>
                            
                        </select>
                    </div>



                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    年齡組別
                </div>

                <div class="css_td td_input">
                    <input type="radio" name="age_group" value="< 19" <?php if($row{"age_group"} == "< 19") echo "checked"; ?>/><label class="age_group_label">< 19</label>
                    <input type="radio" name="age_group" value="20-29" <?php if($row{"age_group"} == "20-29") echo "checked"; ?>/><label class="age_group_label">20-29</label>
                    <input type="radio" name="age_group" value="30-39" <?php if($row{"age_group"} == "30-39") echo "checked"; ?>/><label class="age_group_label">30-39</label>
                    <input type="radio" name="age_group" value="40-49" <?php if($row{"age_group"} == "40-49") echo "checked"; ?>/><label class="age_group_label">40-49</label>
                    <input type="radio" name="age_group" value="> 50" <?php if($row{"age_group"} == "> 50") echo "checked"; ?>/><label class="age_group_label">> 50</label>

                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    電子信箱<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <input type="text" name="email" value="<?=$rsa->decrypt(base64_decode($row{"email"}))?>" style="width: 300px;" required/>
                </div>

            </div>


            <div class="css_tr">
                <div class="css_td table_title">
                    聯絡電話<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <input type="text" name="contact_number" value="<?=$rsa->decrypt(base64_decode($row{"contact_number"}))?>" style="width: 300px;" required/>
                </div>

            </div>


            <div class="css_tr">
                <div class="css_td table_title">
                    通訊地址<span style="color: red">* </span>
                </div>

                <div class="css_td td_input">
                    <?php
                        if($row{"region"} == "CN") echo "中國";
                        if($row{"region"} == "HK") echo "香港";
                        if($row{"region"} == "MO") echo "澳門";
                    ?>
                    <input type="text" name="address" value="<?=$rsa->decrypt(base64_decode($row{"address"}))?>" style="width: 425px;" required/>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    教育程度
                </div>

                <div class="css_td td_input">
                    <select name="education_level">
                        <option value="" >-請選擇-</option>
                        <option value="中學或以下" <?php if($row{"education_level"} == "中學或以下") echo "selected"; ?>>中學或以下</option>
                        <option value="大學或專上學院" <?php if($row{"education_level"} == "大學或專上學院") echo "selected"; ?>>大學或專上學院</option>
                        <option value="大學以上" <?php if($row{"education_level"} == "大學以上") echo "selected"; ?>>大學以上</option>
                    </select>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    職業
                </div>

                <div class="css_td td_input">
                    <select name="occupation">
                        <option value="">-請選擇-</option>
                        <option value="金融及保險" <?php if($row{"occupation"} == "金融及保險") echo "selected"; ?>>金融及保險</option>
                        <option value="進出口貿易及批發" <?php if($row{"occupation"} == "進出口貿易及批發") echo "selected"; ?>>進出口貿易及批發</option>
                        <option value="生產製造業" <?php if($row{"occupation"} == "生產製造業") echo "selected"; ?>>生產製造業</option>
                        <option value="零售" <?php if($row{"occupation"} == "零售") echo "selected"; ?>>零售</option>
                        <option value="運輸及倉庫服務" <?php if($row{"occupation"} == "運輸及倉庫服務") echo "selected"; ?>>運輸及倉庫服務</option>
                        <option value="美術,設計及創作" <?php if($row{"occupation"} == "美術,設計及創作") echo "selected"; ?>>美術,設計及創作</option>
                        <option value="廣告傳播媒體" <?php if($row{"occupation"} == "廣告傳播媒體") echo "selected"; ?>>廣告傳播媒體</option>
                        <option value="社會及個人服務" <?php if($row{"occupation"} == "社會及個人服務") echo "selected"; ?>>社會及個人服務</option>
                        <option value="學生" <?php if($row{"occupation"} == "學生") echo "selected"; ?>>學生</option>
                        <option value="退休人士" <?php if($row{"occupation"} == "退休人士") echo "selected"; ?>>退休人士</option>
                        <option value="其他" <?php if($row{"occupation"} == "其他") echo "selected"; ?>>其他</option>
                    </select>
                </div>

            </div>


            <div class="css_tr">
                <div class="css_td table_title">
                    每月入息
                </div>

                <div class="css_td td_input">
                    <select name="monthly_income">
                        <option value="">-請選擇-</option>
                        <option value="<10,000" <?php if($row{"monthly_income"} == "<10,000") echo "selected"; ?>><10,000</option>
                        <option value="10,000 - 14,999" <?php if($row{"monthly_income"} == "10,000 - 14,999") echo "selected"; ?>>10,000 - 14,999</option>
                        <option value="15,000 - 19,999" <?php if($row{"monthly_income"} == "15,000 - 19,999") echo "selected"; ?>>15,000 - 19,999</option>
                        <option value="20,000 - 24,999" <?php if($row{"monthly_income"} == "20,000 - 24,999") echo "selected"; ?>>20,000 - 24,999</option>
                        <option value="25,000 - 39,999" <?php if($row{"monthly_income"} == "25,000 - 39,999") echo "selected"; ?>>25,000 - 39,999</option>
                        <option value="≧ 40,000" <?php if($row{"monthly_income"} == "≧ 40,000") echo "selected"; ?>>≧ 40,000</option>
                    </select>
                </div>

            </div>

            <div class="css_tr">
                <div class="css_td table_title">
                    EIZO推廣電郵
                </div>

                <div class="css_td td_input">
                    <input type="radio" name="receive_promotes" value="1" <?php if($row{"receive_promotes"} == "1") echo "checked"; ?>/> <label>接受</label>
                    <input type="radio" name="receive_promotes" value="0" <?php if($row{"receive_promotes"} == "0") echo "checked"; ?>/> <label>不接受</label>
                </div>

            </div>

            <div style="height: 25px"></div>

            <div class="css_tr" >
                <div class="css_td table_part_title" >
                    管理員專用
                </div>

                <div class="css_td required_text">

                </div>
            </div>

            <div class="css_tr">
                <div class="css_td table_title" style="vertical-align: top;">
                    備注
                </div>

                <div class="css_td td_input">
                    <textarea name="remarks" style="width: 300px;height: 150px;"><?=$row{"remarks"}?></textarea>
                </div>

            </div>


            <div class="css_tr">
                <div class="css_td table_title"></div>

                <div class="css_td td_input"></div>

            </div>

            </form>
            </td>
        </tr>
    </table>
</form>
</body>
</html>