function setCampaign($groupid)
{
$objResponse = new xajaxResponse();
$res = Customer::getRecordsByGroupid($groupid, "campaign");
//添加option
while ($res->fetchInto($row)) {
$objResponse->addScript("addOption('campaignid','" . $row['id'] . "','" . $row['campaignname'] . "');");
}
return $objResponse;
}
/**
* Imprime la forma para editar un nuevo registro sobre el DIV identificado por "formDiv".
*
* @param $id (int) Identificador del registro a ser editado.
* @return $html (string) Devuelve una cadena de caracteres que contiene la forma con los datos
* a extraidos de la base de datos para ser editados
*/
function formEdit($id)
{
global $locate;
$remindercalls =& Customer::getRecordByID($id, 'remindercalls');
$groupoptions = '';
$group = astercrm::getGroups();
if ($_SESSION['curuser']['usertype'] == 'admin') {
$groupoptions .= '<select id="groupid" name="groupid" onchange="setAsteriskcalls();">';
$groupoptions .= '<option value="0"></option>';
while ($group->fetchInto($row)) {
$groupoptions .= '<option value="' . $row['groupid'] . '"';
if ($row['groupid'] == $remindercalls['groupid']) {
$groupoptions .= ' selected ';
}
$groupoptions .= '>' . $row['groupname'] . '</option>';
}
$groupoptions .= '</select>';
} else {
while ($group->fetchInto($row)) {
if ($row['id'] == $_SESSION['curuser']['groupid']) {
$groupoptions .= $row['groupname'] . '<input type="hidden" value="' . $row['id'] . '" name="groupid" id="groupid">';
break;
}
}
}
$asteriskcalls = Customer::getRecordsByGroupid($remindercalls['groupid'], 'asteriskcalls');
if ($_SESSION['curuser']['usertype'] == 'admin' || $_SESSION['curuser']['usertype'] == 'groupadmin') {
$asteriskcallsoptions .= '<select id="asteriskcallsid" name="asteriskcallsid">';
$asteriskcallsoptions .= "<OPTION value='0'></OPTION>";
while ($asteriskcalls->fetchInto($row)) {
if ($row['id'] == $remindercalls['asteriskcallsid']) {
$asteriskcallsoptions .= "<OPTION value='" . $row['id'] . "' selected>" . $row['asteriskcallsname'] . "</OPTION>";
} else {
$asteriskcallsoptions .= "<OPTION value='" . $row['id'] . "' >" . $row['asteriskcallsname'] . "</OPTION>";
}
}
$asteriskcallsoptions .= '</select>';
} else {
while ($group->fetchInto($row)) {
if ($row['id'] == $remindercalls['asteriskcallsid']) {
$asteriskcallsoptions .= $row['asteriskcallsname'] . '<input type="hidden" value="' . $row['id'] . '" name="asteriskcallsid" id="asteriskcallsid">';
break;
}
}
}
$html = '
<!-- No edit the next line -->
<form method="post" name="f" id="f">
<table border="1" width="100%" class="adminlist">
<tr>
<td nowrap align="left">' . $locate->Translate("Phone number") . ' *</td>
<td align="left"><input type="text" id="phonenumber" name="phonenumber" size="30" maxlength="50" value="' . $remindercalls['phonenumber'] . '"></td>
</tr>
<tr>
<td nowrap align="left">' . $locate->Translate("Note") . '</td>
<td align="left"><input type="text" id="note" name="note" size="50" maxlength="255" value="' . $remindercalls['note'] . '"></td>
</tr>
<tr>
<td nowrap align="left">' . $locate->Translate("Group") . '</td>
<td align="left">' . $groupoptions . '</td>
</tr>
<tr>
<td nowrap align="left">' . $locate->Translate("Call plan") . ' *</td>
<td align="left">' . $asteriskcallsoptions . '</td>
</tr>
<tr>
<td colspan="2" align="center"><button id="submitButton" onClick=\'xajax_save(xajax.getFormValues("f"));return false;\'>' . $locate->Translate("continue") . '</button></td>
</tr>
</table>
';
$html .= '
</form>
' . $locate->Translate("obligatory_fields") . '
';
return $html;
}
function setAsteriskcalls($groupid)
{
global $locate;
$objResponse = new xajaxResponse();
$res = Customer::getRecordsByGroupid($groupid, 'asteriskcalls');
//添加option
while ($res->fetchInto($row)) {
$objResponse->addScript("addOption('asteriskcallsid','" . $row['id'] . "','" . $row['asteriskcallsname'] . "');");
}
return $objResponse;
}
function setCampaign($groupid)
{
global $locate;
$objResponse = new xajaxResponse();
$res = Customer::getRecordsByGroupid($groupid, "campaign");
//添加option
$objResponse->addScript("addSltOption('campaignid','0','" . $locate->Translate("All") . "');");
while ($res->fetchInto($row)) {
$objResponse->addScript("addSltOption('campaignid','" . $row['id'] . "','" . $row['campaignname'] . "');");
}
return $objResponse;
}
/**
* Imprime la forma para editar un nuevo registro sobre el DIV identificado por "formDiv".
*
* @param $id (int) Identificador del registro a ser editado.
* @return $html (string) Devuelve una cadena de caracteres que contiene la forma con los datos
* a extraidos de la base de datos para ser editados
*/
function formEdit($id)
{
global $locate, $db;
$campaignresult =& Customer::getRecordByID($id, 'campaignresult');
if ($_SESSION['curuser']['usertype'] == 'admin') {
$grouphtml .= '<select name="groupid" id="groupid" onchange="setCampaign();">
<option value=""></option>';
$res = Customer::getGroups();
while ($row = $res->fetchRow()) {
$grouphtml .= '<option value="' . $row['groupid'] . '"';
if ($row['groupid'] == $campaignresult['groupid']) {
$grouphtml .= ' selected ';
}
$grouphtml .= '>' . $row['groupname'] . '</option>';
}
$grouphtml .= '</select>';
} else {
$grouphtml .= $_SESSION['curuser']['group']['groupname'] . '<input type="hidden" name="groupid" id="groupid" value="' . $_SESSION['curuser']['groupid'] . '">';
}
$statusAnswered = "";
$statusNoanswer = "";
if ($campaignresult['status'] == 'ANSWERED') {
$statusAnswered = "checked";
} else {
$statusNoanswer = "checked";
}
$campaign_res = Customer::getRecordsByGroupid($campaignresult['groupid'], "campaign");
while ($campaign_row = $campaign_res->fetchRow()) {
$campaignoption .= '<option value="' . $campaign_row['id'] . '"';
if ($campaign_row['id'] == $campaignresult['campaignid']) {
$campaignoption .= ' selected ';
}
$campaignoption .= '>' . $campaign_row['campaignname'] . '</option>';
}
$parentoption .= '<option value="0"';
if ($campaignresult['parentid'] == 0) {
$parentoption .= ' selected ';
}
$parentoption .= '>' . $locate->Translate("None") . '</option>';
$parent_res = Customer::getRecordsByField('campaignid', $campaignresult['campaignid'], 'campaignresult');
while ($parent_row = $parent_res->fetchRow()) {
if ($parent_row['parentid'] == 0) {
$parentoption .= '<option value="' . $parent_row['id'] . '"';
if ($parent_row['id'] == $campaignresult['parentid']) {
$parentoption .= ' selected ';
}
$parentoption .= '>' . $parent_row['resultname'] . '</option>';
}
}
$html = '
<!-- No edit the next line -->
<form method="post" name="f" id="f">
<table border="1" width="100%" class="adminlist">
<tr>
<td nowrap align="left">' . $locate->Translate("Result Name") . '*</td>
<td align="left"><input type="hidden" id="id" name="id" value="' . $campaignresult['id'] . '"><input type="text" id="resultname" name="resultname" size="30" maxlength="60" value="' . $campaignresult['resultname'] . '"></td>
</tr>
<tr>
<td nowrap align="left">' . $locate->Translate("Result Note") . '</td> <td align="left"><input type="text" id="resultnote" name="resultnote" size="30" maxlength="255" value="' . $campaignresult['resultnote'] . '"></td>
</tr>
<tr>
<td align="left" colspan="2">' . $locate->Translate("Answered") . '
<input type="radio" id="status" name="status" value="Answered" ' . $statusAnswered . '> ' . $locate->Translate("Noanswer") . '
<input type="radio" id="status" name="status" value="Noanswer" ' . $statusNoanswer . '>
</td>
</tr>
<tr>
<td nowrap align="left">' . $locate->Translate("Group") . '</td>
<td align="left">' . $grouphtml . '</td>
</tr>
<tr>
<td align="left" width="25%">' . $locate->Translate("Campaign Name") . '</td>
<td><SELECT id="campaignid" name="campaignid" onchange="setParentResult();">' . $campaignoption . '</SELECT></td>
</tr>
<tr>
<td align="left" width="25%">' . $locate->Translate("Parent Result Name") . '</td>
<td><SELECT id="parentid" name="parentid" >' . $parentoption . '</SELECT></td>
</tr>
<tr>
<td colspan="2" align="center"><button id="submitButton" onClick=\'xajax_update(xajax.getFormValues("f"));return false;\'>' . $locate->Translate("continue") . '</button></td>
</tr>
</table>
';
$html .= '
</form>
' . $locate->Translate("obligatory_fields") . '
';
return $html;
}
function formAdd($surveyid = 0, $optionid = 0)
{
global $locate;
$html = '
<!-- No edit the next line -->
<form method="post" name="f" id="f">
<table border="1" width="100%" class="adminlist" id="tblSurvey">
';
$html .= '<tr><td colspan=2>
' . $locate->Translate("survey_title") . '*
</td></tr>';
if ($surveyid == 0) {
$html .= '<tr><td colspan=2>
<input type="text" size="50" maxlangth="100" id="surveyname" name="surveyname"/>
</td></tr>';
$html .= '<tr><td colspan=2>
' . $locate->Translate("Survey Note") . '
</td></tr>';
$html .= '<tr><td colspan=2>
<input type="text" size="50" maxlangth="254" id="surveynote" name="surveynote"/>
</td></tr>';
$enable_html = '<tr>
<td colspan=2>
<input type="radio" value="1" id="radEnable" name="radEnable" checked>' . $locate->Translate("enable") . '
<input type="radio" value="0" id="radEnable" name="radEnable">' . $locate->Translate("disable") . '
</td>
</tr>';
} else {
$survey = Customer::getRecord($surveyid, 'survey');
$nameCell = "TitleCol";
$html .= '<tr><td colspan="2" id="' . $nameCell . '" style="cursor: pointer;" onDblClick="xajax_editField(\'survey\',\'surveyname\',\'' . $nameCell . '\',\'' . $survey['surveyname'] . '\',\'' . $survey['id'] . '\');return false">' . $survey['surveyname'] . '<input type="hidden" id="surveyid" name="surveyid" value="' . $surveyid . '"/></td></tr>';
$nameCell = "NoteCol";
$html .= '<tr><td colspan=2>
' . $locate->Translate("Survey Note") . '
</td></tr>';
$html .= '<tr><td colspan="2" id="' . $nameCell . '" style="cursor: pointer;" onDblClick="xajax_editField(\'survey\',\'surveynote\',\'' . $nameCell . '\',\'' . $survey['surveynote'] . '\',\'' . $survey['id'] . '\');return false">' . $survey['surveynote'] . ' </td></tr>';
if ($survey['enable'] == 1) {
$enable_html = '<tr>
<td colspan=2>
<input type="radio" value="1" id="radEnable" name="radEnable" checked>' . $locate->Translate("enable") . '
<input type="radio" value="0" id="radEnable" name="radEnable">' . $locate->Translate("disable");
} else {
$enable_html = '<tr>
<td colspan=2>
<input type="radio" value="1" id="radEnable" name="radEnable" >' . $locate->Translate("enable") . '
<input type="radio" value="0" id="radEnable" name="radEnable" checked>' . $locate->Translate("disable");
}
$enable_html .= '<input type="button" onclick="xajax_setSurvey(xajax.getFormValues(\'f\'));return false;" value="' . $locate->Translate("update") . '">
</td>
</tr>';
}
$options = Customer::getOptions($surveyid);
if ($options) {
$ind = 0;
while ($options->fetchInto($row)) {
$nameRow = "formDivRow" . $row['id'];
$nameCell = $nameRow . "Col" . $ind;
$html .= '<tr id="' . $nameRow . '" >' . "\n";
$item_html = "";
if ($row['optiontype'] == "text") {
} else {
$item_html = '(<a href=? onclick="showItem(\'' . $row['id'] . '\');return false;">' . $locate->Translate("Item") . '</a>)';
}
$option_item_number = astercrm::getCountByField("optionid", $row['id'], "surveyoptionitems");
$html .= '
<td align="left" width="25%">' . $locate->Translate("option") . '(<a href="?" onclick="xajax_edit(\'' . $surveyid . '\',\'' . $row['id'] . '\');return false;"><img src="skin/default/images/edit.png"></a><a href="?" onclick="deleteOption(\'' . $row['id'] . '\',\'' . $nameRow . '\');return false;"><img src="skin/default/images/trash.png"></a>)' . $item_html . '
</td><td id="' . $nameCell . '" >' . $row['surveyoption'] . "(" . $locate->Translate($row['optiontype']) . ", {$option_item_number} " . $locate->Translate('items') . ")" . '</td></tr>
<tr>
<td align="left" width="25%">' . $locate->Translate("Option Note") . '</td>
<td id="' . $nameCell . '_note">' . $row['optionnote'] . '</td>
</tr>
<tr><td colspan="2" height="1" bgcolor="#ccc"></td></tr>
';
$ind++;
}
}
$html .= '<tr><td colspan=2>
' . $locate->Translate("option") . '
</td></tr>';
if ($optionid == 0) {
$button_value = $locate->Translate("Add Option");
$optionid = 0;
} else {
$button_value = $locate->Translate("Update Option");
$option = astercrm::getRecordById($optionid, "surveyoptions");
$optiontype[$option['optiontype']] = "selected";
}
$html .= '<tr><td colspan=2>' . $locate->Translate("Title") . ':
<input type="text" size="50" maxlength="50" id="surveyoption" name="surveyoption" value="' . $option['surveyoption'] . '"/>
<SELECT id="optiontype" name="optiontype">
<option value="radio" ' . $optiontype['radio'] . '>' . $locate->Translate("Radio") . '</option>
<option value="checkbox" ' . $optiontype['checkbox'] . '>' . $locate->Translate("Checkbox") . '</option>
<option value="text" ' . $optiontype['text'] . '>' . $locate->Translate("Text") . '</option>
</SELECT>
</td></tr>';
$html .= '<tr><td colspan=2>' . $locate->Translate("Note") . ':
<input type="text" size="50" maxlength="254" id="optionnote" name="optionnote" value="' . $option['optionnote'] . '"/>
<input type="button" value="' . $button_value . '" onclick="addOption(\'f\',\'' . $optionid . '\');return false;">
</td></tr>';
$html .= $enable_html;
if ($_SESSION['curuser']['usertype'] == 'admin') {
$res = Customer::getGroups();
$groupoptions .= '<select name="groupid" id="groupid" onchange="setCampaign();">';
while ($row = $res->fetchRow()) {
$groupoptions .= '<option value="' . $row['groupid'] . '"';
if ($survey['groupid'] == $row['groupid']) {
$groupoptions .= ' selected';
}
$groupoptions .= '>' . $row['groupname'] . '</option>';
}
$groupoptions .= '</select>';
} else {
$groupoptions .= $_SESSION['curuser']['group']['groupname'] . '<input id="groupid" name="groupid" type="hidden" value="' . $_SESSION['curuser']['groupid'] . '">';
}
if ($survey['campaignid'] == 0) {
$campaignoptions = '<option value="0">' . $locate->Translate("All") . '</option>';
}
$campaignres = Customer::getRecordsByGroupid($survey['groupid'], "campaign");
while ($row = $campaignres->fetchRow()) {
$campaignoptions .= '<option value="' . $row['id'] . '"';
if ($survey['campaignid'] == $row['id']) {
$campaignoptions .= ' selected';
}
$campaignoptions .= '>' . $row['campaignname'] . '</option>';
}
$html .= '
<tr>
<td align="left" width="25%">' . $locate->Translate("Group Name") . '</td>
<td>' . $groupoptions . '</td>
</tr>
<tr>
<td align="left" width="25%">' . $locate->Translate("Campaign Name") . '*</td>
<td><SELECT id="campaignid" name="campaignid">' . $campaignoptions . '</SELECT></td>
</tr>';
$html .= '
</table>
</form>
' . $locate->Translate("obligatory_fields") . '
';
return $html;
}