ProcessMaker Forum | BPM Workflow Simplified

//assign system variables to PHP variables so can be inserted in strings
 $user = @@USER_LOGGED; 
 $process = @@PROCESS;
 //Query to find any uncompleted steps assigned to logged-in user
 $query = "SELECT * FROM APP_DELEGATION WHERE PRO_UID='$process' AND 
   USR_UID='$user' AND DEL_THREAD_STATUS='OPEN'";
 $res = executeQuery($query);
 //if any open tasks are are found, assigned to user: 
 if (is_array($res) and count($res) >= 1)
 {
    $c = new Cases();
    $c->removeCase(@@APPLICATION); //delete the existing case
    //Look up info on the existing case:
    $caseId = $res[1]['APP_UID'];
    $resExisting = executeQuery("SELECT * FROM APPLICATION WHERE APP_UID='$caseId'");
    $caseNo = $resExisting[1]['APP_NUMBER'];
    $caseId = $resExisting[1]['APP_UID'];
    $caseIdx = $caseId = $resExisting[1]['APP_INDEX']; 
    //Finally display message to user to first complete other case and redirect to the existing case 
   $g = new G();
   $g->SendMessageText("Case Aborted. Please complete or cancel this Case #$caseNo before starting a new case", 'WARNING');
    G::header("Location: cases_Open?APP_UID=$caseId&DEL_INDEX=$caseIdx")
    die(); //abort trigger to prevent any errors
 }

//assign system variables to PHP variables so can be inserted in strings
$user = @@USER_LOGGED; 
$process = @@PROCESS;
$currentCase = @@APPLICATION;
//Query to find any uncompleted steps assigned to logged-in user
$query = "SELECT * FROM APP_DELEGATION WHERE PRO_UID='$process' AND 
   USR_UID='$user' AND DEL_THREAD_STATUS='OPEN' and APP_UID<>'$currentCase'";
$res = executeQuery($query);

//if any open tasks are found which are assigned to the user: 
if (is_array($res) and count($res) >= 1) {
    $c = new Cases();
    $c->removeCase(@@APPLICATION); //delete the existing case
    //Look up info on the existing case:
    $caseId = $res[1]['APP_UID'];
    $resExisting = executeQuery("SELECT * FROM APPLICATION WHERE APP_UID='$caseId'");
    $caseNo = $resExisting[1]['APP_NUMBER'];
    $caseId = $resExisting[1]['APP_UID'];
    $caseIdx = $caseId = $resExisting[1]['APP_INDEX']; 
    //Finally display message to user to first complete other case and redirect to the existing case 
    $g = new G();
    $g->SendMessageText("Case Aborted. Please complete or cancel this Case #$caseNo before starting a new case", 'WARNING');
    header("Location: cases_Open?APP_UID=$caseId&DEL_INDEX=$caseIdx")
    die(); //abort trigger to prevent any errors
 }

if (!empty(@@redirected)) {
	@@redirected = null;
}
else {
	$user = @@USER_LOGGED; 
	$process = @@PROCESS;
	$currentCase = @@APPLICATION;
	$query = "SELECT * FROM APP_DELEGATION WHERE PRO_UID='$process' AND 
   		USR_UID='$user' AND DEL_THREAD_STATUS='OPEN' AND APP_UID<>'$currentCase'";
	$res = executeQuery($query);

	if (is_array($res) and count($res) > 0) {
		@@retDelete = PMFDeleteCase(@@APPLICATION);
    		$caseId = $res[1]['APP_UID'];
    		$caseIdx = $res[1]['DEL_INDEX']; 
	
    		//Display message to user to complete the existing case and redirect to it 
    		$g = new \G();
    		$g->SendMessageText("Other case aborted. Please complete or cancel this case before starting a new case.",
							'WARNING');
		PMFSendVariables($caseId, array('redirected' => $currentCase));
		echo "<script> top.location='opencase/$caseId'; </script>";	
		
		//Note: if ProcessMaker is used inside an iframe in another web page, then use this code instead:
		//header("Location: cases_Open?APP_UID=$caseId&DEL_INDEX=$caseIdx");
 
		die(); //abort trigger to prevent any errors
	}
}

//assign system variables to PHP variables so can be inserted in strings  
$user = @@USER_LOGGED; 
$process = @@PROCESS;
//Query to find any uncompleted steps assigned to logged-in user
$query = "SELECT * FROM APP_DELEGATION WHERE PRO_UID='$process' AND ".
         "USR_UID='$user' AND DEL_THREAD_STATUS='OPEN'";
$res = executeQuery($query);

//if any open tasks are are found, assigned to user
if (is_array($res) and count($res) >= 2){
   $c = new Cases();
   $c->removeCase(@@APPLICATION); 
   $query = "SELECT * FROM APP_DELEGATION WHERE PRO_UID='$process' AND ".
            "USR_UID='$user' AND DEL_THREAD_STATUS='OPEN'";
   $res = executeQuery($query);
   $casesId = $res[1]['APP_UID'];
   $resExisting = executeQuery("SELECT * FROM APPLICATION WHERE ".
                               "APP_UID='$casesId'");
   $caseNo = $resExisting[1]['APP_NUMBER'];
   $caseId = $resExisting[1]['APP_UID'];
   $delindex = executeQuery("SELECT DEL_INDEX FROM APP_DELEGATION ".
                            "WHERE APP_UID='$caseId'");
   $caseIdx = $delindex[1]['DEL_INDEX']; 

   //Finally display message to user to first complete other case 
   //and redirect to the existing case
$g = new G();
$g->SendMessageText("". "$caseNo ", '');
   G::header("Location: cases_Open?APP_UID=$caseId&".
             "DEL_INDEX=$caseIdx&action=draft");
   die();    
}