addDataParam('i', $agreement_id); $aIT_get_agreement_type_result = $wrapperObj->executeQuery($aIT_get_agreement_type, $dataParams); if ($aIT_get_agreement_type_result === false) { showierror($aIT_get_agreement_type); } if(count($aIT_get_agreement_type_result)) { $aIT_agreement_type = $aIT_get_agreement_type_result[0]['agreement_type']; // query deal table to get all information: $dataParams = new QueryData(); $aIT_agreement_query = 'SELECT a.agreement_id, a.service_name, a.service_id, a.service_type, a.agreement_type, a.payee, a.tax_id, a.tax_exempt, a.orchard_dba, a.action, DATE_FORMAT(a.effective_date, "%m-%d-%Y") as effective_date, DATE_FORMAT(a.initial_expiration_date, "%m-%d-%Y") as initial_expiration_date, a.auto_renewal, a.auto_renewal_term, a.auto_renewal_term_rollover, a.terminate_upon_notice, a.terminate_upon_notice_period, ast.* FROM agreement a INNER JOIN agreement_form_' . $aIT_agreement_type . ' ast ON ast.agreement_id = a.agreement_id WHERE a.agreement_id = ? GROUP BY a.agreement_id'; $dataParams->addDataParam('i', $agreement_id); $aIT_agreement_result = $wrapperObj->executeQuery($aIT_agreement_query, $dataParams); if ($aIT_agreement_result === false) { showierror($aIT_agreement_query); } $aIT_agreement_row = $aIT_agreement_result[0]; } ?>

- :