workflowmaster.blade.php
1.28 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php
$selectarr=$wakka->LoadAll("select * from hrms_masters where mtype='workflow';");
foreach($selectarr as $selectline)
{
$oldmkey=$selectline['mkey'];
$oldmval=$selectline['mvalue'];
$mid=$selectline['mid'];
//delete duplicates
$dups=$wakka->getCount("hrms_masters","mkey='$oldmkey' and mvalue='$oldmval' and mtype='workflow'")-1;
if($dups>0)
{
if(isset($_GET['delete']))$wakka->Query("delete from hrms_masters where mkey='$oldmkey' and mvalue='$oldmval' and mtype='workflow' limit $dups");
}
$trmkey=Input::get("tr$mid");
$conmkey=Input::get("con$mid");
$valmkey=Input::get("val$mid");
$wfkey=str_replace(array("\r\n","\r","\n"),"CRLF",$_POST["wf$mid"]);
$wfkey=str_replace("_EOF_CRLF","_EOF_",$wfkey);
$mvalue="$trmkey|$conmkey|$valmkey~~~$wfkey";
//only update or delete because inserting is done by clicking "new workflow" one at a time
if(trim($wfkey)!="")
{
$wakka->Query("update hrms_masters set mvalue='$mvalue',mkey='$trmkey' where mid='$mid' limit 1");
}
else
{
if(isset($_GET['delete']))$wakka->Query("delete from hrms_masters where mid='$mid' limit 1");
}
}
?>
<div class='message success close'><h2>Success!</h2><p>Data saved successfully.</p></div>
<script>simpleNotification('success','topRight',"Saves Successfully");</script>