
var table ;
    
    function edit_items(itemid,itemName,descrp){
      

       $("#edit_form")[0].reset();

       $("#edit_objid").val(itemid);


       $.ajax({
          url: "models/crul_category.php",
          type:"POST",
          dataType : "JSON",
          data: {"type":"get_edit","obj_id":itemid} ,
          complete:function(){
            
          },
          beforeSend:function(){
            
          },
          success: function(res) {

            if(res.is_success == true){
               
                $("#edit_objname").val(res.data[0].category);
                $("#edit_category_description").val(res.data[0].category_description);
                

                var j= 1;
                for (var i =0; i < res.data.length ; i++) {
                  
                  $("#edit_profile_"+res.data[i].price_profile_id_fk).val(res.data[i].item_sell_price_per_meter);
                  j++;
                }

                $('#edit_form_cont').modal('toggle');
                
                

            }else{

              swal({
                      title: Translation("خطأ"),
                      text: Translation(res.data),
                      confirmButtonColor: "#2196F3",
                      type: "error"
                  });

            }
            
          }
      });


    }

    function delete_items(itemid) {
        // bootstrap modal confirmation box
        swal({
            title: Translation("هل انت متأكد؟!"),
            text: Translation("سوف لن تستطيع استرجاع المعلومات المرتبطة بهذا السجل في حالة المسح"),
            type: "warning",
            showCancelButton: true,
            confirmButtonColor: "#EF5350",
            confirmButtonText: Translation("موافق: امسح!"),
            cancelButtonText: Translation("الغاء الامر"),
            closeOnConfirm: false,
            closeOnCancel: true
        },
        function(isConfirm){
            if (isConfirm) {
              $.ajax({
                url: "models/crul_category.php",
                type:"POST",
                dataType : "JSON",
                data: {"type":"delete","obj_id":itemid} ,
                complete:function(){
                 
                },
                beforeSend:function(){
                 
                },
                success: function(res) {

                  if(res.is_success == true){
                    swal({
                            title: Translation("حذف!"),
                            text: Translation(res.data),
                            confirmButtonColor: "#66BB6A",
                            type: "success"
                        });
                    $(".datatable-column-search-inputs").DataTable().ajax.reload(null, false);
                  }else{
                    swal({
                            title: "Cancelled",
                            text: Translation(res.data),
                            confirmButtonColor: "#2196F3",
                            type: "error"
                        });
                  }
                }
            });
            }
        }); // /confirm
    }

    function hide_item(itemid) {
      
       swal({
           title: Translation("Are You Sure!"),
           text: Translation("You will Hide All the Products Related to this Category!"),
           type: "warning",
           showCancelButton: true,
           confirmButtonColor: "#EF5350",
           confirmButtonText: Translation("Yes, Hide it!"),
           cancelButtonText: Translation("Cancel"),
           closeOnConfirm: false,
           closeOnCancel: true
       },
       function(isConfirm){
           if (isConfirm) {
             $.ajax({
               url: "models/crul_category.php",
               type:"POST",
               dataType: "JSON",
               data: {"type":"hide","obj_id":itemid} ,
               complete:function(){
                // hideLoader();
               },
               beforeSend:function(){
                // showLoader("Deleting Category");
               },
               success: function(res) {
                 if(res.is_success == true){
                   
                   $(".datatable-column-search-inputs").DataTable().ajax.reload(null, false);
                      swal({
                               title: Translation("تمت العملية"),
                               text: Translation(res.data),
                               confirmButtonColor: "#2196F3",
                               type: "success"
                           });
                  }else{
                      swal({
                               title: Translation("خطأ"),
                               text: Translation(res.data),
                               confirmButtonColor: "#2196F3",
                               type: "error"
                           });
                  }
               }
           });
           }
       }); // /confirm
    }

    function show_item(itemid) {
      
       swal({
           title: Translation("Are You Sure!"),
           text: Translation("You will Show All the Products Related to this Category!"),
           type: "warning",
           showCancelButton: true,
           confirmButtonColor: "#EF5350",
           confirmButtonText: Translation("Yes, Show it!"),
           cancelButtonText: Translation("Cancel"),
           closeOnConfirm: false,
           closeOnCancel: true
       },
       function(isConfirm){
           if (isConfirm) {
             $.ajax({
               url: "models/crul_category.php",
               type:"POST",
               dataType: "JSON",
               data: {"type":"show","obj_id":itemid} ,
               complete:function(){
                // hideLoader();
               },
               beforeSend:function(){
                // showLoader("Deleting Category");
               },
               success: function(res) {
                 if(res.is_success == true){
                   
                   $(".datatable-column-search-inputs").DataTable().ajax.reload(null, false);
                      swal({
                               title: Translation("تمت العملية"),
                               text: Translation(res.data),
                               confirmButtonColor: "#2196F3",
                               type: "success"
                           });
                  }else{
                      swal({
                               title: Translation("خطأ"),
                               text: Translation(res.data),
                               confirmButtonColor: "#2196F3",
                               type: "error"
                           });
                  }
               }
           });
           }
       }); // /confirm
    }


$(document).ready(function() {
  
    $('#add_form').submit(function(event) {
            event.preventDefault();
        
            var name            = $("#objname").val();
            var profile_1       = $("#profile_1").val();
            var profile_2       = $("#profile_2").val();
            var profile_3       = $("#profile_3").val();
            var profile_4       = $("#profile_4").val();
            var profile_5       = $("#profile_5").val();
            var cat_desc        = $("#category_description").val();

            var Check1 = true;
            var Check2 = true;

            if(name =='') {
               $("#objname").closest('.form-group').removeClass('has-success');
               $("#objname").closest('.form-group').addClass('has-error');
               Check1 = false;
               noty({
                        width: 200,
                        text: Translation("الرجاء قم بادخال اسم الصنف"),
                        type: 'error',
                        dismissQueue: true,
                        timeout: 3000,
                        layout: 'top',
                  });
            }else{
               $("#objname").closest('.form-group').removeClass('has-error');
               $("#objname").closest('.form-group').addClass('has-success');
            }

          

            if(Check1 && Check2){
              $("#submit_add_btn").attr('disabled',true);
                $.ajax({
                    url: "models/crul_category.php",
                    type:"POST",
                    dataType : "JSON",
                    data : {name                  :name,
                            category_description  :cat_desc,
                            profile_1  :profile_1,
                            profile_2  :profile_2,
                            profile_3  :profile_3,
                            profile_4  :profile_4,
                            profile_5  :profile_5,
                            type:'create'}
                })
                .done(function(res) {
                  //alert(res);
                  if(res.is_success == true){
                      $("#add_form")[0].reset();
                      $(".datatable-column-search-inputs").DataTable().ajax.reload(null, false);
                      $("#add-form-cont").collapse('hide');
                      noty({
                                      width: 200,
                                      text: Translation(res.data),
                                      type: 'success',
                                      dismissQueue: true,
                                      timeout: 3000,
                                      layout: 'topRight',
                                });
                  }else{
                      swal({
                          title: Translation("خطأ"),
                          text: Translation(res.data),
                          confirmButtonColor: "#66BB6A",
                          type: "error"
                      });
                  }
                  $("#submit_add_btn").attr('disabled',false);
                })
                .fail(function(err) {
                   swal({
                      title:  Translation("خطأ"),
                      text:   (err),
                      confirmButtonColor: "#66BB6A",
                      type: "error"
                    });
                   $("#submit_add_btn").attr('disabled',false);
                })
                .always(function() {
                    console.log("complete");
                });
            }

    });


     // submit editable Visa Application form
  $('#edit_form').submit(function(event) {
            event.preventDefault();
        
            var name        = $("#edit_objname").val();
            var catId       = $("#edit_objid").val();
            var cat_desc    = $("#edit_category_description").val();

            var profile_1   = $("#edit_profile_1").val();
            var profile_2   = $("#edit_profile_2").val();
            var profile_3   = $("#edit_profile_3").val();
            var profile_4   = $("#edit_profile_4").val();
            var profile_5   = $("#edit_profile_5").val();

            var Check1 = true;
            var Check2 = true;

            if(name =='') {
               $("#edit_objname").closest('.form-group').removeClass('has-success');
               $("#edit_objname").closest('.form-group').addClass('has-error');
               Check1 = false;
               noty({
                        width: 200,
                        text: Translation("الرجاء قم بادخال اسم الفئة"),
                        type: 'error',
                        dismissQueue: true,
                        timeout: 3000,
                        layout: 'top',
                  });
            }else{
               $("#edit_objname").closest('.form-group').removeClass('has-error');
               $("#edit_objname").closest('.form-group').addClass('has-success');
            }

           

            if(Check1 && Check2 ){
                $.ajax({
                    url: "models/crul_category.php",
                    type:"POST",
                    dataType : "JSON",
                    data : {name                  :name,
                            category_description  :cat_desc,
                            profile_1             :profile_1,
                            profile_2             :profile_2,
                            profile_3             :profile_3,
                            profile_4             :profile_4,
                            profile_5             :profile_5,
                            obj_id                :catId,
                            type                  :'update'},
                    complete:function(){
                      //hideLoader();
                    },
                    beforeSend:function(){
                      //showLoader("Updating Category");
                    },
                    success: function(res) {
                      if(res.is_success == false){
                          
                          $('#edit_form_cont').modal('toggle');
                          $("#edit_form")[0].reset();
                          swal({
                              title:Translation("خطأ"),
                              text: Translation(res.data),
                              confirmButtonColor: "#66BB6A",
                              type: "warning"
                          });
                      
                      }else{

                          $("#edit_form")[0].reset();
                          $(".datatable-column-search-inputs").DataTable().ajax.reload(null, false);

                          $('#edit_form_cont').modal('toggle');
                          noty({
                                  width: 200,
                                  text: Translation(res.data), //'Product Successfully Update',
                                  type: 'success',
                                  dismissQueue: true,
                                  timeout: 3000,
                                  layout: 'topRight',
                                });
                      }
                    }
                });
              }
    });

    
    

});






$(function() {
//var singleSelect = $('.datatable-column-search-inputs').DataTable();
    


    

   // Setting datatable defaults
    $.extend( $.fn.dataTable.defaults, {
        autoWidth: false,
        columnDefs: [{ 
            orderable: false,
            width: '100px',
            targets: [ 4 ]
        }],
        dom: '<"datatable-header"fBl><"datatable-scroll"t><"datatable-footer"ip>',
        language: {
            search: '<span>'+Translation('بحث')+':</span> _INPUT_',
            searchPlaceholder: Translation('بحث عن')+'...',
            lengthMenu: '<span>'+Translation('عرض')+':</span> _MENU_',
            paginate: { 'first': 'First', 'last': 'Last', 'next': '&'+Left_Arraw+'arr;', 'previous': '&'+Right_Arraw+'arr;' }
        },
        drawCallback: function () {
            $(this).find('tbody tr').slice(-3).find('.dropdown, .btn-group').addClass('dropup');
        },
        preDrawCallback: function() {
            $(this).find('tbody tr').slice(-3).find('.dropdown, .btn-group').removeClass('dropup');
        }
    });

    

    // Individual column searching with text inputs
    $('.datatable-column-search-inputs tfoot td').not(':last-child').each(function () {
        var title = $('.datatable-column-search-inputs thead th').eq($(this).index()).text();
        $(this).html('<input type="text" class="form-control input-sm" placeholder="'+Translation('بحث عن')+' '+title+'" />');
    });
    
    

   
   var table = $('.datatable-column-search-inputs').DataTable({
        buttons: {            
            buttons: [
                {
                    extend: 'copyHtml5',
                    className: 'btn btn-default',
                    exportOptions: {
                        columns: [ 0, ':visible' ]
                    }
                },
                {
                    extend: 'excelHtml5',
                    className: 'btn btn-default',
                    exportOptions: {
                        columns: ':visible'
                    }
                },
                {
                    extend: 'pdfHtml5',
                    className: 'btn btn-default',
                    exportOptions: {
                        columns: ':visible'
                    }
                },
                {
                    extend: 'print',
                    className: 'btn btn-default',
                    exportOptions: {
                        columns: ':visible'
                    }
                },
                {
                    extend: 'colvis',
                    text: '<i class="icon-three-bars"></i> <span class="caret"></span>',
                    className: 'btn bg-blue btn-icon'
                }
                
            ]
        },
        lengthMenu: [
            [  10, 25, 50, 100 ],
            [  '10', '25', '50', '100' ]
        ],
        "processing": true,
        "serverSide": true,
        "ajax": {
        "url" : "models/crul_category.php",
        "data": function(d){
          d.type = "load";
        }
        },
        drawCallback: function() {
                  $('[data-popup=tooltip]').tooltip();
                  $('[data-popup=popover-custom]').popover({
                    template: '<div class="popover  border-teal-400"><div class="arrow"></div><h3 class="popover-title bg-teal-400"></h3><div class="popover-content"></div></div>'
                  });

            },
        "columnDefs": [
          {
              "targets": 6,
              "data": null,
              "render": function (data,type,row) {

                        if(IS_VIEW==0){

                            if(row[5]==0){
                                var status= `<li class='text-danger-600'>
                                                <a  class='text-warning' onclick="hide_item(`+row[0]+`)" data-popup='tooltip' data-original-title='`+Translation('Hide All its Products')+`'>
                                                    <i class='icon-eye-blocked icon-2x'></i>
                                                </a>
                                            </li>`;
                            }else{
                                var status= `<li class='text-danger-600'>
                                                    <a  class='text-success-400' onclick="show_item(`+row[0]+`)" data-popup='tooltip' data-original-title='`+Translation('Show All its Products')+`'>
                                                        <i class='icon-eye icon-2x'></i>
                                                    </a>
                                                </li>`;
                            }
                            return  `<ul class='icons-list pull-right'>
                                        ${status}
                                        <li class='text-primary-600'>
                                            <a  class='text-primary-400' onclick="edit_items(`+row[0]+`,'`+escapeHtml(row[1])+`','`+escapeHtml(row[2])+`')" data-popup='tooltip' data-original-title='`+Translation('تحرير')+`'>
                                                <i class='icon-pencil7 icon-2x'></i>
                                            </a>
                                        </li>

                                        <li class='text-danger-600'>
                                            <a  class='text-danger-400' onclick="delete_items(`+row[0]+`)" data-popup='tooltip' data-original-title='`+Translation('حذف')+`'>
                                                <i class='icon-trash icon-2x'></i>
                                            </a>
                                        </li>

                                    </ul>`;
                        }else{
                          return '';
                        }

                }
          },

          {
             "render": function(data, type, row){


                      return  `<a href='index.php?p=product&id=`+row[0]+`'  data-popup='tooltip' data-original-title='`+Translation('عرض جميع المواد التابعة لهذه الفئة')+`'>`+data+`</a>`;


             },
             "targets": 1
          },

          {
             "render": function(data, type, row){

                   if(data ==0){
                     status = '<span class="label bg-success  btn-block ">'+Translation('Show')+'  </span>';
                   }else {
                     status = '<span class="label bg-violet  btn-block ">'+Translation('Hidden')+'  </span>';
                   }
                      // return  `<a href='index.php?p=invoice&id=`+row[0]+`'  data-popup='tooltip' data-original-title='Show All Invoices for this Customer'>`+data+`</a>`;
                      return  status;


             },
             "targets": 5
          },
            
           
        ],
        "fnRowCallback": function (nRow, aData, iDisplayIndex, iDisplayIndexFull) {


            if(   aData[4] == 0 ){
                $(nRow).children().each(function (index, td) {
                    $(this).addClass('warning-active');
                });
            }
        },
        "order": [[0,'desc']],
                "displayLength": 25,
 

        initComplete: function () {
         
        // $("div.datatable-header").append(`<a  style="margin-left:15px;" class="btn bg-info-400"  id="headerBtn" onclick="add_item()"> <i class="icon-file-pdf position-right"></i> Add Category </a>`);   
        if(IS_VIEW==0){
            
            $("div.datatable-header").append(`<a data-toggle="collapse"
                                      style="margin-right:10px;"
                                      data-target="#add-form-cont"
                                      href="javascript:;"
                                      aria-controls="add-form-cont"
                                      aria-expanded="false"
                                      class="btn btn-primary"
                                      id="add_Item_Btn">
                                        <i class="`+CURRENT_BTN_ICON+`"></i> `+Translation(CURRENT_BTN)+`
                                    </a>`);  
        }


            this.api().columns().every( function() {
                var column = this;
                

            });
        }
    });

    
    table.columns().every( function () {
        var that = this;
        $('input', this.footer()).on('keyup change', function () {
            that.search(this.value).draw();
        });
    });


    // Single row selection
    
    $('.datatable-column-search-inputs tbody').on('click', 'tr', function() {
        if ($(this).hasClass('success')) {
            $(this).removeClass('success');
        }
        else {
            table.$('tr.success').removeClass('success');
            $(this).addClass('success');
        }
    });


         // change filter to top
    $('.datatable-column-search-inputs tfoot tr').insertAfter($('.datatable-column-search-inputs thead tr'))


    $('.dataTables_length select').select2({
        minimumResultsForSearch: Infinity,
        width: 'auto'
    });


});



