$("#student-status-dialog").dialog({
         autoOpen: false,
         minWidth: 400,
         minHeight: 400,
         modal: true,
         position: { my: 'center', at: 'center' }
      });

      $("#menu-category-dialog").dialog({
         autoOpen: false,
         minWidth: 400,
         minHeight: 400,
         modal: true,
         position: { my: 'center', at: 'center' }
      });

      $("#flex-access-dialog").dialog({
         autoOpen: false,
         minWidth: 400,
         minHeight: 400,
         modal: true,
         position: { my: 'center', at: 'center' }
      });

      $("#student-delivery-locations-dialog").dialog({
         autoOpen: false,
         minWidth: 400,
         minHeight: 400,
         modal: true,
         position: { my: 'center', at: 'center' }
      });


      $(document).on('click touch', '.menu-price-category-data-span', function(e) {
         e.preventDefault();

         var value = $(this).html();
         var rnum  = $(this).attr('rnum');
         var fid   = $(this).attr('id');

         switch (value) {
            case 'Regular':
               value = 'Special 1';
               break;

            case 'Special 1':
               value = 'Special 2';
               break;

            case 'Special 2':
               value = 'Special 3';
               break;

            case 'Special 3':
               value = 'Regular';
               break;
         }

         $.ajax({
            url: 'ajax.UpdateDBField.php',
            data: {
                  table_name: 'people',
                  field_name: 'menu_price_category',
                  field_value: value,
                  field_type: 'text',
                  record_num: rnum
                  },
            dataType: 'json'
         }).done(function(results) {
            $("#"+fid).html(value);
            if (value == 'Regular') $("#mpc-span-"+rnum).removeClass('warning');
            else $("#mpc-span-"+rnum).addClass('warning');
         });
      });

      $(document).on('click touch', '.status-data-span', function(e) {
         e.preventDefault();

         var value = $(this).html();
         var rnum  = $(this).attr('rnum');
         var fid   = $(this).attr('id');

         switch (value) {
            case 'Unverified':
               value = 'Verified';
               break;

            case 'Verified':
               value = 'Inactive';
               break;

            case 'Inactive':
               value = 'Unverified';
               break;
         }

         $.ajax({
            url: 'ajax.UpdateDBField.php',
            data: {
                  table_name: 'people',
                  field_name: 'status',
                  field_value: value,
                  field_type: 'text',
                  record_num: rnum
                  },
            dataType: 'json'
         }).done(function(results) {
            $("#"+fid).html(value);
         });
      });

      $("#view-selected-records").on('click touch', function(e) {
         e.preventDefault();
         loadSelected();
      });

      function loadSelected() {
         var cnum = $("#selected-class-num").val();
         var mcat = $("#selected-menu-category").val();
         var title = '';
         var where = '';
         var text;

         if (cnum > 0) {
            where += "AND class_num = "+cnum+" ";
            if (title.length) title += ' - ';
            title += $("#selected-class-num option:selected").text();
         }

         if (mcat != undefined && mcat != 0) {
            where += "AND menu_price_category = '"+mcat+"' ";
            if (title.length) title += ' - ';
            title += $("#selected-menu-category option:selected").text();
         }

         $("#custom-where").val(where);

         $("#student-people-message-div").html('<b>'+title+'</b>');
         loadRecords();
      }

      $(document).on('click touch', '.class-num-data-span', function() {
         var cnum = $(this).attr('ref-num');
         cnum = Math.abs(cnum);
         if (cnum > 0) {
            $("#custom-where").val("AND class_num = "+cnum+" ");
         }
         loadRecords();
      });

      $("#update-student-price-category").on('click touch', function(e) {
         e.preventDefault();

         $("#selected-menu-price-category").val('');
         $("#selected-menu-price-class").val(0);

         $("#selected-menu-price-category").removeClass('missing-data');

         $("#menu-category-dialog").dialog('open');
      });

      $("#update-menu-category-btn").on('click touch', function(e) {
         e.preventDefault();

         var category = $("#selected-menu-price-category").val();
         var class_num = $("#selected-menu-price-class").val();

         if (category == '') {
            $("#selected-menu-price-category").addClass('missing-data');
            return;
         }

         if (class_num == 0) {
            var ans = confirm('<?php displayLanguageText('TEXT-CONFIRM-UPDATE-ALL-STUDENTS'); ?>');
            if (!ans) return;
         }

         $.ajax({
            url: 'ajax.UpdateDatabase.php',
            data: {
                  table_name: 'student-people',
                  dataset: 'menu-price-category',
                  price_category: category,
                  class_num: class_num
                  },
            dataType: 'json'
         }).done(function(results) {
            $("#menu-category-dialog").dialog('close');
            loadRecords();
         });
      });

      $("#selected-menu-price-category").change(function() {
         $("#selected-menu-price-category").removeClass('missing-data');
      });


      $("#update-student-flex-flag").on('click touch', function(e) {
         e.preventDefault();

         $("#flex-access-dialog").dialog('open');
      });

      $("#update-flex-flag-btn").on('click touch', function(e) {
         e.preventDefault();

         var flex_flag = $("#selected-flex-access-flag").val();
         var class_num = $("#selected-flex-access-class").val();

         if (class_num == 0) {
            var ans = confirm('<?php displayLanguageText('TEXT-CONFIRM-UPDATE-ALL-STUDENTS'); ?>');
            if (!ans) return;
         }

         $.ajax({
            url: 'ajax.UpdateDatabase.php',
            data: {
                  table_name: 'student-people',
                  dataset: 'flex-access-flag',
                  flex_flag: flex_flag,
                  class_num: class_num
                  },
            dataType: 'json'
         }).done(function(results) {
            $("#flex-access-dialog").dialog('close');
            loadRecords();
         });
      });


      $("#update-student-status").on('click touch', function(e) {
         e.preventDefault();

         $("#selected-status-value").val('Verified');
         $("#student-status-dialog").dialog('open');
      });

      $("#update-student-status-btn").on('click touch', function(e) {
         e.preventDefault();

         var student_status = $("#selected-status-value").val();
         var class_num = $("#selected-status-class").val();

         if (class_num == 0) {
            var ans = confirm('<?php displayLanguageText('TEXT-CONFIRM-UPDATE-ALL-STUDENTS'); ?>');
            if (!ans) return;
         }

         $.ajax({
            url: 'ajax.UpdateDatabase.php',
            data: {
                  table_name: 'student-people',
                  dataset: 'student-status',
                  student_status: student_status,
                  class_num: class_num
                  },
            dataType: 'json'
         }).done(function(results) {
            $("#student-status-dialog").dialog('close');
            loadRecords();
         });
      });


      $("#update-student-delivery-location").on('click touch', function(e) {
         e.preventDefault();

         $("#selected-delivery-location").val('');
         $("#student-delivery-locations-dialog").dialog('open');
      });

      $("#update-student-delivery-locations-btn").on('click touch', function(e) {
         e.preventDefault();

         var delivery_location = $("#selected-delivery-location").val();
         var class_num = $("#selected-status-class").val();

         if (class_num == 0) {
            var ans = confirm('<?php displayLanguageText('TEXT-CONFIRM-UPDATE-ALL-STUDENTS'); ?>');
            if (!ans) return;
         }

         $.ajax({
            url: 'ajax.UpdateDatabase.php',
            data: {
                  table_name: 'student-people',
                  dataset: 'student-delivery-locations',
                  delivery_location: delivery_location,
                  class_num: class_num
                  },
            dataType: 'json'
         }).done(function(results) {
            $("#student-delivery-locations-dialog").dialog('close');
            loadRecords();
         });
      });


      $(document).on('click touch', '.num-allergies-data-span, .allergy-info', function(e) {
         e.preventDefault();

         var num = $(this).html();
         var rnum = $(this).attr('rnum');
         if (num == '' || num == '0') return;

         $.getJSON("ajax.DataTable.Fetch.php",
            {
               table_name: 'people',
               action: 'student-allergy-info',
               sequence_flag: 'N',
               person: rnum
            },
            function(results) {
               var display_data = '';
               display_data += "<center><table><tr><td class='ltext'>" +
                               results.content +
                               "</td></tr></table></center>";

               $("#small-info-dialog-data-div").html(display_data);
               $("#small-info-dialog").dialog('open');
            }
         );
      });


      $(".close-dialog").on('click touch', function(e) {
         e.preventDefault();

         var dialog_name = $(this).attr('dialog-name');
         if (dialog_name == undefined) {
            alert('dialog-name not defined');
            return;
         }
         $("#"+dialog_name).dialog('close');
      });