PHP display_chooser函数代码示例

/**
 * Generate the case status report
 *
 * @param mixed  $questionnaire_id The quesitonnaire, if specified
 * @param string $sample_id        The sample, if speified
 * @param mixed  $outcome_id           THe outcome id, if specified
 * 
 * @return false if empty otherwise true if table drawn
 * @author Adam Zammit <adam.zammit@acspri.org.au>
 * @since  2012-10-02
 */
function case_status_report($questionnaire_id = false, $sample_id = false, $outcome_id = false)
{
    global $db;
    $q = "";
    if ($questionnaire_id !== false) {
        $q = "AND c.questionnaire_id = {$questionnaire_id}";
    }
    $s = "";
    if ($sample_id !== false) {
        $s = "AND s.import_id = '{$sample_id}'";
    }
    $o = "";
    if ($outcome_id !== false) {
        $o = "AND c.current_outcome_id = {$outcome_id}";
    }
    $sql = "SELECT \tCONCAT('<a href=\\'supervisor.php?case_id=', c.case_id, '\\'>', c.case_id, '</a>') as case_id,\r\n\t\t\to.description as outcomes,\r\n\t\t\tsi.description as samples, s.Time_zone_name as timezone, TIME_FORMAT(CONVERT_TZ(NOW(),@@session.time_zone,s.Time_zone_name),'" . TIME_FORMAT . "') as time, (SELECT COUNT(*) FROM `call` WHERE `call`.case_id = c.case_id) as nrcalls, (SELECT COUNT(*) FROM call_attempt WHERE call_attempt.case_id = c.case_id) as nrattempts, \t\r\n\t\t\tCASE WHEN ca.end IS NULL THEN '" . TQ_("Available") . "'\r\n\t\t\t\tWHEN TIME_TO_SEC(TIMEDIFF(ca.end,CONVERT_TZ(DATE_SUB(NOW(), INTERVAL co.default_delay_minutes MINUTE),'System','UTC'))) < 0 THEN '" . TQ_("Available") . "'\r\n\t\t\t\tELSE CONCAT(ROUND(TIME_TO_SEC(TIMEDIFF(ca.end,CONVERT_TZ(DATE_SUB(NOW(), INTERVAL co.default_delay_minutes MINUTE),'System','UTC'))) / 60),'&emsp;" . TQ_("minutes") . "')\r\n\t\t\tEND AS availableinmin,\r\n\t\t\tCASE WHEN oq.operator_id IS NULL THEN \r\n\t\t\t\tCONCAT('')\r\n\t\t\tELSE CONCAT('<span class=\\'text-info\\'>', oq.firstName,' ',oq.lastName,'</span>')\r\n\t\t\tEND AS assignedoperator,\r\n\t\t\tCASE WHEN oq.operator_id IS NULL THEN \r\n\t\t\t\tCONCAT('')\r\n\t\t\tELSE CONCAT(' &emsp; ', cq.sortorder ,'&emsp;')\r\n\t\t\tEND AS ordr,\r\n\t\t\tCASE WHEN oq.operator_id IS NULL THEN \r\n\t\t\t\tCONCAT('<span data-toggle=\\'tooltip\\' title=\\'" . TQ_("Not assigned, select to assign") . "\\'><input  type=\\'checkbox\\' name=\\'c', c.case_id, '\\' value=\\'', c.case_id, '\\' /></span>')\r\n\t\t\tELSE CONCAT('<a href=\"?questionnaire_id={$questionnaire_id}&amp;sample_import_id={$sample_id}&amp;unassign=', cq.case_queue_id, '\" data-toggle=\\'tooltip\\' title=\\'" . TQ_("Click to unassign") . "\\'><i class=\\'fa fa-trash-o fa-lg text-danger\\'></i></a>')\r\n\t\t\tEND AS flag\t\r\n\t\tFROM `case` as c\r\n\t\tJOIN questionnaire as q ON (q.questionnaire_id = c.questionnaire_id and q.enabled = 1)\r\n\t\tJOIN outcome as o ON (o.outcome_id = c.current_outcome_id AND o.outcome_type_id = 1)\r\n\t\tJOIN sample as s ON (s.sample_id = c.sample_id {$s})\r\n\t\tJOIN sample_import as si ON (s.import_id = si.sample_import_id AND si.enabled = 1)\r\n\t\tJOIN questionnaire_sample as qs ON (qs.questionnaire_id = {$questionnaire_id} AND qs.sample_import_id = s.import_id)\r\n\t\tLEFT JOIN `call` as ca ON (ca.call_id = c.last_call_id)\r\n\t\tLEFT JOIN outcome as co ON (co.outcome_id = ca.outcome_id)\r\n\t\tLEFT JOIN case_queue as cq ON (cq.case_id = c.case_id)\r\n\t\tLEFT JOIN operator as oq ON (cq.operator_id = oq.operator_id)\r\n\t\tLEFT JOIN (questionnaire_sample_quota as qsq) on (s.import_id  = qsq.sample_import_id and c.questionnaire_id = qsq.questionnaire_id)\r\n\t\tLEFT JOIN (questionnaire_sample_quota_row as qsqr) on (s.import_id = qsqr.sample_import_id  and c.questionnaire_id = qsqr.questionnaire_id)\r\n\t\tWHERE c.current_operator_id IS NULL {$q} {$o}\r\n\t\tAND (qsq.quota_reached IS NULL OR qsq.quota_reached != 1 )\r\n\t\tAND (qsqr.quota_reached IS NULL OR qsqr.quota_reached != 1)\r\n\t\tGROUP BY c.case_id ORDER BY c.case_id ASC";
    print "<form method=\"post\" action=\"?questionnaire_id={$questionnaire_id}&sample_import_id={$sample_id}\">";
    $rs2 = $db->GetAll($sql);
    translate_array($rs2, array("outcomes"));
    $datacol = array('case_id', 'samples', 'timezone', 'time', 'nrattempts', 'nrcalls', 'outcomes', 'availableinmin', 'assignedoperator', 'ordr', 'flag');
    $headers = array(T_("Case id"), T_("Sample"), T_("Timezone"), T_("Time NOW"), T_("Call attempts"), T_("Calls"), T_("Outcome"), T_("Available in"), T_("Assigned to"), T_("Order"), "<i class='fa fa-check-square-o fa-lg'></i>");
    if (isset($_GET['sample_import_id'])) {
        unset($datacol[1]);
        unset($headers[1]);
    }
    xhtml_table($rs2, $datacol, $headers, "tclass", false, false, "bs-table");
    $sql = "SELECT operator_id as value,CONCAT(firstName,' ', lastName) as description, '' selected\r\n\t\tFROM operator\r\n\t\tWHERE enabled = 1";
    $rs3 = $db->GetAll($sql);
    print "<h4 class='col-sm-offset-5 pull-left text-right control-label'>" . T_("Assign selected cases to") . "&ensp;" . T_("operator") . "&ensp;:&emsp;</h4> ";
    display_chooser($rs3, "operator_id", "operator_id", true, false, false, true, false, true, "pull-left");
    print "&emsp;<button class='btn btn-default' type='submit' data-toggle='tooltip' title='" . T_("Assign cases to operator queue") . "'><i class='fa fa-link fa-lg text-primary'></i>&emsp;" . T_("Assign") . "</button>";
    print "</form></br>";
    return true;
}

}
//Select code group
$sql = "SELECT code_group_id as value,description, CASE WHEN code_group_id = '{$code_group_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\tFROM code_group";
print "<div>" . T_("Select code group: ");
$rs2 = $db->GetAll($sql);
translate_array($rs2, array("description"));
display_chooser($rs2, 'code_group_id', 'code_group_id');
print "</div>";
if ($code_group_id != 0) {
    print "<form action='' method='post'><div><input type='hidden' name='code_group_id' value='{$code_group_id}'/></div>";
    //Parent process (if any)
    $sql = "SELECT process_id as value, description, '' AS selected\r\n\t\tFROM process";
    print "<div>" . T_("Select parent process (if any): ");
    $rs2 = $db->GetAll($sql);
    translate_array($rs2, array("description"));
    display_chooser($rs2, 'process_id', 'process_id', true, false, false);
    print "</div>";
    print "<div><input type='checkbox' name='autolabel' id='autolabel'/><label for='autolabel'>" . T_("Automatically assign a code if the code label exactly matches the data?") . "</label></div>";
    print "<div><input type='checkbox' name='autovalue' id='autovalue'/><label for='autovalue'>" . T_("Automatically assign a code if the code value exactly matches the data?") . "</label></div>";
    print "<div><input type='checkbox' name='autokeyword' id='autokeyword'/><label for='autokeyword'>" . T_("Automatically assign a code if there is a matching code keyword in the database?") . "</label></div>";
    print "<div><input type='checkbox' name='template' id='template'/><label for='template'>" . T_("Use the code group as a template? (Create a new, editable code group for each work unit that this is assigned to)") . "</label></div>";
    print "<div><input type='checkbox' name='exclusive' id='exclusive'/><label for='exclusive'>" . T_("Should this process only be run by operator(s) that have not worked on the prior process (exclusive)?") . "</label></div>";
    print "<div>" . T_("Name for process using this code: ");
    print "<input type='text' name='description'/>";
    print "</div>";
    print "<p><input type='submit' name='submit' value='" . T_("Create new process") . "'/></p></form>";
}
//List existing processes
$sql = "SELECT p.process_id,p.description as pdes,c.description as cdes\r\n\tFROM process as p\r\n\tLEFT JOIN code_group AS c ON (c.code_group_id = p.code_group_id)";
p(T_("Existing processes"), 'h2');
$rs2 = $db->GetAll($sql);

}
p(T_("The CSV file must have 2 fields: code,keywords"), "p");
p(T_("No fields may be blank"), "p");
p(T_("Do not include a header line as this will be imported as a code/keyword pair"), "p");
//Select a code group to export data from
$sql = "SELECT code_group_id as value,description, ''  AS selected\r\n\tFROM code_group";
$rs2 = $db->GetAll($sql);
translate_array($rs2, array("description"));
print "</div>";
?>
<form enctype="multipart/form-data" action="" method="post">
<p><input type="hidden" name="MAX_FILE_SIZE" value="1000000000" /></p>
<p><?php 
echo T_("Choose the CSV code keywords file to upload:");
?>
<input name="datafile" type="file" /></p>
<p><?php 
echo T_("Description for this code keywords file:");
?>
<input name="description" type="text" /></p>
<p><?php 
echo T_("What coding scheme does this list apply to?");
display_chooser($rs2, 'code_group_id', 'code_group_id', false, false, false, false);
?>
<p><input type="submit" name="import_file" value="<?php 
echo T_("Create new keyword code");
?>
"/></p>
</form>
<?php 
xhtml_foot();

            print "<h2>" . T_("Failed to load banding XML file") . "</h2>";
        }
    }
}
print "<h1>" . T_("Update banding from XML") . "</h1>";
print "<p>" . T_("WARNING: All previous banding will be erased") . "</p>";
$sql = "SELECT description,qid as value, '' AS selected\r\n\tFROM questionnaires";
$rs = $db->GetAll($sql);
?>

<form enctype="multipart/form-data" action="" method="post">
	<p><input type="hidden" name="MAX_FILE_SIZE" value="1000000000" /></p>
	<p><?php 
echo T_("Select banding XML file");
?>
: <input name="bandingxml" type="file" /></p>
	<p><?php 
echo T_("Select questionnaire");
?>
: <?php 
display_chooser($rs, 'qid', 'qid', true, false, false, false, false);
?>
<br/></p>
	<p><input type="submit" value="<?php 
echo T_("Upload XML");
?>
" /></p>
</form>

<?php 
xhtml_foot();

    $code_id = "NULL";
    if (!empty($_POST['code_id'])) {
        $code_id = intval($_POST['code_id']);
    }
    $sql = "UPDATE code_group\r\n\t\tSET blank_code_id = {$code_id}\r\n\t\tWHERE code_group_id = {$code_group_id}";
    $db->Execute($sql);
}
xhtml_head(T_("Select blank code"), true, array("../css/table.css"), array("../js/display.js"));
$code_group_id = 0;
if (isset($_GET['code_group_id'])) {
    $code_group_id = intval($_GET['code_group_id']);
}
//Select code group
$sql = "SELECT code_group_id as value,description, CASE WHEN code_group_id = '{$code_group_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\tFROM code_group";
print "<div>" . T_("Select code group: ");
$rs2 = $db->GetAll($sql);
translate_array($rs2, array("description"));
display_chooser($rs2, 'code_group_id', 'code_group_id');
print "</div>";
if ($code_group_id != 0) {
    //List codes for the first level of this code groups (include null)
    $sql = "SELECT c.code_id as value, c.label as description, CASE WHEN c.code_id = cg.blank_code_id THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\tFROM `code` as c, code_level as cl, code_group as cg\r\n\t\tWHERE cl.code_group_id = '{$code_group_id}'\r\n\t\tAND cg.code_group_id = '{$code_group_id}'\r\n\t\tAND cl.level = 0\r\n\t\tAND c.code_level_id = cl.code_level_id";
    print "<form action='' method='post'><div><input type='hidden' name='code_group_id' value='{$code_group_id}'/></div>";
    print "<div>" . T_("Select code: ");
    $c = $db->GetAll($sql);
    translate_array($c, array("description"));
    display_chooser($c, 'code_id', 'code_id', true, false, false);
    print "</div>";
    print "<p><input type='submit' name='submit' value='" . T_("Assign as blank code") . "'/></p></form>";
}
xhtml_foot();

translate_array($daysofweek, array("description"));
?>
	<div class="panel-body col-sm-4"><form method="post" action="" class="form-horizontal">
	<table class="table-hover table-condensed " id="shifts"><thead class="text-center highlight">
<?php 
print "<tr ><th >" . T_("Day") . "</th><th  >" . T_("Start") . "</th><th >" . T_("End") . "</th></tr></thead><tbody>";
$count = 0;
foreach ($shifts as $shift) {
    print "<tr id='row-{$count}'><td>";
    // class='row_to_clone' /* these are not the rows to clone...*/
    display_chooser($daysofweek, "day[{$count}]", false, true, false, false, false, array("description", $shift['dt']));
    print "</td>\r\n\t\t<td><div class=\"input-group clockpicker\"><input readonly class=\"form-control\" size=\"8\" maxlength=\"8\" name=\"start[{$count}]\" type=\"text\" value=\"{$shift['start']}\"/><span class=\"input-group-addon\"><span class=\"glyphicon glyphicon-time fa\"></span></span></div></td>\r\n\t\t<td><div class=\"input-group clockpicker\"><input readonly class=\"form-control\" size=\"8\" maxlength=\"8\" name=\"end[{$count}]\" type=\"text\" value=\"{$shift['end']}\"/><span class=\"input-group-addon\"><span class=\"glyphicon glyphicon-time fa\"></span></span></div></td></tr>";
    $count++;
}
print "<tr  class='row_to_clone' id='row-{$count}'><td>";
display_chooser($daysofweek, "day[{$count}]", false, true, false, false, false, false);
print "\t</td><td><div class=\"input-group clockpicker\"><input readonly class=\"form-control\" size=\"8\" maxlength=\"8\" name=\"start[{$count}]\" type=\"text\" value=\"08:00:00\"/><span class=\"input-group-addon\"><span class=\"glyphicon glyphicon-time fa\"></span></span></div></td>\r\n\t\t\t<td><div class=\"input-group clockpicker\"><input readonly class=\"form-control\" size=\"8\" maxlength=\"8\" name=\"end[{$count}]\"   type=\"text\"  value=\"20:00:00\"/><span class=\"input-group-addon\"><span class=\"glyphicon glyphicon-time fa\"></span></span></div></td></tr>";
?>
	</tbody></table>
	<a class="btn btn-default btn-sm" onclick="addRow(); return false;" href=""><?php 
echo T_("Add row");
?>
</a><br/><br/>
	<input class="btn btn-default " type="submit" name="submit" value="<?php 
echo T_("Save changes to shifts");
?>
"/>
	</form></div>
<?php 
xhtml_foot($js_foot);
?>

        }
        ?>
 value="1" /></div>
	</div>
	<div id="usesvoip" style="display:none" >
	<div class="form-group">
		<label class="col-lg-3 control-label"><?php 
        echo T_("Extension") . ": ";
        ?>
</label>
		
	<?php 
        if (!empty($ers)) {
            ?>
				<div class="col-lg-3"><?php 
            display_chooser($ers, "extension_id", "extension_id", true, false, false, true, false, true, "form-inline");
            ?>
</div>
				<div class="col-lg-6 form-inline"> <?php 
            echo T_("Edit") . "&emsp;";
        } else {
            ?>
  	<div class="col-lg-6 form-inline"> <?php 
            echo T_("Add") . "&emsp;";
        }
        ?>
					<a  href='extensionstatus.php' class="btn btn-default fa"><?php 
        echo T_("Extensions");
        ?>
</a>
				</div>

}
//Select a data file to display
$sql = "SELECT data_id as value,description, CASE WHEN data_id = '{$data_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\tFROM data";
print "<div>" . T_("Select data file: ");
display_chooser($db->GetAll($sql), 'data_id', 'data_id');
print "</div>";
if ($data_id != 0) {
    $column_id = 0;
    if (isset($_GET['column_id'])) {
        $column_id = intval($_GET['column_id']);
    }
    //Select variable (column)
    $sql = "SELECT column_id as value, name as description, CASE WHEN column_id = '{$column_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\tFROM `column`\r\n\t\tWHERE data_id = '{$data_id}'";
    print "<div>" . T_("Select variable: ");
    $c = $db->GetAll($sql);
    display_chooser($c, 'column_id', 'column_id', true, "data_id={$data_id}");
    print "</div>";
    $sql = "SELECT column_id,name,code_level_id\r\n\t\tFROM `column` \r\n\t\tWHERE data_id = '{$data_id}'";
    if ($column_id != 0) {
        $sql .= " AND column_id = '{$column_id}'";
        $cols = $db->GetAll($sql);
        $sql = "SELECT c.row_id\r\n\t\tFROM cell as c\r\n\t\tWHERE c.column_id = {$cols[0]['column_id']}\r\n\t\tGROUP BY c.row_id";
        $rows = $db->GetAll($sql);
        print "<table class='tclass'>";
        print "<tr>";
        foreach ($cols as $c) {
            print "<th>" . $c['name'] . "</th>";
        }
        print "</tr>";
        foreach ($rows as $r) {
            print "<tr>";

        display_chooser($rs2, 'process_id', 'process_id', true, "data_id={$data_id}&column_id={$column_id}");
        if ($process_id != 0) {
            print "<div>" . T_("Select operator(s) to apply this process") . "</div>";
            print "<form action='' method='post'><div><input type='hidden' name='column_id' value='{$column_id}'/><input type='hidden' name='data_id' value='{$data_id}'/><input type='hidden' name='process_id' value='{$process_id}'/></div>";
            //display a checkbox of all operators
            $sql = "SELECT o.operator_id,o.description, CONCAT('<input type=\\'checkbox\\' name=\\'oid', o.operator_id, '\\' value=\\'', o.operator_id, '\\'/>') as cbox\r\n\t\t\t\tFROM operator as o, operator_process as op, operator_data as od\r\n\t\t\t\tWHERE o.operator_id = op.operator_id \r\n\t\t\t\tAND op.process_id = '{$process_id}'\r\n\t\t\t\tAND od.operator_id = o.operator_id\r\n\t\t\t\tAND od.data_id = '{$data_id}'";
            $rs = $db->GetAll($sql);
            //Add an "any operator" field
            $rs[] = array('description' => T_("Any operator: enter how many"), 'cbox' => "<input type='text' name='any' value='0'/>");
            xhtml_table($rs, array('description', 'cbox'), array(T_("Operator"), T_("Select")));
            //Add a reference column if applicable to this process
            print "<div>" . T_("If a reference column is applicable, choose it below") . "</div>";
            $sql = "SELECT column_id as value, name as description, '' AS selected\r\n\t\t\t\tFROM `column`\r\n\t\t\t\tWHERE data_id = '{$data_id}'";
            display_chooser($db->GetAll($sql), 'reference', 'reference', true, false, false);
            //Add a code group to select to generate multiple columns
            print "<div>" . T_("To create a multiple choice coding scheme, select a code group to generate multiple groups from") . "</div>";
            $sql = "SELECT code_group_id as value, description, '' AS selected\r\n\t\t\t\tFROM code_group";
            display_chooser($db->GetAll($sql), 'multi_code_group_id', 'multi_code_group_id', true, false, false);
            print "<div><input type='submit' name='submit' value='" . T_("Create work") . "'/></div>";
            //List work already created for this data_id
            $sql = "SELECT w.work_id,c.name,p.description, wp.parent_work_id, o.description as oname, CONCAT('<input type=\\'checkbox\\' name=\\'cid', w.work_id, '\\' value=\\'', w.work_id, '\\'/>') as cbox\r\n\t\t\r\n\t\t\t\tFROM work as w\r\n\t\t\t\tJOIN process as p ON (p.process_id = w.process_id)\r\n\t\t\t\tJOIN `column` as c ON (c.data_id = '{$data_id}' AND w.column_id = c.column_id)\r\n\t\t\t\tLEFT JOIN work_parent as wp on (wp.work_id = w.work_id)\r\n\t\t\t\tLEFT JOIN operator as o on (w.operator_id = o.operator_id)\r\n\t\t\t\tWHERE w.column_id = '{$column_id}'\r\n\t\t\t\tORDER BY w.work_id ASC";
            $rs = $db->GetAll($sql);
            translate_array($rs, array("description"));
            p(T_("Current work for this data file and column"), "h2");
            xhtml_table($rs, array('work_id', 'name', 'description', 'parent_work_id', 'oname', 'cbox'), array(T_("Work ID"), T_("Variable name"), T_("Process description"), T_("Parent job"), T_("Assigned operator"), T_("Create comparison work")));
            print "<div><input type='submit' name='submit_compare' value='" . T_("Create comparison work") . "'/></div>";
            print "</form>";
        }
    }
}
xhtml_foot();

    $btid = $row['btid'];
    $varname = $row['varname'];
    $width = $row['width'];
    //display the cropped boxes
    print "<img src=\"showpage.php?bgid={$bgid}\"/>";
    ?>
<form method="post" action="<?php 
    echo $_SERVER['PHP_SELF'] . "?bgid={$bgid}";
    ?>
"><?php 
    //display group selection
    $sql = "SELECT description,btid as value, CASE WHEN btid = '{$btid}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\tFROM boxgrouptypes";
    $rs = $db->GetAll($sql);
    print T_("Group type:");
    translate_array($rs, array("description"));
    display_chooser($rs, "btid", "btid", false, false, false, false, false);
    //display variable name
    ?>
<br/><?php 
    echo T_("Variable name:");
    ?>
 <input type="text" size="12" value="<?php 
    echo $varname;
    ?>
" name="varname"><br/><?php 
    //display width
    echo T_("Width:");
    ?>
 <input type="text" size="12" value="<?php 
    echo $width;
    ?>

$e = $db->GetOne($sql);
if (!empty($e)) {
    header('Location: index.php');
    die;
}
if (isset($_POST['extension_id']) && !empty($_POST['extension_id'])) {
    if ($operator_id) {
        $e = intval($_POST['extension_id']);
        $sql = "UPDATE `extension`\r\n            SET current_operator_id = {$operator_id}\r\n            WHERE current_operator_id IS NULL\r\n            AND extension_id = {$e}";
        $r = $db->Execute($sql);
        if ($r) {
            header('Location: index.php');
            die;
        }
    }
}
xhtml_head(T_("queXS"));
$sql = "SELECT e.extension_id as value, e.extension as description\r\n        FROM `extension` as e\r\n        WHERE e.current_operator_id IS NULL";
$ers = $db->GetAll($sql);
if (empty($ers)) {
    print "<p>" . T_("There are no extensions available, please contact the supervisor or click below to try again for an available extension") . "</p>";
    print "<p><a href='?'>" . T_("Try again") . "</a></p>";
} else {
    print "<h2>" . T_("Select extension") . "</h2>";
    print "<p>" . T_("Please select your extension from the list below then click on 'Choose extension'") . "</p>";
    print "<form action='?' method='post'>";
    print "<label for='extension_id'>" . T_("Extension") . ":</label>";
    display_chooser($ers, "extension_id", "extension_id", false, false, false, false);
    print "<p><input type='submit' value='" . T_("Choose extension") . "'/></p></form>";
}
xhtml_foot();

$sql = "SELECT data_id as value,description, CASE WHEN data_id = '{$data_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\tFROM data";
print "<div>" . T_("Select data file: ");
display_chooser($db->GetAll($sql), 'data_id', 'data_id');
print "</div>";
if ($data_id != 0) {
    $code_column = 0;
    if (isset($_GET['code_column'])) {
        $code_column = intval($_GET['code_column']);
    }
    $sql = "SELECT c.column_id as value, c.description, CASE WHEN column_id = '{$code_column}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\tFROM `column` as c\r\n\t\tWHERE c.data_id = '{$data_id}'\r\n\t\tAND code_level_id IS NOT NULL";
    //select a column containing a code
    print "<div>" . T_("Select column containing the code: ");
    display_chooser($db->GetAll($sql), 'code_column', 'code_column', true, "data_id={$data_id}");
    print "</div>";
    if ($code_column != 0) {
        //select a column containing the text
        $text_column = 0;
        if (isset($_GET['text_column'])) {
            $text_column = intval($_GET['text_column']);
        }
        $sql = "SELECT c.column_id as value, c.description, CASE WHEN column_id = '{$text_column}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\t\tFROM `column` as c\r\n\t\t\tWHERE c.data_id = '{$data_id}'\r\n\t\t\tAND c.column_id != '{$code_column}'";
        //select a column containing a code
        print "<div>" . T_("Select column containing the keyword: ");
        display_chooser($db->GetAll($sql), 'text_column', 'text_column', true, "data_id={$data_id}&amp;code_column={$code_column}");
        print "</div>";
        if ($text_column != 0) {
            print "<div><a href='?download=download&amp;data_id={$data_id}&amp;code_column={$code_column}&amp;text_column={$text_column}'>" . T_("Download correspondence CSV") . "</a></div>";
        }
    }
}
xhtml_foot();

    print "<div>" . T_("Select column: ");
    $c = $db->GetAll($sql);
    display_chooser($c, 'column_id', 'column_id', true, "data_id={$data_id}");
    print "</div>";
    if ($column_id != 0) {
        $process_id = 0;
        if (isset($_GET['process_id'])) {
            $process_id = intval($_GET['process_id']);
        }
        //List processes assigned to this data file and column
        $sql = "SELECT p.process_id as value, p.description, CASE WHEN p.process_id = '{$process_id}' THEN 'selected=\\'selected\\'' ELSE '' END AS selected\r\n\t\t\tFROM `process` as p, work as w, `column` as c\r\n\t\t\tWHERE w.column_id = '{$column_id}'\r\n\t\t\tAND w.process_id = p.process_id\r\n\t\t\tGROUP BY p.process_id";
        print "<div>" . T_("Select process: ");
        $c = $db->GetAll($sql);
        translate_array($c, array("description"));
        display_chooser($c, 'process_id', 'process_id', true, "data_id={$data_id}&amp;column_id={$column_id}");
        print "</div>";
        if ($process_id != 0) {
            //Display columns selected for this data file and process
            $sql = "SELECT p.description as pdes, c.description as cdes, CONCAT('<a href=\\'?data_id={$data_id}&amp;remove=remove&amp;process_id=',cpc.process_id,'&amp;column_id=',cpc.column_id,'&amp;relevant_column_id=',cpc.relevant_column_id,'\\'>" . T_("Remove") . "</a>') as link\r\n\t\t\t\tFROM process as p, `column` as c, column_process_column as cpc\r\n\t\t\t\tWHERE cpc.process_id = '{$process_id}'\r\n\t\t\t\tAND cpc.column_id = '{$column_id}'\r\n\t\t\t\tAND cpc.relevant_column_id = c.column_id\r\n\t\t\t\tAND cpc.process_id = p.process_id";
            $rs = $db->GetAll($sql);
            xhtml_table($rs, array('pdes', 'cdes', 'link'), array(T_("Process"), T_("Related column"), T_("Remove")));
            print "<div>" . T_("Select column to add") . "</div>";
            print "<form action='' method='post'><div><input type='hidden' name='data_id' value='{$data_id}'/><input type='hidden' name='process_id' value='{$process_id}'/><input type='hidden' name='column_id' value='{$column_id}'/></div>";
            //display a dropdown of all columns
            $sql = "SELECT column_id as value,description, '' AS selected\r\n\t\t\t\tFROM `column`\r\n\t\t\t\tWHERE data_id = '{$data_id}'";
            display_chooser($db->GetAll($sql), 'relevant_column_id', 'relevant_column_id', true, false, false);
            print "<div><input type='submit' name='submit' value='" . T_("Add column") . "'/></div></form>";
        }
    }
}
xhtml_foot();

        print "<div class='clearfix'></div></br><div class='alert alert-info col-lg-6 '>" . T_("ATTENTION!    Keep in mind that you're setting 'Start' & 'End' appoinment times in RESPONDENT LOCAL TIME !!!") . "</div><div class='clearfix'></div>";
        date_default_timezone_set($rtz);
        print "<label class='text-right col-lg-2 control-label'>" . T_("Respondent TimeZone") . ":</label>\r\n\t\t\t\t\t<h4 class='col-lg-2  text-danger text-uppercase  fa-lg'>" . $rtz . "</h4>\r\n\t\t\t\t\t<label class=''>" . T_("Respondent Time") . ":&emsp;<b class='fa fa-2x '>" . date("H:i:s") . "</b></label>";
        print "<br/><br/><label class='pull-left text-right control-label col-lg-2' for='start'>" . T_("Start time") . "</label>\r\n\t\t\t\t\t<div class='pull-left'><input class='form-control' type='text' value='{$start}' id='start' name='start'/></div>";
        print "<br/><br/><label class='pull-left text-right control-label col-lg-2' for='end'>" . T_("End time") . "</label>\r\n\t\t\t\t\t<div class='pull-left'><input class='form-control' type='text' value='{$end}' id='end' name='end'/></div>";
        print "<br/><br/><label class='pull-left text-right control-label col-lg-2' for='require_operator_id'>" . T_("Appointment with") . "</label>";
        $ops = $db->GetAll("SELECT o.operator_id as value,\r\n\t\t\t\t\t\tCONCAT(o.firstName, ' ', o.lastName) as description,\r\n\t\t\t\t\t\tCASE WHEN o.operator_id = '{$require_operator_id}' THEN 'selected=\\'selected\\'' ELSE '' END as selected\r\n\t\t\t\t\t\tFROM operator as o");
        $selected = "selected=\\'selected\\'";
        foreach ($ops as $o) {
            if (!empty($o['selected'])) {
                $selected = "";
                break;
            }
        }
        array_unshift($ops, array('value' => 0, 'description' => T_("Any operator"), 'selected' => $selected));
        display_chooser($ops, "require_operator_id", "require_operator_id", false, false, false, true, false, true, "pull-left");
        print "\t<input type='hidden' value='{$appointment_id}' id='appointment_id' name='appointment_id'/>\r\n\t\t\t\t\t<input type='hidden' value='update' id='update' name='update'/>\r\n\t\t\t\t\t<input type='hidden' value='{$case_id}' id='case_id' name='case_id'/>";
        if (isset($_GET['new']) && $_GET['new'] == 'new') {
            print "<input type='hidden' value='create' id='new' name='new'/>";
        }
        print "<div class='clearfix'></div><br/><br/>\r\n\t\t\t\t<div class='col-lg-2'><a href='?'  class='btn btn-default pull-left'><i class='fa fa-ban fa-lg'></i>&emsp;" . T_("Cancel edit") . "</a></div>";
        print "<div class='col-lg-2'>\r\n\t\t\t\t\t<button type='submit' class='btn btn-primary btn-block'><i class='fa fa-floppy-o fa-lg'></i>&emsp;" . T_("Save changes") . "</button>\r\n\t\t\t\t\t</div>";
        print "<div class='col-lg-2'><a href='' class='btn btn-default pull-right'  toggle='confirmation' data-placement='left' data-href='?delete=delete&amp;appointment_id={$appointment_id}&amp;case_id={$case_id}' ><i class='fa fa-trash fa-lg text-danger'></i>&emsp;" . T_("Delete this appointment") . "</a></div>";
        print "</form>";
    }
} else {
    $operator_id = get_operator_id();
    $subtitle = T_("Appointments");
    xhtml_head(T_("Display Appointments"), true, $css, $js_head, false, 30);
    print "<h3>" . T_("All appointments (with times displayed in your time zone)") . "</h3>";
    $sql = "SELECT q.description, si.description as smpl, CONVERT_TZ(a.start,'UTC',@@session.time_zone) as start, CONVERT_TZ(a.end,'UTC',@@session.time_zone) as end,CONCAT(r.firstName, ' ', r.lastName) as resp, IFNULL(ou.description,'" . TQ_("Not yet called") . "') as outcome, oo.firstName as makerName, ooo.firstName as callerName, \r\n\tCONCAT('<a href=\\'supervisor.php?case_id=', c.case_id, '\\'>', c.case_id, '</a>') as case_id, \r\n\tCONCAT('&emsp;<a href=\\'\\'><i class=\\'fa fa-trash-o fa-lg text-danger\\' toggle=\\'confirmation\\' data-placement=\\'left\\' data-href=\\'?case_id=', c.case_id, '&amp;appointment_id=', a.appointment_id, '&amp;delete=delete\\'  ></i></a>&emsp;') as link, \r\n\tCONCAT('&emsp;<a href=\\'?case_id=', c.case_id, '&amp;appointment_id=', a.appointment_id, '\\'><i class=\\'fa fa-pencil-square-o fa-lg\\' ></i></a>&emsp;') as edit,IFNULL(ao.firstName,'" . TQ_("Any operator") . "') as witho \r\n\tFROM appointment as a \r\n\tJOIN (`case` as c, respondent as r, questionnaire as q, operator as oo, call_attempt as cc, `sample` as s, sample_import as si) on (c.sample_id = s.sample_id and  a.case_id = c.case_id and a.respondent_id = r.respondent_id and q.questionnaire_id = c.questionnaire_id and a.call_attempt_id = cc.call_attempt_id and cc.operator_id =  oo.operator_id and si.sample_import_id = s.import_id) \r\n\tLEFT JOIN (`call` as ca, outcome as ou, operator as ooo) ON (ca.call_id = a.completed_call_id and ou.outcome_id = ca.outcome_id and ca.operator_id = ooo.operator_id) \r\n\tLEFT JOIN operator AS ao ON ao.operator_id = a.require_operator_id \r\n\tLEFT JOIN (questionnaire_sample_quota as qsq) on (s.import_id  = qsq.sample_import_id and c.questionnaire_id = qsq.questionnaire_id)\r\n\tLEFT JOIN (questionnaire_sample_quota_row as qsqr) on (s.import_id = qsqr.sample_import_id  and c.questionnaire_id = qsqr.questionnaire_id)\r\n\tWHERE q.enabled=1 AND si.enabled=1 AND a.end >= CONVERT_TZ(NOW(),'System','UTC') AND c.current_outcome_id IN (19,20,21,22)\r\n\tAND (qsq.quota_reached IS NULL OR qsq.quota_reached != 1)\r\n\tAND (qsqr.quota_reached IS NULL OR qsqr.quota_reached != 1)\r\n\tGROUP BY c.case_id ORDER BY a.start ASC";

        $rs = $db->GetAll($sql);
        print "<form action='?' method='post'>";
        print "<div><input type='hidden' name='column_id' value='{$column_id}'/><input type='hidden' name='data_id' value='{$data_id}'/></div>";
        foreach ($rs as $r) {
            print "<div><input type='text' name='n{$r['column_id']}' id='n{$r['column_id']}' value=\"{$r['name']}\" size='5'/> \r\n\t<input type='text' name='d{$r['column_id']}' id='d{$r['column_id']}' value=\"{$r['description']}\" size='100'/></div>";
            if (!empty($r['code_level_id'])) {
                $old_code_level_id = 0;
                $cli = $r['code_level_id'];
                if (isset($_GET['old_code_level_id'])) {
                    $old_code_level_id = $_GET['old_code_level_id'];
                    if ($old_code_level_id != 0) {
                        $cli = $old_code_level_id;
                    }
                }
                $sql = "SELECT co.code_level_id as value, co.name as description, CASE WHEN co.code_level_id ='{$old_code_level_id}' THEN 'selected=\\'selected\\'' ELSE '' END as selected\r\n\t\t\t\t\tFROM `column` as co\r\n\t\t\t\t\tWHERE co.data_id = '{$data_id}' \r\n\t\t\t\t\tAND co.column_id < '{$column_id}'\r\n\t\t\t\t\tAND co.code_level_id IS NOT NULL\r\n\t\t\t\t\tORDER BY co.column_id DESC";
                $oldcodes = $db->GetAll($sql);
                print "<div>" . T_("Choose an existing code level: ");
                display_chooser($oldcodes, 'old_code_level_id', 'old_code_level_id', true, "data_id={$data_id}&amp;column_id={$column_id}");
                print "</div>";
                $sql = "SELECT code_id,value,label\r\n\t\t\t\t\tFROM code\r\n\t\t\t\t\tWHERE code_level_id = '{$cli}'";
                $codes = $db->GetAll($sql);
                foreach ($codes as $c) {
                    print "<div><input type='text' name='c{$c['code_id']}' id='c{$c['code_id']}' size='2' value=\"{$c['value']}\"/> <input type='text' name='l{$c['code_id']}' id='l{$c['code_id']}' value=\"{$c['label']}\" size='50'/></div>";
                }
                print "<div><input type='hidden' name='code_level_id' id='code_level_id' value='{$cli}'/></div>";
            }
        }
        print "<div><input type='submit' name='submit' id='submit' value='" . T_("Update") . "'/><input type='submit' name='submitmove' id='submitmove' value='" . T_("Update and move to next column") . "'/></div></form>";
    }
}
xhtml_foot();