Hi,
I am pretty new to the Ignited Datatables wrapper for Datatables (and new to this site). I have been using standard Datatables and Editor for close to half-a-year already but using Ignited Datatables is something I feel the need to use because of the way it can handle JOINs and Aggregate Functions that standard Datatables cannot perform. My question is, if it is possible to combine use of Ignited Datatables (the native PHP version at: https://github.com/n1crack/IgnitedDatatables-php-library) with Editor. I understand that this is a wrapper for Datatables, but if I wish to create an instance of Editor on Ignited Datatables, how do I initialize?
This is the code I used for creating an instance of a Datatable using Ignited Datatables:
ajax.php
require_once('IgnitedDatatables.php');
$datatables = new Datatables('mysqli');
$datatables
->select('DATE_FORMAT(TestRequestMain.TestRequestDateTime, "%Y-%m-%d") as trDate')
->select('ProjectMain.Name as prjName')
->select('POnumberMain.POnumber as poNum')
->select('AssignedGroup.Name as grpName')
->select('ProfitCenterMirror.Name as profitCenter')
->select('RegionMirror.Name as regName')
->select('TestRequestMain.TestTitle as trTitle')
->select('POnumberMain.TotalMandayReq as TotalMandayReq, POnumberMain.TotalMandayReq * POnumberMain.CostRate as totalCostAppr')
->select('(SUM(Schedule.ManHrsNM) + SUM(Schedule.ManHrsOT) + SUM(Schedule.ManHrsOTSunPH))/8 as totalMandayUsed, (SUM(Schedule.ManHrsNM) + SUM(Schedule.ManHrsOT) + SUM(Schedule.ManHrsOTSunPH))/8 * POnumberMain.CostRate as totalCostPaid, (POnumberMain.TotalMandayReq * POnumberMain.CostRate) - ((SUM(Schedule.ManHrsNM) + SUM(Schedule.ManHrsOT) + SUM(Schedule.ManHrsOTSunPH))/8 * POnumberMain.CostRate) as totalCostBalance')
->select('POnumberMain.QuoteNum as quoNum')
->select('POStatusMirror.String as poStatus')
->select('POnumberMain.DateStart as DateStart, POnumberMain.DateEnd as DateEnd, POnumberMain.DateClosed as DateClosed, POnumberMain.Remarks as Remarks,POnumberMain.CostRate as CostRate,POnumberMain.ProjectID as prjID')
->from('POnumberMain')
->join('ProjectMain', 'POnumberMain.ProjectID = ProjectMain.ID', 'left')
->join('TestRequestMain', 'POnumberMain.POnumber = TestRequestMain.POpoNumber', 'left')
->join('Schedule', 'TestRequestMain.TestRequestNo = Schedule.TestRequestNo', 'left')
->join('AssignedGroup', 'POnumberMain.OutsourceGroupID = AssignedGroup.ID', 'left')
->join('ProfitCenterMirror', 'POnumberMain.ProfitCenterID = ProfitCenterMirror.ID', 'left')
->join('RegionMirror', 'POnumberMain.RegionID = RegionMirror.ID', 'left')
->join('POStatusMirror', 'POnumberMain.POStatusID = POStatusMirror.ID', 'left');
echo $datatables->generate();main_page.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/media/images/favicon.ico" />
<title>Ignited DataTables example</title>
<link rel="stylesheet" type="text/css" href="css/jquery.dataTables.css">
[removed][removed]
[removed][removed]
[removed]
$(document).ready(function()
{
$('#example').dataTable
({
'bServerSide' : true,
'sAjaxSource' : 'ajax.php'
});
});
[removed]
</head>
<body id="dt_example">
<div id="container">
<h1>Ignited Datatables - Testing</h1>
<table border="0" cellpadding="4" cellspacing="0" class="display" id="example">
<thead>
<tr>
<th>Request Date</th>
<th>Project Name</th>
<th>Razer PO Number</th>
<th>Outsource Test Hse</th>
<th>Profit Center</th>
<th>Region</th>
<th>Test Request Title</th>
<th>Total Manday Req.</th>
<th>Total Approved Cost</th>
<th>Used Manday</th>
<th>Total Paid Cost</th>
<th>Total Balance Cost</th>
<th>Invoice Number</th>
<th>PO Status</th>
<th>Date Start</th>
<th>Date End</th>
<th>Date Closed</th>
<th>Remarks</th>
<th>Outsource Cost Per Manday</th>
<th>Project ID (Hidden)</th>
</tr>
</thead>
<tbody>
<tr>
<td>loading…</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>