Guriddo » Topic: Entry formula on input

Entry formula on input

Guriddo
formula input jqsuite
Entry formula on input

Tagged: formula input jqsuite

This topic has 5 replies, 2 voices, and was last updated 9 years, 6 months ago by guriddo.support.

Creator

Topic
November 5, 2016 at 5:05 am #125637

ariadrianto
Participant

Hi,

How to make our input can accept formula ? I’ve tried in old jqgrid and it works without any setting.. but I can’t do it on JqSuite PHP…

[/url]

https://s19.postimg.org/w54c6hkoz/Selection_209.jpg

Thank you and Regards,
Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies

November 7, 2016 at 9:02 am #125639

guriddo.support

Participant

Hello,

Could you please let us know where and how you do this. If previously you use jqGrid JavaScript, then you can do this in PHP too – just let us know the JavaScript way.

Kind Regards,

Will

Guriddo Support Team

November 8, 2016 at 8:40 am #125641

ariadrianto

Participant

Hi,

Maybe you can see my demo using jqGrid PHP and jqSuite PHP… I love jqSuite cause it cut my production time a lot. There’s nothing special coding both of them.

jqgrid code :



$karyawanid = $_POST[&#039;KARYAWANID&#039;]; if (empty($karyawanid)&amp;&amp; $karyawanid!= 0) {$karyawanid = &#039;null&#039;; }
$tgl = &quot;&#039;$_POST[TGL]&#039;&quot;; if (empty($_POST[TGL])) {$tgl = &#039;null&#039;; }
$desc = $_POST[&#039;DESC&#039;]; if (empty($desc)&amp;&amp; $desc!= 0) {$desc = &#039;null&#039;; }
$salary = $_POST[&#039;SALARY&#039;]; if (empty($salary)) {$salary = &#039;null&#039;; }

$action = $_REQUEST[&#039;oper&#039;];
if( $_REQUEST[&#039;export&#039;]==&#039;excel&#039;) $action = &#039;export&#039;;
if (empty($action) &amp;&amp; empty($_POST[&#039;id&#039;])) {$action = &#039;load&#039;;}
else if (empty($action)) {$action = &#039;edit&#039;; }

$pos = strpos($wh, &quot;TGL&quot;);

if ($action==&#039;del&#039;) {
$sql = &quot;Delete from COBA where KARYAWANID = &quot;.$id;
$stmt = $connPDO-&gt;query($sql);

if(!$stmt){$error = $connPDO-&gt;errorInfo(); $_SESSION[message]=$error[2];}
}

else if ($action == &#039;add&#039;) {
$sql = &quot;Insert into COBA (KARYAWANID, TGL, DESC, SALARY)
values ($id, $tgl, $desc, $salary)&quot;;

$stmt = $connPDO-&gt;query($sql);

if(!$stmt){$error = $connPDO-&gt;errorInfo(); $_SESSION[message]=$error[2];}
}

else if ($action == &#039;edit&#039;) {
$sql = &quot;update COBA set tgl = $tgl
,salary = $salary
where KARYAWANID = $id&quot;;

$stmt = $connPDO-&gt;query($sql);
if(!$stmt){$error = $connPDO-&gt;errorInfo(); $_SESSION[message]=$error[2];}
}

else if ($action==&#039;load&#039;) {

$i=0;
$sql = &quot;select k.nama, c.tgl, c.karyawanid, c.desc, c.salary
from coba c
left join karyawan k on c.karyawanid = k.karyawanid
where 1=1 $wh
order by $sidx $sord&quot; ;

$_SESSION[&#039;sqlKaryawan&#039;] = $sql;
$stmt = $connPDO-&gt;query($sql);
$rows = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);
$i=0;
foreach ($rows as $row) {
$responce-&gt;rows[$i][&#039;id&#039;]=$row[KARYAWANID];
$responce-&gt;rows[$i][&#039;cell&#039;]=array($row[NAMA], $row[TGL]
,$row[DESC], $row[SALARY]
,$row[KARYAWANID]);
$i++;
}

if($_SESSION[message]) {$responce-&gt;userdata[&#039;message&#039;] = $_SESSION[message];unset($_SESSION[&#039;message&#039;]);}
echo json_encode($responce);

$karyawanid = $_POST['KARYAWANID']; if (empty($karyawanid)&& $karyawanid!= 0) {$karyawanid = 'null'; }

$tgl = "'$_POST[TGL]'"; if (empty($_POST[TGL])) {$tgl = 'null'; }

$desc = $_POST['DESC']; if (empty($desc)&& $desc!= 0) {$desc = 'null'; }

$salary = $_POST['SALARY']; if (empty($salary)) {$salary = 'null'; }

$action = $_REQUEST['oper'];

if( $_REQUEST['export']=='excel') $action = 'export';

if (empty($action) && empty($_POST['id'])) {$action = 'load';}

else if (empty($action)) {$action = 'edit'; }

$pos = strpos($wh, "TGL");

if ($action=='del') {

$sql = "Delete from COBA where KARYAWANID = ".$id;

$stmt = $connPDO->query($sql);

if(!$stmt){$error = $connPDO->errorInfo(); $_SESSION[message]=$error[2];}

}

else if ($action == 'add') {

$sql = "Insert into COBA (KARYAWANID, TGL, DESC, SALARY)

values ($id, $tgl, $desc, $salary)";

$stmt = $connPDO->query($sql);

if(!$stmt){$error = $connPDO->errorInfo(); $_SESSION[message]=$error[2];}

}

else if ($action == 'edit') {

$sql = "update COBA set tgl = $tgl

,salary = $salary

where KARYAWANID = $id";

$stmt = $connPDO->query($sql);

if(!$stmt){$error = $connPDO->errorInfo(); $_SESSION[message]=$error[2];}

}

else if ($action=='load') {

$i=0;

$sql = "select k.nama, c.tgl, c.karyawanid, c.desc, c.salary

from coba c

left join karyawan k on c.karyawanid = k.karyawanid

where 1=1 $wh

order by $sidx $sord" ;

$_SESSION['sqlKaryawan'] = $sql;

$stmt = $connPDO->query($sql);

$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

$i=0;

foreach ($rows as $row) {

$responce->rows[$i]['id']=$row[KARYAWANID];

$responce->rows[$i]['cell']=array($row[NAMA], $row[TGL]

,$row[DESC], $row[SALARY]

,$row[KARYAWANID]);

$i++;

}

if($_SESSION[message]) {$responce->userdata['message'] = $_SESSION[message];unset($_SESSION['message']);}

echo json_encode($responce);

jqSuite PHP code :


.....

$grid-&gt;dataType = &#039;json&#039;;
$grid-&gt;setPrimaryKeyId(&quot;COBAID&quot;);
$grid-&gt;setColModel();
$grid-&gt;table = $table;

$grid-&gt;setUrl(&#039;coba2_.php&#039;);

$grid-&gt;setDbTime(&#039;Y-m-d&#039;);
$grid-&gt;setDbDate(&#039;Y-m-d&#039;);
$grid-&gt;setUserDate(&#039;Y-m-d&#039;);
$grid-&gt;setUserTime(&#039;Y-m-d&#039;);

$grid-&gt;setColProperty(&quot;COBAID&quot;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(&#039;TGL&#039;, array(&quot;formatter&quot; =&gt; &quot;date&quot;,
&quot;formatoptions&quot; =&gt; array(&quot;srcformat&quot; =&gt; &quot;Y-m-d H:i:s&quot;, &quot;newformat&quot; =&gt; &quot;Y-m-d&quot;),
&quot;editoptions&quot; =&gt; array(&quot;dataInit&quot; =&gt;
&quot;js:function(elm){
jQuery(elm).datepicker({dateFormat:&#039;yy-m-d&#039;});
jQuery(&#039;.ui-datepicker&#039;).css({&#039;zIndex&#039;:&#039;1200&#039;,&#039;font-size&#039;:&#039;75%&#039;});}&quot;)
));
$grid-&gt;setColProperty(&quot;KARYAWANID&quot;, array(&quot;label&quot;=&gt;&quot;KaryawanId (should be hidden)&quot;,&quot;hidden&quot;=&gt;true, &quot;editable&quot;=&gt;true, &quot;searchoptions&quot;=&gt;array(&quot;sopt&quot;=&gt;array(&#039;cn&#039;))));
$grid-&gt;setColProperty(&quot;NAMA&quot;, array(&quot;label&quot;=&gt;&quot;Name&quot;, &quot;searchoptions&quot;=&gt;array(&quot;sopt&quot;=&gt;array(&#039;cn&#039;))));
$grid-&gt;setAutocomplete(&quot;NAMA&quot;,&quot;#KARYAWANID&quot;,&quot;SELECT kk.NAMA, kk.NAMA, kk.KARYAWANID FROM KARYAWAN kk WHERE NAMA LIKE upper(?)&quot;
. &quot; ORDER BY kk.NAMA &quot;,null, true, true);

$grid-&gt;setColProperty(&quot;DESC&quot;, array(&quot;label&quot;=&gt;&quot;Description&quot;, &quot;width&quot;=&gt;85, &quot;searchoptions&quot;=&gt;array(&quot;sopt&quot;=&gt;array(&#039;cn&#039;))));
$grid-&gt;setColProperty(&quot;SALARY&quot;, array(&quot;label&quot;=&gt;&quot;Salary&quot;,&quot;formatter&quot;=&gt;&quot;number&quot;, &quot;summaryType&quot;=&gt;&quot;sum&quot;, &quot;align&quot;=&gt;&quot;right&quot;,&quot;search&quot;=&gt;false,
&quot;width&quot;=&gt;85,&quot;searchoptions&quot;=&gt;array(&quot;sopt&quot;=&gt;array(&quot;eq&quot;,&quot;gt&quot;,&quot;lt&quot;))));
$grid-&gt;setGridOptions(array(&quot;rowNum&quot;=&gt;99999,&quot;rowList&quot;=&gt;array(10,20,30),&quot;sortname&quot;=&gt;&quot;TGL&quot;, &quot;height&quot;=&gt;&#039;150&#039;,
&quot;caption&quot;=&gt;&quot;Date on First Column (popup not shown)&quot;,
&quot;footerrow&quot;=&gt;true,
&quot;userDataOnFooter&quot;=&gt;true,
&quot;grouping&quot;=&gt;false,
&quot;shrinkToFit&quot;=&gt;false,
&quot;width&quot;=&gt;600
));

$grid-&gt;ignoreCaseSearch = true;
$grid-&gt;setSearchOptions( array ( &quot;sqlfunc&quot; =&gt; &quot;UPPER&quot;, &quot;phpfunc&quot; =&gt; &quot;strtoupper&quot; ));
$grid-&gt;toolbarfilter = true;
$grid-&gt;navigator = true;
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;false,&quot;add&quot;=&gt;true,&quot;edit&quot;=&gt;true,&quot;del&quot;=&gt;true,&quot;view&quot;=&gt;true));

$_POST = array_map(&quot;strtoupper&quot;, $_POST);
$grid-&gt;renderGrid(&#039;#grid2&#039;,&#039;#pager2&#039;,true, null, null, true,true);

.....

$grid->dataType = 'json';

$grid->setPrimaryKeyId("COBAID");

$grid->setColModel();

$grid->table = $table;

$grid->setUrl('coba2_.php');

$grid->setDbTime('Y-m-d');

$grid->setDbDate('Y-m-d');

$grid->setUserDate('Y-m-d');

$grid->setUserTime('Y-m-d');

$grid->setColProperty("COBAID", array("label"=>"ID", "hidden"=>true));

$grid->setColProperty('TGL', array("formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "Y-m-d"),

"editoptions" => array("dataInit" =>

"js:function(elm){

jQuery(elm).datepicker({dateFormat:'yy-m-d'});

jQuery('.ui-datepicker').css({'zIndex':'1200','font-size':'75%'});}")

));

$grid->setColProperty("KARYAWANID", array("label"=>"KaryawanId (should be hidden)","hidden"=>true, "editable"=>true, "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setColProperty("NAMA", array("label"=>"Name", "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setAutocomplete("NAMA","#KARYAWANID","SELECT kk.NAMA, kk.NAMA, kk.KARYAWANID FROM KARYAWAN kk WHERE NAMA LIKE upper(?)"

. " ORDER BY kk.NAMA ",null, true, true);

$grid->setColProperty("DESC", array("label"=>"Description", "width"=>85, "searchoptions"=>array("sopt"=>array('cn'))));

$grid->setColProperty("SALARY", array("label"=>"Salary","formatter"=>"number", "summaryType"=>"sum", "align"=>"right","search"=>false,

"width"=>85,"searchoptions"=>array("sopt"=>array("eq","gt","lt"))));

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"TGL", "height"=>'150',

"caption"=>"Date on First Column (popup not shown)",

"footerrow"=>true,

"userDataOnFooter"=>true,

"grouping"=>false,

"shrinkToFit"=>false,

"width"=>600

));

$grid->ignoreCaseSearch = true;

$grid->setSearchOptions( array ( "sqlfunc" => "UPPER", "phpfunc" => "strtoupper" ));

$grid->toolbarfilter = true;

$grid->navigator = true;

$grid->setNavOptions('navigator', array("excel"=>false,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));

$_POST = array_map("strtoupper", $_POST);

$grid->renderGrid('#grid2','#pager2',true, null, null, true,true);

I’ve tried to entry both :

would be loved to if it can be done with jqSuite PHP.

Regards,

Ari Adrianto

November 8, 2016 at 11:02 am #125642

guriddo.support

Participant

Hello,

It depend where you want to put this logic – server side or client side.

I think that one possible solution is toy use a javascript formula parser something like this one

The idea is to bind a change event to this field using dataInit function and maybe it is better to use two fields one for the formula another for result, but I think it can be done with one field too.

Kind Regards,
Will

Guriddo Support Team

November 9, 2016 at 5:02 am #125646

ariadrianto

Participant

Hi,

It’s working by adding math function.


$calcs = &lt;&lt;&lt; CALCS

function(postdata) {

postdata[&#039;SALARY&#039;] = math.eval(postdata[&#039;SALARY&#039;]);

return postdata; }
CALCS;

$grid-&gt;setNavEvent(&quot;edit&quot;, &quot;serializeEditData&quot;, $calcs);
$grid-&gt;setNavEvent(&quot;insert&quot;, &quot;serializeEditData&quot;, $calcs);

$calcs = <<< CALCS

function(postdata) {

postdata['SALARY'] = math.eval(postdata['SALARY']);

return postdata; }

CALCS;

$grid->setNavEvent("edit", "serializeEditData", $calcs);

$grid->setNavEvent("insert", "serializeEditData", $calcs);

okay… thank you…
But I think I will change any formatter number with this math function… I’m the lazy one… LOL…
Thank you for your support

This reply was modified 9 years, 6 months ago by ariadrianto. Reason: format source

November 9, 2016 at 10:00 am #125648

guriddo.support

Participant

Hello,

Thank you for the feedback. We don’t try this, so it is a good that you post this for the other users.

Entry formula on input

Search Forum

Recent Replies

Forum Statistics

UserOnline