public function usersAction()
{
require_once '../vendor/dhtmlx/dhtmlxConnector/codebase/grid_connector.php';
$database_host = $this->container->getParameter('database_host');
$database_port = $this->container->getParameter('database_port');
$database_name = $this->container->getParameter('database_name');
$database_user = $this->container->getParameter('database_user');
$database_password = $this->container->getParameter('database_password');
$conn = mysql_connect($database_host, $database_user, $database_password);
mysql_select_db($database_name);
$data = new \GridConnector($conn);
$sql = "select ID,USERNAME,EMAIL,LOCKED,EXPIRED,'ACTIVE' as STATUS\n from arii_user\n order by username";
$data->event->attach("beforeRender", array($this, "color_rows"));
$data->render_sql($sql, "ID", "USERNAME,EMAIL,STATUS");
}
public function jobsAction()
{
require_once '../vendor/dhtmlx/dhtmlxConnector/codebase/grid_connector.php';
$database_host = $this->container->getParameter('database_host');
$database_port = $this->container->getParameter('database_port');
$database_name = $this->container->getParameter('database_name');
$database_user = $this->container->getParameter('database_user');
$database_password = $this->container->getParameter('database_password');
$conn = mysql_connect($database_host, $database_user, $database_password);
mysql_select_db($database_name);
$data = new \GridConnector($conn);
$qry = "select name,title,spooler_id,process_class,visible from joe_job order by name";
$data->event->attach("beforeRender", array($this, "render_jobs"));
$data->render_sql($qry, 'ID', 'name,title,spooler_id,process_class,visible');
}
<?php
require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res);
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_sql("SELECT grid50000.item_id as ID , grid50000.item_nm FROM grid50000", "item_id(ID)", "grid50000.item_id(ID),item_nm");
<?php require_once "../config.php"; $res = mysql_connect($mysql_server, $mysql_user, $mysql_pass); mysql_select_db($mysql_db); require "../../codebase/grid_connector.php"; $gridConn = new GridConnector($res); $sql = "SELECT * FROM grid50"; $gridConn->render_sql($sql, "item_id", "item_nm,item_cd");
<?php
require_once "../dhtmlx/connector_codebase/grid_connector.php";
$res2 = mysql_connect("localhost", "root", "");
mysql_select_db("company");
session_start();
$invno = strip_tags($_SESSION['invnumber']);
$conn2 = new GridConnector($res2, "MySQL");
$conn2->dynamic_loading(30);
// limited the loading data details
if ($invno != null) {
$conn2->render_sql("Select * from `ivdetailtable` where `InvNumber`='{$invno}'", "id", "InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice");
} else {
$conn2->render_sql("Select * from `ivdetailtable` where `InvNumber`='0'", "id", "InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice");
//$conn2->render_table("ivdetailtable","id","InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice"); //"table ","id" for table,"data column" for table
$conn->sql->attach("DELETE", "DELETE * FROM `ivdetailtable` WHERE `itemid` = 0");
}
<?php
require_once "../dhtmlx/connector_codebase/grid_connector.php";
$res = mysql_connect("localhost", "root", "");
mysql_select_db("company");
session_start();
$potemp = strip_tags($_SESSION['number']);
$conn = new GridConnector($res, "MySQL");
$conn->dynamic_loading(30);
// limited the loading data details
if ($potemp != null) {
//$conn->sql->attach("INSERT","INSERT into `podetailtable` (`POtemp`) VALUES ($potemp)");
//$po_i=$_SESSION['i']+=intval(1));
//$conn->sql->attach("INSERT","INSERT into `podetailtable` (`itemid`,`POtemp`) VALUES ($po_i,$potemp)"); //each ponumber insert into the item dfor reference
$conn->render_sql("Select * from `podetailtable` where `POtemp`='{$potemp}'", "id", "POtemp,itemid,Description,booktitle,author,price");
} else {
//session_destroy();
$conn->render_sql("Select * from `podetailtable` where `POtemp`='0'", "id", "POtemp,itemid,Description,booktitle,author,price");
//set default=-1
//$conn->render_table("podetailtable","id","POtemp,itemid,booktitle,author,price"); //"table ","id" for table,"data column" for table
$conn->sql->attach("DELETE", "DELETE * FROM `podetailtable` WHERE `itemid` = 0");
}
mysql_select_db($mysql_db);
require "../../lib/codebase/grid_connector.php";
require "../../includes/functions.php";
// function color_rows($row){
// if ($row->get_index()%2)
// $row->set_row_color("pink");
// }
function formatting($row)
{
$suratmasukviewlink = 106;
//render field as details link
$data = $row->get_value("NoSurat");
// $row->set_value("TujuanSurat","<a href='details.php?id={$data}'><img src='image/ico_view.gif' alt='Lihat'> </a>");
//$row->set_value("DicatatOleh","<a href='surat_masuk_cari_view.php?id={$data}'><img src='images/ico_view.gif' > </a>");
$alamat = "index.php?p=" . enkripsi($suratmasukviewlink . "&q=" . $data);
//$alamat = "<a href='index.php?p=".enkripsi($suratmasukviewlink ."&q=".$data)."><img src='images/ico_view.gif'></a>";
// $row->set_value("DicatatOleh","<a href='index.php?p=\".enkripsi($suratmasukviewlink &q=\{$data})\"><img src=\"images/ico_view.gif\" ></a>");
$row->set_value("DicatatOleh", "<a href='{$alamat}'><img src='images/ico_view.gif'></a>");
$data = $row->get_value("TglTerima");
$row->set_value("TglTerima", date("d-m-Y", strtotime($data)));
}
$grid = new GridConnector($res);
// $grid->event->attach("beforeRender","color_rows");
$grid->event->attach("beforeRender", "formatting");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
//$grid->render_table("country_data","country_id","name,full_name,type,capital");
//$grid->render_sql("Select * from dtrealisasi_fisik,tbsatker where dtrealisasi_fisik.KdSatker=tbsatker.KdSatker","Id","KdSatker,NmSatker,KdProgram,KdGiat,KdSGiat");
// $grid->render_table("suratmasuk","IdSuratMasuk","TujuanSurat,NoSurat,AsalSurat,Perihal,TglTerima");
$grid->render_sql("SELECT * FROM suratmasuk WHERE DicatatOleh = '" . $KdSatker . "' order by TglTerima desc", "IdSuratMasuk", "DicatatOleh,NoSurat,AsalSurat,Perihal,TglTerima");
//$grid->render_sql("SELECT * FROM suratmasuk WHERE DicatatOleh = '". $KdSatker."'");
mysql_select_db($mysql_db);
require "../../lib/codebase/grid_connector.php";
require "../../includes/functions.php";
// function color_rows($row){
// if ($row->get_index()%2)
// $row->set_row_color("pink");
// }
function formatting($row)
{
$suratkeluarviewlink = 78;
//render field as details link
$data = $row->get_value("IdSuratKeluar");
// $row->set_value("TujuanSurat","<a href='details.php?id={$data}'><img src='image/ico_view.gif' alt='Lihat'> </a>");
// $row->set_value("DicatatOleh","<a href='surat_masuk_cari_view.php?id={$data}'><img src='images/ico_view.gif' > </a>");
$alamat = "index.php?p=" . enkripsi($suratkeluarviewlink . "&q=" . $data);
//$alamat = "<a href='index.php?p=".enkripsi($suratmasukviewlink ."&q=".$data)."><img src='images/ico_view.gif'></a>";
// $row->set_value("DicatatOleh","<a href='index.php?p=\".enkripsi($suratmasukviewlink &q=\{$data})\"><img src=\"images/ico_view.gif\" ></a>");
$row->set_value("DicatatOleh", "<a href='{$alamat}'><img src='images/ico_view.gif'></a>");
$data = $row->get_value("WaktuBuat");
$row->set_value("WaktuBuat", date("d-m-Y", strtotime($data)));
}
$grid = new GridConnector($res);
// $grid->event->attach("beforeRender","color_rows");
$grid->event->attach("beforeRender", "formatting");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
//$grid->render_table("country_data","country_id","name,full_name,type,capital");
//$grid->render_sql("Select * from dtrealisasi_fisik,tbsatker where dtrealisasi_fisik.KdSatker=tbsatker.KdSatker","Id","KdSatker,NmSatker,KdProgram,KdGiat,KdSGiat");
// $grid->render_table("suratmasuk","IdSuratMasuk","TujuanSurat,NoSurat,AsalSurat,Perihal,TglTerima");
$grid->render_sql("SELECT * FROM suratkeluar WHERE DicatatOleh = '" . $KdSatker . "' order by WaktuBuat desc", "IdSuratKeluar", "DicatatOleh,NoSurat,TujuanSurat,Perihal,WaktuBuat");
//$grid->render_sql("SELECT * FROM suratmasuk WHERE DicatatOleh = '". $KdSatker."'");
<?php
require_once "../dhtmlx/connector_codebase/grid_connector.php";
$res3 = mysql_connect("localhost", "root", "");
mysql_select_db("company");
session_start();
$CR_Code = strip_tags($_SESSION['PCR_Code']);
$conn3 = new GridConnector($res3, "MySQL");
$conn3->dynamic_loading(30);
// limited the loading data details
if ($CR_Code != null) {
$conn3->render_sql("Select * from `paydetailtable` where `CRCode`='{$CR_Code}'", "id", "CRCode,No,date,period,invoice_no,po_number,invoice_amount,paid_period,payment_amount,remark");
} else {
$conn3->render_sql("Select * from `paydetailtable` where `CRCode`='0'", "id", "CRCode,No,date,period,invoice_no,po_number,invoice_amount,paid_period,payment_amount,remark");
//$conn2->render_table("ivdetailtable","id","InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice"); //"table ","id" for table,"data column" for table
}
?>
<?php
require_once "../dhtmlx/connector_codebase/grid_connector.php";
$res1 = mysql_connect("localhost", "root", "");
mysql_select_db("company");
session_start();
$crno = strip_tags($_SESSION['CRNoteNo']);
$conn1 = new GridConnector($res1, "MySQL");
$conn1->dynamic_loading(30);
// limited the loading data details
if ($crno != null) {
$conn1->render_sql("Select * from `cndetailtable` where `CNnumber`={$crno}", "id", "CNnumber,itemid,ReferenceNumber,Narrative,Amount");
} else {
$conn1->render_sql("Select * from `cndetailtable` where `CNnumber`='0'", "id", "CNnumber,itemid,ReferenceNumber,Narrative,Amount");
$conn->sql->attach("DELETE", "DELETE * FROM `cndetailtable` WHERE `itemid` = 0");
}
$KdSatker = @$_SESSION['xunit_' . $session_name];
require_once "../../lib/codebase/config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../lib/codebase/grid_connector.php";
require "../../includes/functions.php";
// function color_rows($row){
// if ($row->get_index()%2)
// $row->set_row_color("pink");
// }
function formatting($row)
{
$suratmasukviewlink = 106;
//render field as details link
$data = $row->get_value("NoSurat");
// $row->set_value("TujuanSurat","<a href='details.php?id={$data}'><img src='image/ico_view.gif' alt='Lihat'> </a>");
$alamat = "index.php?p=" . enkripsi($suratmasukviewlink . "&q=" . $data);
$row->set_value("IdPenerima", "<a href='{$alamat}'><img src='images/ico_view.gif' > </a>");
$data = $row->get_value("TglTerima");
$row->set_value("TglTerima", date("d-m-Y", strtotime($data)));
}
$grid = new GridConnector($res);
// $grid->event->attach("beforeRender","color_rows");
$grid->event->attach("beforeRender", "formatting");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
//$grid->render_table("country_data","country_id","name,full_name,type,capital");
//$grid->render_sql("Select * from dtrealisasi_fisik,tbsatker where dtrealisasi_fisik.KdSatker=tbsatker.KdSatker","Id","KdSatker,NmSatker,KdProgram,KdGiat,KdSGiat");
// $grid->render_table("suratmasuk","IdSuratMasuk","TujuanSurat,NoSurat,AsalSurat,Perihal,TglTerima");
$grid->render_sql("SELECT * FROM vcariperorang WHERE IdPenerima = '" . $IdUser . "' order by TglDisposisi desc", "IdSuratMasuk", "IdPenerima,NoSurat,AsalSurat,Perihal,TglDisposisi");
