เว็บบอร์ด PHP เว็บส่งเสริมการเรียนรู้ Hosting CRM ERP Server Programming ถาม-ตอบปัญหา

Code: Select all

function load_data(k,s,d)
    {
        $(".content").html('<div style="text-align:center"><img src="../images/loading_wh.gif"></div>');    
        $(".content").load("page3.php?k="+k+"&s="+s+"&d="+d+"&rand={TIME}");
    }

Code: Select all

$or = array('TRUCK ASC','PRODUCT ASC','COMPANY ASC','TMIN ASC','TRUCK DESC','PRODUCT DESC','COMPANY DESC','TMIN DESC');

if($_GET['s']=='DESC'||$_GET['s']==''){
    $template->assign_vars(array( 
        'S'         => 'ASC',
    ));
}else {
    $template->assign_vars(array( 
        'S'         => 'DESC',
    ));
}
if($_GET['k']=='a'){ 
    if($_GET['s']!='ASC'){
        $fd = $or[0];
    }else{
        $fd = $or[4];
    }
}else if($_GET['k']=='b'){
            if($_GET['s']!='ASC'){
                $fd = $or[1];
            }else{
                $fd = $or[5];
            }
      }else if($_GET['k']=='c'){
                if($_GET['s']!='ASC'){
                    $fd = $or[2];
                }else{
                    $fd = $or[6];
                }
            }else{
                $fd = $or[3];
            }
 $sql =  "select 
            TRUCK, 
            TMIN, 
            TMOUT, 
            (W1-W2)/1000 AS sum_w, 
            (W1/1000) AS car_in , 
            (W2/1000) AS car_out, 
            PRODUCT, 
            COMPANY, 
            (W1-W2)/1000 AS wa, 
            (W1-W2)/1000 AS wb                                               
    FROM  wdata 
    WHERE dayin=".set_f_date($sql_m_b)."
        ORDER BY ".$fd."";

Code: Select all

<tr bgcolor="#CCCCCC">
        <td align="center">{L_NUM}</td>
        <td align="center" onclick="load_data('a','{S}','{DD}')" onmouseover="this.style.cursor='pointer';">{L_CAR}</td>
        <td align="center">{L_TIME}</td>
        <td align="center">{L_W}</td>
        <td align="center">{L_WIN}</td>
        <td align="center">{L_WOUT}</td>
        <td align="center" onclick="load_data('b','{S}','{DD}')" onmouseover="this.style.cursor='pointer';">{L_TYPE}</td>
        <td align="center" onclick="load_data('c','{S}','{DD}')" onmouseover="this.style.cursor='pointer';">{L_NAME}</td>
      </tr>

Code: Select all

function load_data(k,d)
    {
        $(".content").html('<div style="text-align:center"><img src="../images/loading_wh.gif"></div>');    
        $(".content").load("page3.php?k="+k+"&d="+d+"&rand={TIME}");
    }

Code: Select all

        <td align="center">{L_NUM}</td>
        <td align="center" onclick="load_data('a','{DD}')" onmouseover="this.style.cursor='pointer';">{L_CAR}</td>
        <td align="center">{L_TIME}</td>
        <td align="center">{L_W}</td>
        <td align="center">{L_WIN}</td>
        <td align="center">{L_WOUT}</td>
        <td align="center" onclick="load_data('b','{DD}')" onmouseover="this.style.cursor='pointer';">{L_TYPE}</td>
        <td align="center" onclick="load_data('c','{DD}')" onmouseover="this.style.cursor='pointer';">{L_NAME}</td>

Code: Select all

$or = array('TRUCK ASC','PRODUCT ASC','COMPANY ASC','TMIN ASC');

if($_GET['k']=='a'){    
    $fd = $or[0];
}else if($_GET['k']=='b'){
            $fd = $or[1];
      }else if($_GET['k']=='c'){
                $fd = $or[2];
            }else{
                $fd = $or[3];
             }
 $sql =  "select 
            TRUCK, 
            TMIN, 
            TMOUT, 
            (W1-W2)/1000 AS sum_w, 
            (W1/1000) AS car_in , 
            (W2/1000) AS car_out, 
            PRODUCT, 
            COMPANY, 
            (W1-W2)/1000 AS wa, 
            (W1-W2)/1000 AS wb                                               
    FROM  wdata 
    WHERE dayin=".set_f_date($sql_m_b)."
        ORDER BY ".$fd."";