salesOrder.prg

<?php
/* File: salesOrder.html
 * Purpose: To initialize grid and CRUD calls on the salesOrder page
 */

$isInEditList = GetIsInEditList($dbh, $Hu);
?>

<script type="text/javascript">

<?php
// Get common JS functions here.
getAddMinifiedActionStyleFunction();
getShowWaitFunctions();
?>

<?php
/* This function initializes the sales order grid.
 */ ?>
var cuList = [];
function PopulateSalesOrderGrid() {
    $.homecuValidator.setup({formValidate:'formMain', formStatusField: 'formValidateMainDiv'});

    var showAll = false;
    var currentEmployeeId;
    var tooltips = [];
    var disallowAdd = false;
    var grid = $("#salesOrderGrid").kendoGrid({
        dataSource: {
            transport: {
                read: {
                    url: "index.prg?operation=salesOrderLoad",
                    dataType: "json",
                    type: "POST"
                },
                create: {
                    url: "index.prg?operation=salesOrderCreate",
                    dataType: "json",
                    type: "POST"
                },
                update: {
                    url: "index.prg?operation=salesOrderUpdate",
                    dataType: "json",
                    type: "POST"
                },
                parameterMap: function(data, type) {
                    showWaitWindow();
                    if (type === "read") {
                        return {initializeDDLs: cuList.length == 0 ? "Y" : "N"};
                    } else {
                        data.date = data.date == null || data.date == "Invalid Date" ? "" : kendo.toString(data.activeDate, "yyyy-MM-dd");
                        data.emailable = data.emailable ? "Y" : "N";
                        return data;
                    }
                }
            },
            schema: {
                parse: function (data) {
                    hideWaitWindow();

                    if (data.operation == "read") {
                      $('#salesOrderGrid .simpleFilter').focus();
                    }

                    if (data.status !== "000") {
                        $.homecuValidator.displayMessage(data.error, $.homecuValidator.settings.statusError );
                        return [];
                    } else {
                        if (data.cuList != null && data.cuList.length > 0) {
                            cuList = data.cuList;
                        }

                        if (data.currentEmployeeId != null) {
                           currentEmployeeId = data.currentEmployeeId;
                        }

                        return data.record;
                    }
                },
                model: {
                    id: "salesOrderId",
                    fields: {
                        salesOrderId: {type: "number", editable: false, nullable: false},
                        cuNumber: {type: "string"},
                        date: {type: "date", editable: false},
                        refNo: {type: "string"},
                        employee: {type: "string"},
                        cuName: {type: "string"},
                        isClosed: {type: "boolean"},
                        emailable: {type: "boolean"}
                    }
                }
            }
        },
        columns: [
            {command: [<?php if ($isInEditList) { ?> {name: "edit", text: "", iconClass: "fa fa-edit"}, <?php } ?>
                    {name: "openDetails", text: "", iconClass: "fa fa-indent",
                        click: function (e) {
                            var row = $(e.target).closest("tr");
                            var dataItem = $("#salesOrderGrid").data("kendoGrid").dataItem(row);
                            var url = "<?php echo $produrl . GetBillingURL(); ?>?page=salesOrderDetails&salesOrderId="+ dataItem.salesOrderId;
                            showWaitWindow();
                            window.location.replace(url);
                        }
                    }], width: "10%"},
            {command: [{name: "showInvoice", text: "Show Invoice",
                        click: function (e) {
                            var row = $(e.target).closest("tr");
                            var dataItem = $("#salesOrderGrid").data("kendoGrid").dataItem(row);
                            var url = "<?php echo $produrl . GetBillingURL(); ?>?page=invoiceView&cu="+ dataItem.cuNumber;
                            showWaitWindow();
                            window.location.replace(url);
                            return false;
                        }
                    }
                ]},
            {field: "isClosed", title: "Closed", template: "# if (isClosed) { # C # } else { # # } #", width: "10%"},
            {field: "cuName", title: "CU Name"},
            {field: "cuNumber", title: "CU", width: "15%"},
            {field: "date", title: "Date", format: "{0:MM/dd/yyyy}", width: "10%"},
            {field: "refNo", title: "Reference"},
            {field: "emailable", title: "Email?"},
            {field: "employee", title: "Employee", width: "13%"},

        ],
        sortable: true,
        filterable: {extra: false},
        toolbar: [ <?php if ($isInEditList) { ?> {name: "addSingle", text: "", iconClass: "fa fa-plus"}, <?php } ?>
          {name: "simpleFilter", template: "&nbsp; CU Filter: <input class=\"k-input simpleFilter\" type=\"text\">"}],
        <?php if ($isInEditList) { ?>
        editable: {
            mode: "popup",
            template: kendo.template($("#popupTemplate").html()),
            window: {
                draggable: false,
                resizable: false,
                actions: [],
                width: 500
            }
        },
        edit: function (e) {
            disallowAdd = false;
            $.homecuValidator.setup({formValidate:'popupForm', formStatusField: 'formValidatePopupDiv'});

            var popupWindow = e.sender.editable.element.data("kendoWindow");
            popupWindow.title(e.model.isNew() ? "Add Sales Order" : "Edit Sales Order");

            if (e.model.isNew()) {
              $("input[name='cuNumber']").show();
              $("#cuLabel").hide();

              var cuKey = {};
              var cuAvailable = [];
              var gridData = $("#salesOrderGrid").data("kendoGrid").dataSource.data();
              for(var i = 0, count = gridData.length; i != count; i++) {
                  var key = gridData[i].cuNumber.trim().toUpperCase();
                  cuKey[key] = true;
              }
              for(var i = 0, count = cuList.length; i != count; i++) {
                  var key = cuList[i].value.trim().toUpperCase();
                  if (cuKey[key] == null) {
                      cuAvailable.push(cuList[i]);
                  }
              }
              disallowAdd = cuAvailable.length == 1;

              var cuCombobox = $("input[name='cuNumber']").kendoDropDownList({
                  dataSource: cuAvailable,
                  filter: "startswith",
                  dataTextField: "text",
                  dataValueField: "value"
              }).data("kendoDropDownList");

              <?php // Add won't have anything ?>
              if (e.model.isNew()) {
                  e.model.cuNumber = cuCombobox.value();
              }
            } else {
              $("input[name='cuNumber']").hide();
              $("#cuLabel").show();
            }


        },
        save: function (e) {
            if (!$.homecuValidator.validate()) {
                e.preventDefault();
                return false;
            } else {
                $.homecuValidator.setup({formValidate:'formMain', formStatusField: 'formValidateMainDiv'});

                if (disallowAdd) {
                    $("#salesOrderGrid .k-grid-addSingle").data("kendoButton").enable(false);
                }
            }
        },
        <?php } ?>
        dataBound: function (e) {
            for (var i = 0; i != tooltips.length; i++) {
                tooltips[i].destroy();
            }
            tooltips = addMinifiedActionStyle("#salesOrderGrid", true, [{filter: ".k-grid-openDetails", content: "Open Sales Details"},
                {filter: ".k-grid-addSingle", content: "Add new record"}]);

            var cuKey = {};
            var cuAvailable = [];
            var gridData = $("#salesOrderGrid").data("kendoGrid").dataSource.data();
            for(var i = 0, count = gridData.length; i != count; i++) {
              var key = gridData[i].cuNumber.trim().toUpperCase();
              cuKey[key] = true;
            }
            for(var i = 0, count = cuList.length; i != count; i++) {
              var key = cuList[i].value.trim().toUpperCase();
              if (cuKey[key] == null) {
                  cuAvailable.push(cuList[i]);
              }
            }

            if (cuAvailable.length == 0) {
                $("#salesOrderGrid .k-grid-addSingle").data("kendoButton").enable(false);
            }
        }
    }).data("kendoGrid");



  <?php if ($isInEditList) { ?>
  $("#salesOrderGrid .k-grid-addSingle").kendoButton({
    click: function () {
      grid.addRow();
      return false;
    }
  });
  <?php } ?>

    $("#salesOrderGrid .simpleFilter").keyup(function (e) {
      var text = $(this).val().trim();
      if (text == "") {
          grid.dataSource.filter({});
      } else {
          grid.dataSource.filter({ field: "cuNumber", operator: "contains", value: text});
      }
    });
}

$(document).ready(function () {
    PopulateSalesOrderGrid ();
});
</script>
<?php if ($isInEditList) { ?>
<script id="popupTemplate" type="text/x-kendo-template">
       <div id="formValidatePopupDiv" style="display:none;"></div>
        <div class="container_12" id="popupForm">
            <div class="grid_12">
                <div class="grid_4 alpha">
                    <label data-for="cuNumber">CU:</label>
                </div>
                <div class="grid_7">
                    <input type="text" name="cuNumber" style="width:100%; display: none;"
                        data-duplicate-msg="Contract for CU already exists">
                    <div id="cuLabel" style="display: none;">#: cuNumber #</div>
                </div>
                <div class="grid_1 omega">
                    <span data-for='cuNumber' class='k-invalid-msg'></span>
                </div>
            </div>
            <div class="grid_12">
                <div class="grid_4 alpha">
                    <label data-for="refNo">Reference:</label>
                </div>
                <div class="grid_7">
                    <input type="text" class="k-input" name="refNo" style="width:100%" maxlength=20>
                </div>
                <div class="grid_1 omega">
                    <span data-for='refNo' class='k-invalid-msg'></span>
                </div>
            </div>
            <div class="grid_12">
                <div class="grid_4 alpha">
                    <label data-for="emailable">Email?:</label>
                </div>
                <div class="grid_7">
                    <input type="checkbox" name="emailable">
                </div>
                <div class="grid_1 omega">
                    <span data-for='emailable' class='k-invalid-msg'></span>
                </div>
            </div>
        </div>
</script>
<?php } ?>
<div class="container_12">
    <div id="formMain"></div>
    <div id="formValidateMainDiv" style="display:none;"></div>
    <div class="grid_12">
        <div id="salesOrderGrid"></div>
    </div>
</div>