Hi I have some event code that adds child records to a master table, and for the most part it is working well. I have options if I want to set an initial or continuing plan, and for each plan i have the option of adding annual or 6-monthly plans. In both the initial and recert, the annual plan works fine, however the 6 monthly results in the following error.
Firstly, here is the code:
$cycleref = $keys['AuditCyclePk'];
//Insert Inital Audit Plan
if ($values['CycleType']=="Initial")
{
//if annual
if ($values['Pattern']=="Annual")
{
$sql1 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 1, 'Stage 1' )";CustomQuery($sql1);
$sql2 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 2, 'Stage 2' )";CustomQuery($sql2);
$sql3 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 1/2' )";CustomQuery($sql3);
$sql4 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 2/2' )";CustomQuery($sql4);
}
elseif ($values['Pattern']=="6-Monthly")
{
$sql5 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 1, 'Stage 1' )";CustomQuery($sql5);
$sql6 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 2, 'Stage 2' )";CustomQuery($sql6);
$sql7 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 1/5' )";CustomQuery($sql7);
$sql8 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 2/5' )";CustomQuery($sql8);
$sql9 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 3/5' )";CustomQuery($sql9);
$sql10 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 4/5' )";CustomQuery($sql10);
$sq111 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 5/5' )";CustomQuery($sql11);
}
}
//Insert Recert Audit Plan
if ($values['CycleType']=="Recertification")
{
//if annual
if ($values['Pattern']=="Annual")
{
$sql12 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 4, 'Recertification' )";CustomQuery($sql12);
$sql13 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 1/2' )";CustomQuery($sql13);
$sql14 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 2/2' )";CustomQuery($sql14);
}
elseif ($values['Pattern']=="6-Monthly")
{
$sql15 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 4, 'Recertification' )";CustomQuery($sql15);
$sql16 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 1/5' )";CustomQuery($sql16);
$sql17 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 2/5' )";CustomQuery($sql17);
$sql18 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 3/5' )";CustomQuery($sql18);
$sql19 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 4/5' )";CustomQuery($sql19);
$sq120 = "insert into AuditCycleAssessments (AuditCycleFk, AuditType, AuditDescription) values ('$cycleref', 3, 'Surveillance 5/5' )";CustomQuery($sql20);
}
}
Secondly here is the error - screenshot
And lastly, here is the code that this error refers to - screenshot
I have tried change If to ELSEIF and visa versa, but I think my use of IF in this situation is wrong, but I am a noob so would greatly appreciate some help. Thanks.
Aucun commentaire:
Enregistrer un commentaire