Registration_Listing
QuestionDescriptionResponseTypeFormatTextHelpPreLogicPostLogic
tmpEVcasesEvent listerNULLRADIOecho '~;
'; $CaseId=$_SESSION['CaseId']; echo ~Event: '; echo ~
tmpRGselectSelect a RegistrationButtonBUTTONNew RegistrationGLOBAL $LINENUMBERS; $LINENUMBERS=0; global $FCOLOR; $FCOLOR='RED'; $CaseId=$_SESSION['CaseId']; $wHit=$_SESSION['PM_wHit']; $exte=$_REQUEST['exte']; if ($exte==1) $wHit=800; //echo ~
wHit=$wHit exte=$exte~; $sel=$_REQUEST['RegistrationSelect']; if ($sel!=~~) { $_SESSION['Instance']=ShowQueryResultScalar(~select rInstance from Responses where rUnique='$sel' and isDeleted=0~); SetForm('Registration'); } echo ~~; $tmpRGcase=$_REQUEST['tmpRGcase']; if ($tmpRGcase!='') { $CaseId=$tmpRGcase; $_SESSION['CaseId']=$CaseId; } //echo ~

$CaseId Transactions

~; ExecuteSQL(~create temporary table b select rUnique,rValue as Registrant,rInstance from Responses where qID='Reg_Name' and CaseID='$CaseId' and isDeleted=0 and rValue>''~); //ShowQueryResult(~select * from b~); ExecuteSQL(~create temporary table c select rUnique,rValue as Date,rInstance from Responses where qID='Reg_Date' and CaseID='$CaseId' and isDeleted=0 ~); //ShowQueryResult(~select * from c~); echo '
'; echo '
'; global $NOSORT; $NOSORT=0; $order=$_REQUEST['orderby']; if ($order=='') $orderby='Date'; else $orderby=$order.', Date'; ShowQueryResult(~select distinct concat('') as Detail, Registrant, Date from b left join c on c.rInstance=b.rInstance order by $orderby DESC~); echo ~
~; echo '
'; 		$CaseId=$_SESSION['CaseId']; $UserId=$_SESSION['UserId']; $Instance=ShowQueryResultScalar(~select rUnique from Responses where CaseID='$CaseId' and qID='Reg_Name' and rValue=''~); echo ~
1 instance=$Instance~; if ($Instance==~~) { ExecuteSQL(~insert into Responses (CaseID,qID,uID,rValue,ProjectId) select '$CaseId','Reg_Name','$UserId','','~.$_SESSION['ProjectId'].~'~); $Instance=ShowQueryResultScalar(~select rUnique from Responses where CaseID='$CaseId' and qID='Reg_Name' and rValue=''~); ExecuteSQL(~update Responses set rInstance='$Instance' where rUnique='$Instance'~); } echo ~
2 instance=$Instance~; $_SESSION['Instance']=$Instance; SetForm('Registration'); $stat=1;