} else {
echo "<table width=100%><td><BR><tr><td bgcolor=\"lightyellow\"><p>2. File COULD NOT be uploaded. Please try again, if this still doens't work please contact your system administrator (must have permission to write)\n </p></td>";
}
}
//run the functions where upload file will occur
if ($_POST['gototable']) {
$file = $_POST['file'];
if (is_array($_SESSION['cells'])) {
$cells = $_SESSION['cells'];
} else {
$cells = separate_cells(compact('action', 'project_id', 'resource_info', 'db', 'user_id', 'file'));
$_SESSION['cells'] = $cells;
#until i figure out a way to keep this data in the client... sessions will have to be the way to go
}
#echo '<pre>';print_r($cells);
echo display_option(compact('cells', 'db', 'user_id', 'project_id', 'resource_info'));
}
if ($_POST['InsertinDB']) {
$cells = $_SESSION['cells'];
$cells['data'] = updateS3DB(compact('cells', 'project_id', 'class_id', 'db', 'user_id', 'resource_info'));
#echo '<pre>here is the report... uff it took a while!';print_r($cells['data']['error']);
echo '<input type="button" onClick="window.location=\'' . $action['listall'] . '\'" value="List all ' . $resource_info['entity'] . '">';
}
}
echo '</form>';
function separate_cells($F)
{
extract($F);
$regexp = $GLOBALS['regexp'];
//1.Create $lines by separating each line of the uploaded file
$lines = file($file);
<div id="listTriggerElems" class="listTrigger">
<div id="triggerElemDrop-0" class="col-xs-12 triggerElemDrop">
</div>';
if (!empty($trigger_info)) {
$count = 0;
foreach ($trigger_info as $elem) {
echo '
<div class="col-xs-5 triggerElem">
<div id="triggerElem-' . $elem->condition_id . '" class="">';
echo '
<div class="center trigger-device-name">
<i class="' . getIcon($elem->device_id) . '"></i>
' . $elem->device_name . '
</div>
<div id="triggerElemOption-' . $elem->condition_id . '" class="center">';
echo display_option($elem->condition_id, $elem->option_id, $elem->option_value, $elem->room_device_id, $elem->operator);
echo '
</div>
</div>';
echo displayBtns($elem->trigger_id, $elem->condition_id, $elem->room_device_id, $elem->option_id);
echo '</div>';
if ($count % 2 == 1 || $elem === end($trigger_info)) {
echo '<div id="triggerElemDrop-' . $elem->condition_id . '" class="col-xs-12 triggerElemDrop">
</div>';
} else {
echo '<div id="triggerElemDrop-' . $elem->condition_id . '" class="col-xs-2 triggerElemDrop">
</div>';
}
$count++;
}
}
<div id="listSmartcmdElems" class="listSmartcmd">
<div id="smartcmdElemDrop-0" class="col-xs-12 smartcmdElemDrop">
</div>';
if (!empty($smartcmd_info)) {
foreach ($smartcmd_info as $elem) {
echo '
<div class="col-xs-12 smartcmdElem">
<div id="smartcmdElem-' . $elem->exec_id . '" class="">';
displayDelay($elem->smartcmd_id, $elem->time_lapse, $elem->exec_id, $elem->room_device_id, $elem->option_id);
echo '
<div class="col-xs-6 right smartcmd-device-name">
<i class="' . getIcon($elem->device_id) . '"></i>
' . $elem->device_name . '
</div>
<div id="smartcmdElemOption-' . $elem->exec_id . '" class="col-xs-6 left">';
echo display_option($elem);
echo '
</div>
</div>
</div>
<div id="smartcmdElemDrop-' . $elem->exec_id . '" class="col-xs-12 smartcmdElemDrop">
</div>';
}
}
echo '
</div>
<script type="text/javascript">
setElemDraggable();
function setElemDraggable() {
