<?php
if(($opt1) && ($opt1 === 'add' || $opt1 === 'edit')):
	if(($opt1 === 'edit' && $opt2)):
		$stmt = $mysqli->prepare("SELECT $firstcol, category, content, alignment, status, catsortnumber, sortnumber FROM $table WHERE $firstcol = ? LIMIT 1") or die($mysqli->error);
		$stmt->bind_param('i', $opt2);
		$stmt->execute();
		$stmt->store_result();
		$count_rows = $stmt->num_rows();
		$stmt->bind_result($id, $category, $content, $alignment, $status, $catsortnumber, $sortnumber);
		$stmt->fetch();
		$stmt->close();
		if($count_rows !== 1):
			die('Invalid data selection.');
		endif;
	else:
		$id = '';$category = '';$content = '';$alignment = 'T';$status = 'enabled';$catsortnumber = '';$sortnumber = '';
	endif;
	$status = ($status == 'enabled') ? 'checked' : NULL;
	function category_list(){
		global $mysqli, $table;
		$list = '';
		$stmt = $mysqli->prepare("SELECT category FROM $table GROUP BY category ORDER BY category ASC") or die($mysqli->error);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($category);
			while($stmt->fetch()):
				$list .= ($category) ? '<option>' . $category . '</option>' : NULL;
			endwhile;
			$stmt->close();
		endif;
		return $list;
	}
	$category_list = category_list();
echo <<<EOJ
	<input type="hidden" name="dataid" value="{$id}" readonly="readonly" />
	<div class="head">
		{$back}
		<input type="reset" value="reset" class="action" />
		<input type="submit" value="submit" class="action b button" />
		<input type="button" value="upload file" class="action" onclick="compose('.upf')" style="float:right;margin:0px" />
	</div>
	<div class="body">
		<div class="row">
			<div class="fl">
				<label class="flbl">Category :<span class="fr">*</span></label>
				<input type="text" list="category" name="category" value="{$category}" class="field" />
				<datalist id="category">{$category_list}</datalist>
			</div>
			<div class="fr">
				<div class="rw">
					<label><input type="checkbox" name="status" value="enabled" {$status} />status</label>
				</div>
				<div class="rw">
				<label>alignment</label>
EOJ;
?>
				<label><input type="radio" name="align" value="T" <?php if($alignment == 'T'){echo 'checked="checked"';} ?> />top</label>
				<label><input type="radio" name="align" value="L" <?php if($alignment == 'L'){echo 'checked="checked"';} ?> />left</label>
				<label><input type="radio" name="align" value="R" <?php if($alignment == 'R'){echo 'checked="checked"';} ?> />right</label>
<?php
echo <<<EOJ
				</div>
			</div>
		</div>
		<div class="row">
			<label class="flbl">Content :<span class="fr">*</span></label>
			<div class="fluid">
               	<textarea rows="5" cols="5" name="content" id="editor" class="field">{$content}</textarea>
			</div>
		</div>
		<div class="row">
			<div class="fl">
				<label class="flbl">Category Sort Number :</label>
				<input type="text" name="catsort" value="{$catsortnumber}" class="field digit" onpaste="return false;" />
			</div>
			<div class="fr">
				<label class="flbl">Sort Number :</label>
				<input type="text" name="sort" value="{$sortnumber}" class="field digit" onpaste="return false;" />
			</div>
		</div>
	</div>
EOJ;
else:
	$stmt = $mysqli->prepare("SELECT * FROM $table") or die($mysqli->error);
	$stmt->execute();
	$stmt->store_result();
	$total_rows = $stmt->num_rows();
	$stmt->close();
echo <<<EOJ
	<div class="head">
		<input type="button" value="create new" class="action g" onclick="gourl('add')" />
		<input type="submit" value="" class="action ico delete hidden" onclick="setopt(this, 'delete', 'Do you really want to delete?')" />
		<input type="submit" value="enable all" class="action" onclick="setopt(this, 'enableall')" />
		<input type="submit" value="disable all" class="action" onclick="setopt(this, 'disableall')" />
		<div class="fr"><b>Total Rows : {$total_rows}</b></div>
	</div>
	<table border="0" cellpadding="0" cellspacing="0" class="table">
		<thead>
		<tr>
		<th align="center" valign="middle" class="xs"><input type="checkbox" name="select_all" id="select_all" value="" /></th>
		<th align="center" valign="middle" class="xs">s. no.</th>
		<th align="left" valign="middle">category</th>
		<th align="left" valign="middle">content</th>
		<th align="center" valign="middle" class="xs">align</th>
		<th align="center" valign="middle" class="sm">status</th>
		<th align="center" valign="middle" style="width:100px">c. sort number</th>
		<th align="center" valign="middle" style="width:100px">sort number</th>
		<th align="right" valign="middle" class="md">creation</th>
		<th align="center" valign="middle" class="sm">action</th>
		</tr>
EOJ;
		$stmt = $mysqli->prepare("SELECT $firstcol, category, content, alignment, status, catsortnumber, sortnumber, creation FROM $table ORDER BY category ASC, catsortnumber ASC, sortnumber ASC") or die($mysqli->error);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($id, $category, $content, $alignment, $status, $catsortnumber, $sortnumber, $creation);
			while($stmt->fetch()):
				$snum = ($page_number == 1) ? $snum + 1 : $page_position++ + 1;
				$content = html_entity_decode($content);
				$stat = ($status == 'enabled') ? 'disabled' : 'enabled';
				$creation = dateformat($creation);
echo <<<EOJ
				<tr>
				<td align="center" valign="middle"><input type="checkbox" name="dataid[]" value="{$id}" class="checkbox" /></td>
				<td align="center" valign="middle">{$snum}</td>
				<td align="left" valign="middle">{$category}</td>
				<td align="left" valign="middle">{$content}</td>
				<td align="center" valign="middle">{$alignment}</td>
				<td align="center" valign="middle"><button type="button" class="{$status}" onclick="dopost('{$stat}', '{$id}')">{$status}</button></td>
				<td align="center" valign="middle">{$catsortnumber}</td>
				<td align="center" valign="middle">{$sortnumber}</td>
				<td align="right" valign="middle">{$creation}</td>
				<td align="center" valign="middle"><button type="button" onclick="gourl('edit/{$id}')">edit</button></td>
				</tr>
EOJ;
			endwhile;
			$stmt->close();
		else:
			echo '<tr><td align="center" valign="middle" colspan="10">' . $emptyrows . '</td></tr>';
		endif;
	echo '</tbody>';
	echo '</table>';
endif;
?>