基于 PHP+jQuery 開發的表格組件 - zGrid

openkk 12年前發布 | 51K 次閱讀 jQuery jQuery表格插件 jQuery插件

這是一個基于 PHP/Ajax/jQuery 開發的表格組件。

基于 PHP+jQuery 開發的表格組件 - zGrid

var targetUrl = "listing.php"; // show all records

// update status
function update_status(id)
{
    if (document.getElementById(id).checked == false) 
    var status = 0;
    else
    var status = 1;

    $("#message").text('');
    var id = id.replace('active_','');

    $.ajax({
        type: 'post',
        url: 'update_status.php',           
        data: 'id='+id+"&status="+status,
        beforeSend: function(){

            $("#loader-"+id).show();
        },
        success: function(e){
            $("#loader-"+id).hide();
            if(e==1)
            $("#message").append("<span>Status has been activated.</span>");
            else
            $("#message").append("<span>Status has been inactivated.</span>");
        }
    });
}

// update order 
$(document).ready(function(){
    $('#sortable').sortable({
        update: function(event, ui) {
            var itemOrder = $(this).sortable('toArray').toString();

            $.get('update_order.php', {itemOrder:itemOrder});
        }
    });
});


$(document).ready(function(){   
/// first time record 
var content = $("#sortable"); // main content ul
//content.load(targetUrl);

// delete record

$('a#delete').livequery('click', function(e) {
    if(confirm('Are you sure you want to delete this record?')==false)
    return false;
    e.preventDefault();
    var parent  = $(this).parent();
    var temp    = parent.attr('id').replace('delete-','');
    var main_tr = $('#id-'+temp);

        $.ajax({
            type: 'get',
            url: 'delete.php?id='+ parent.attr('id').replace('delete-',''),
            data: '',
            beforeSend: function(){
            },
            success: function(){
                main_tr.fadeOut(700,function(){
                    main_tr.remove();
                });
            }
        });
    });

    // sorting records
    $('.hover').click(function(){
         var content = $("#sortable"); // main content ul
         content.load(targetUrl+'?sort='+$(this).html());
         $('.hover').css('background-color','');
         $(this).css('background-color','#99CC99');
    });

});

// formValidation
function validateFrm(formType)
{
    if($('#email').val().length < 1 || $('#name').val().length < 1){
        alert('Please fill the required field.');
    }
    else
    {
        var formParam = $("#customForm").serialize(); 
        if(formType == 'add')
        {
            var file = 'add_record.php';
            var message = 'Record Added !';
        }
        else
        {
            var file = 'update_record.php';
            var message = 'Record Updated !';
        }

        $.post(file+"?"+formParam,{
        }, function(response){

             get_result = response;
            if(response == 1)
            { 
                $('#faceBoxmessage').fadeOut();
                 $('#faceBoxmessage').html(unescape(message));
                 $('#faceBoxmessage').fadeIn();

                 setTimeout(" $.facebox.close();",1000)
                 //////////////
                 var content = $("#sortable"); // main content ul
                 content.load(targetUrl);
                 $('.hover').css('background-color','');
            }
        });
    }
}

在線演示:http://demos.99points.info/zgrid/

項目主頁:http://www.baiduhome.net/lib/view/home/1330480426311

 本文由用戶 openkk 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
 轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!