آموزش پروژه محور درج رکورد

function detailInit(e) {
    // get a reference to the current row being initialized
    var detailRow = e.detailRow;
    employeeTerritoriesDS = new kendo.data.DataSource({
            transport: {
                    read: "data/employeeTerritories.php",
                    create: {
                        url: "data/employeeTerritories.php",
                        type: "PUT"
                    }
            },
            schema: {
                data: "data",
                model: {
                    id: "EmployeeTerritoryID"
                }
            },
            serverFiltering: true,
            filter: { field: "EmployeeID", operator: "eq", value:e.data.EmployeeID }
        });
    // create a subgrid for the current detail row, getting territory data for this employee
    detailRow.find(".subgrid").kendoGrid({
        dataSource: employeeTerritoriesDS,
        columns: [{ title: "Territories", field: "TerritoryDescription" }],
        toolbar: [ "save" ],
        editable: true,
        navigable: true
    }); 
};                             

<script type="text/x-kendo-template" id="template">
    <div>
        <div style="margin-bottom: 10px;">
            <input id="territory_#= data.EmployeeID #" class="comboBox" />
            <button class="k-button add-territory" data-employee-id="#= data.EmployeeID #" onclick="addTerritory(this)" >Add</button>
        </div>
        <div class="subgrid"></div>
    </div>
</script>

function detailInit(e) {
    // get a reference to the current row being initialized
    var detailRow = e.detailRow;
    

    //کدهای مربوط به جدول داخلی یعنی جدول بخش های فروش در این قسمت قرار دارد
    
    // پیکربندی دیتا سورس
    territoriesDS = new kendo.data.DataSource({
        transport: {
            read: "data/territories.php?EmployeeID=" + e.data.EmployeeID
        },
        schema: {
            data: "data",
            model: {
                id: "TerritoryID"
            }
        }
    });
    
    // ایجاد کامبو باکس
    detailRow.find(".comboBox").kendoComboBox({
        dataSource: territoriesDS,
        dataTextField: "TerritoryDescription",
        dataValueField: "TerritoryID"
    });            
};            

<?php

    $link = mysql_pconnect("localhost", "root", "3411") or die("Could not connect");

    mysql_select_db("northwind") or die("Could not select database");

    $arr = array();

    // DISCLAIMER: It is better to use PHP prepared statements to communicate with the database.
    //             this provides better protection against SQL injection.
    //             [http://php.net/manual/en/pdo.prepared-statements.php][4]

    // get the parameters from the get. escape them to protect against sql injection.
    $employeeId = mysql_real_escape_string($_REQUEST["EmployeeID"]);

    $rs = mysql_query("SELECT t.TerritoryID, TRIM(t.TerritoryDescription) AS TerritoryDescription 
                        FROM Territories T
                        WHERE TerritoryID NOT IN (SELECT et.TerritoryID FROM EmployeeTerritories et WHERE et.EmployeeID = " .$employeeId.")"
                        ." ORDER BY t.TerritoryDescription ASC");
    while($obj = mysql_fetch_object($rs)) {

        $arr[] = $obj;

    }

    header("Content-type: application/json");

    echo "{\"data\":" .json_encode($arr). "}";

?>

var addTerritory = function(sender) {

    // get the employee id off the data-employee-id attribute of the button
    var employeeId = $(sender).data("employee-id");

    // get a reference to the combobox which contains the selected item
    var comboBox = $("#territory_" + employeeId).data("kendoComboBox");

    // add the item to the datasource - it is thusly added to the grid
    employeeTerritoriesDS.add({ EmployeeID: employeeId, TerritoryDescription: comboBox.text(),  TerritoryID: comboBox.value() });

    // remove the current item from the combobox - it's no longer a valid selection
    territoriesDS.remove(comboBox.value());

    // clear the text of the combobox
    comboBox.text("");
};

data(“kendoWidgetName”)

<?php
    $employeeID = $_REQUEST["filter"]["filters"][0]["value"];
            
    $link = mysql_connect("localhost", "root", "3411") or die("Unable To Connect To Database Server");
    mysql_select_db("northwind") or die("Unable To Connect To Northwind");

    // add the header line to specify that the content type is JSON
    header("Content-type: application/json");

    // determine the request type
    $verb = $_SERVER["REQUEST_METHOD"];

    // handle a GET 
    if ($verb == "GET") {
        $arr = array();

        $rs = mysql_query("SELECT CONCAT(et.EmployeeID, et.TerritoryID) AS EmployeeTerritoryID, t.TerritoryID, e.EmployeeID,
                                TRIM(t.TerritoryDescription) AS TerritoryDescription
                              FROM Territories t
                              INNER JOIN EmployeeTerritories et ON t.TerritoryID = et.TerritoryID
                              INNER JOIN Employees e ON et.EmployeeID = e.EmployeeID
                              WHERE e.EmployeeID =".$employeeID);

        while($obj = mysql_fetch_object($rs)) {
               $arr[] = $obj;
        }
        
        echo "{\"data\":" .json_encode($arr). "}";
    }
    
    if ($verb == "PUT") {
        $request_vars = Array();
        parse_str(file_get_contents('php://input'), $request_vars );

        // DISCLAIMER: It is better to use PHP prepared statements to communicate with the database.
        //             this provides better protection against SQL injection.
        //             [http://php.net/manual/en/pdo.prepared-statements.php][4]

        // get the parameters from the get. escape them to protect against sql injection.

        $territoryId = mysql_real_escape_string($request_vars["TerritoryID"]);

        $employeeID = mysql_real_escape_string($request_vars["EmployeeID"]);

        $sql = "INSERT INTO EmployeeTerritories (EmployeeID, TerritoryID) VALUES (" .$employeeID ."," .$territoryId .")";

        $rs = mysql_query($sql);

        if ($rs) {
            echo true;
        }
        else {
            header("HTTP/1.1 500 Internal Server Error");
            echo false;
        }
    }
?>