addDataParam('s', $continent); } $rs = $wrapperObj->executeQuery($sql, $dataParams); if ($rs === false) { showierror(); } $tmp_arr = array(); $i=0; foreach ($rs as $row) { $tmp_arr[$i]['id'] = strval($row['id']); $tmp_arr[$i]['name'] = $row['name']; $tmp_arr[$i]['abbrivation'] = $row['abbrivation']; $tmp_arr[$i]['continent'] = $row['continent']; $i++; } return json_encode($tmp_arr); } return false; } public static function getDms($sortBy, $id, $vendorProposedTermId, $elementName, $wrapperObj){ if($sortBy){ if($sortBy == "sortByCountry"){ $dmsRestrictions = Model_CustomerMaster::getAllCustomerMastersByCountry(); }else{ $dmsRestrictions = Model_CustomerMaster::getAllCustomerMasters(); } $dmsSelectString = array(); if($id || $vendorProposedTermId){ $dataParams = new QueryData(); if($id){ $dmsSql = 'SELECT dms_carve_out FROM vendor_contract WHERE id = ?'; $dataParams->addDataParam('i', $id); } if($vendorProposedTermId){ $dmsSql = 'SELECT proposed_dms_carve_out as dms_carve_out FROM vendor_proposed_term WHERE vendor_proposed_term_id = ?'; $dataParams->addDataParam('i', $vendorProposedTermId); } $dmsrs = $wrapperObj->executeQuery($dmsSql, $dataParams); if ($dmsrs === false) { showierror(); } $dmsRow = $dmsrs[0]; $dmsIds = explode(",", $dmsRow['dms_carve_out']); } } $changeValuesToKeys = array_flip($dmsIds); $dmsSelectString = ""; foreach($dmsRestrictions as $dmsMaster){ $selected = ''; if(isset($changeValuesToKeys[$dmsMaster['customer_id']])){ $selected = 'selected="selected"'; } $dmsSelectString .= "" . $dmsMaster['name'] . ""; } $dmsSelectString .= ""; return json_encode($dmsSelectString); } } ?>