Warning (2): Invalid argument supplied for foreach() [APP/controllers/program_controller.php, line 86]
Code | Context
    $program['Basins'] = array();

    foreach ($plansResult as $row) {
$conditions	=	array(
	"programConditions" => array(
	"ProgramID" => "N"
),
	"planConditions" => array(
	"MonPlanStatus" => array()
),
	"siteConditions" => array(
	"SiteStatus" => "Active"
)
)
$monitoringPlanID	=	"A"
$excel	=	false
$results	=	false
$plansSQL	=	"select MonitoringPlanID, MonitoringPlanName, SiteInfoRowID, SiteName, SiteCode, Basin, SubBasin, Latitude, Longitude, TributaryWatershed, GPSDataComment, count(*) as SampleCount from ViewAllPrograms where PlanStatus = 'Active' AND PlanStatusCalc = 'Active' AND SiteStatus = 'Active' AND AnalyteStatus = 'Active' AND AnalyteStatusCalc = 'Active' AND ProgramID = N group by MonitoringPlanID, MonitoringPlanName, SiteInfoRowID, SiteName, SiteCode, Basin, SubBasin, Latitude, Longitude, TributaryWatershed, GPSDataComment order by MonitoringPlanID, MonitoringPlanName, SiteInfoRowID, SiteName, SiteCode, Basin, SubBasin, Latitude, Longitude, TributaryWatershed, GPSDataComment "
$plansResult	=	false
$program	=	array(
	"ProgramID" => null,
	"MonitoringProgram" => null,
	"StartDate" => "None",
	"EndDate" => "None",
	"MonitoringObjectives" => "None",
	"AnnualBudget" => "None",
	"FundingSource" => "None",
	"URL" => null,
	"Plans" => array(),
	"Agencies" => array(),
	"Sites" => array(),
	"Contacts" => array(),
	"Parameters" => array(),
	"Basins" => array()
)
ProgramController::view() - APP/controllers/program_controller.php, line 86
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Warning (2): Invalid argument supplied for foreach() [APP/controllers/program_controller.php, line 306]
Code | Context
    //echo "planorgsSQL = " . $planorgsSQL . "<br>";
        
    foreach ($programorgs as $programorg) {
$programid	=	"N"
$mplanids	=	array()
$primaryOnly	=	true
$orgs	=	array(
	"programLead" => null,
	"programorgs" => array(),
	"planLead" => null,
	"planorgs" => array()
)
$programorgsSQL	=	"select op.programid as pid, org.organizationname as organizationname,org.orgdisplayname as displayname, op.programlead as lead from tblCVOrganization org, tblCVOrgProgram as op where op.organizationid = org.organizationid and op.programid =N"
$planorgsSQL	=	"select op.monitoringplanid as pid, org.organizationname, org.orgdisplayname as displayname, op.monplanlead as lead from tblCVOrganization org, tblCVOrgMonPlan as op where op.organizationid = org.organizationid and op.monitoringplanid in ()"
$programorgs	=	false
$planorgs	=	false
ProgramController::getOrganizations() - APP/controllers/program_controller.php, line 306
ProgramController::view() - APP/controllers/program_controller.php, line 104
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Warning (2): Invalid argument supplied for foreach() [APP/controllers/program_controller.php, line 312]
Code | Context
      }
    }
    foreach ($planorgs as $planorg) {
$programid	=	"N"
$mplanids	=	array()
$primaryOnly	=	true
$orgs	=	array(
	"programLead" => null,
	"programorgs" => array(),
	"planLead" => null,
	"planorgs" => array()
)
$programorgsSQL	=	"select op.programid as pid, org.organizationname as organizationname,org.orgdisplayname as displayname, op.programlead as lead from tblCVOrganization org, tblCVOrgProgram as op where op.organizationid = org.organizationid and op.programid =N"
$planorgsSQL	=	"select op.monitoringplanid as pid, org.organizationname, org.orgdisplayname as displayname, op.monplanlead as lead from tblCVOrganization org, tblCVOrgMonPlan as op where op.organizationid = org.organizationid and op.monitoringplanid in ()"
$programorgs	=	false
$planorgs	=	false
ProgramController::getOrganizations() - APP/controllers/program_controller.php, line 312
ProgramController::view() - APP/controllers/program_controller.php, line 104
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83