mardi 9 mai 2017

correct use of if and elseif

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