Ejemplos de Class_mp_spec_traffic_fee::get_rows en PHP

Ejemplo n.º 1

Archivo: popup_communication_memo.php Proyecto: BGCX262/zuozhenshi-prego-svn-to-git

$promise_dao = new Class_mp_promise();
$promise_spec_dao = new Class_mp_promise_spec();
$operation_history_dao = new Class_mp_promise_operation_history($promise_spec_dao->get_db());
$spec_dao = new Class_mp_specialist();
$payment_dao = new Class_mp_payment();
$account_dao = new Class_mp_account();
$corporate_tantou_dao = new Class_mp_corporate_tantou();
$spec_traffic_dao = new Class_mp_spec_traffic_fee();
$smtp_dao = new smtpclass();
if (isset($_GET['id']) && !empty($_GET['id'])) {
    if (isset($_GET['spec_id']) && $_GET['spec_id'] != '') {
        // get spec_id
        $tra_spec_id = $_GET['spec_id'];
        // get spec_traffic data
        $sql = "select * from mp_spec_traffic_fee where spec_id = '{$tra_spec_id}'";
        $spec_traffic_data = $spec_traffic_dao->get_rows($sql);
        $traffic_name = array();
        $traffic_fee = array();
        $traffic_memo = array();
        foreach ($spec_traffic_data as $k => $v) {
            $traffic_name_arr[] = $v['traffic_name'];
            $traffic_fee[] = $v['traffic_fee'];
            $traffic_memo[] = $v['traffic_memo'];
        }
        $select = array('' => "選択してください");
        $traffic_name = array_merge($select, $traffic_name_arr);
    }
    $executeflg = true;
    $values = array();
    $status = $_GET['status'];
    $promise_id = $_GET['promise_id'];

Ejemplo n.º 2

Archivo: specialist_refer.php Proyecto: BGCX262/zuozhenshi-prego-svn-to-git

 $cell1 = substr($spec_forms['phone'], 0, 2);
 $cell2 = substr($spec_forms['phone'], 2, 4);
 $cell3 = substr($spec_forms['phone'], 6, 4);
 if (!empty($cell1) && !empty($cell2) && !empty($cell3)) {
     $phone = $cell1 . "-" . $cell2 . "-" . $cell3;
 }
 // deal with fax
 $fax1 = substr($spec_forms['fax'], 0, 2);
 $fax2 = substr($spec_forms['fax'], 2, 4);
 $fax3 = substr($spec_forms['fax'], 6, 4);
 if (!empty($fax1) && !empty($fax2) && !empty($fax3)) {
     $fax = $fax1 . "-" . $fax2 . "-" . $fax3;
 }
 // get spec_traffic_fee_forms
 $traffic_fee_sql = sprintf("select * from mp_spec_traffic_fee where spec_id = '%s'", mysql_real_escape_string($id));
 $spec_traffic_fee_forms = $traffic_fee_dao->get_rows($traffic_fee_sql);
 if (is_array($spec_traffic_fee_forms)) {
     foreach ($spec_traffic_fee_forms as $dtime) {
         $d_time[] = date('Y-m-d', strtotime($dtime['d_time']));
     }
 }
 $smarty->assign('d_time', $d_time);
 // get spec_profile_forms
 $spec_profile_sql = sprintf("select * from mp_spec_profile where spec_id = '%s' ", mysql_real_escape_string($id));
 $spec_profile_forms = $spec_profile_dao->get_rows($spec_profile_sql);
 //print_r($spec_profile_forms);exit;
 // get spec_fee_forms
 $spec_fee_sql = sprintf("select * from mp_spec_fee where spec_id = '%s'", mysql_real_escape_string($id));
 $spec_fee_forms = $spec_fee_dao->get_rows($spec_fee_sql);
 // set id
 $forms['id'] = $id;

Ejemplo n.º 3

Archivo: specialist_edit.php Proyecto: BGCX262/zuozhenshi-prego-svn-to-git

     $pay_spec_name = $spec_data['spec_name'];
     $pay_values = array();
     $pay_values['spec_name'] = $pay_spec_name;
     $where = "spec_id = '{$pay_spec_id}' ";
     if ($payment_dao->editbywhere($where, $pay_values)) {
     } else {
         $executeflg = FALSE;
         break;
     }
 } else {
     $executeflg = FALSE;
     break;
 }
 if ($executeflg) {
     $sql = sprintf("select * from mp_spec_traffic_fee where spec_id = '%s'", $forms['id']);
     $dbarray = $traffic_fee_dao->get_rows($sql);
     foreach ($dbarray as $k => $v) {
         // set del flag
         $delflag = true;
         $traffic_name_val = "";
         $traffic_fee_val = "";
         $traffic_memo_val = "";
         foreach ($forms['mutirow'] as $kk => $vv) {
             if ($v['id'] == $vv['id']) {
                 $delflag = false;
                 $traffic_name_val = $vv['traffic_name'];
                 $traffic_fee_val = $vv['traffic_fee'];
                 $traffic_memo_val = $vv['traffic_memo'];
                 $d_time_val = $vv['d_time'];
             }
         }