Внедрение динамической таблицы в AutoBB Rev 2.3 - AutoBB

<?php
/*
 *  Функция показа списка объявлений
 */
function listMessages( $category=0 )
{
?>
	<link rel="stylesheet" href="<?php echo $mosConfig_live_site?>/components/com_autobb/style.css" />
	<link rel="stylesheet" type="text/css" href="<?php echo $mosConfig_live_site?>/components/com_autobb/css/flexigrid/flexigrid.css">
	<script type="text/javascript" src="<?php echo $mosConfig_live_site?>/components/com_autobb/lib/jquery/jquery.js"></script>
	<script type="text/javascript" src="<?php echo $mosConfig_live_site?>/components/com_autobb/flexigrid.js"></script>

	<table id="flex1" style="display:none"></table>

	<script type="text/javascript">
		$("#flex1").flexigrid(
		{
			url: '<?php echo $mosConfig_live_site?>/components/com_autobb/table2.php',
			dataType: 'json',
			colModel :
			[
				{display: 'Дата',   name : 'rfcDate', width : 30, sortable : true},
				{display: 'Фото',   name : 'photo', width : 60},
				{display: 'Марка / Модель', name : 'model', width : 120, sortable : true},
				{display: 'Объем, см<sup>3</sup>',  name : 'volume', width : 60, sortable : true},
				{display: 'КПП',    name : 'transmission', width : 20},
				{display: 'Цвет',   name : 'color', width : 30},
				{display: 'Год',    name : 'year', width : 40, sortable : true},
				{display: 'Цена',   name : 'price', width : 60, sortable : true}
			],
			sortname: "modifyDate", //сортируемый столбец по умолчанию
			sortorder: "asc", // прямая сортировка
			usepager: true, //навигация
			title: 'Продажа авто', // заголовок
			useRp: true, //для возможности вывода по 10, 15, и т.д. строк в таблице
			showTableToggleBtn: true
		});
</script>

<?php
	$meta_title = $title;
	$meta_keywords = trim( str_replace( array("\n", "\r"), array(", ", ""), $autobbConfig->seo_words ) );
	$meta_description = $title;
	$meta = new mosAutoBBmeta( $title, $meta_keywords, $meta_description, $meta_pathway );
	return $meta;
}
?>

<?php
function runSQL($rsql)
{
	$db['default']['hostname'] = "localhost";
	$db['default']['username'] = 'root';
	$db['default']['password'] = "";
	$db['default']['database'] = "jos_cars";

	$active_group = 'default';

	$connect = mysql_connect($db[$active_group]['hostname'],$db[$active_group]['username'],$db[$active_group]['password']) or die ("Error: could not connect to database");
	$db = mysql_select_db($db[$active_group]['database']);

	$result = mysql_query($rsql) or die ($rsql);
	return $result;
	mysql_close($connect);
}

function countRec($fname,$tname)
{
	$sql = "SELECT count($fname) FROM $tname ";
	$result = runSQL($sql);
	while ($row = mysql_fetch_array($result))
           {
		return $row[0];
	}
}
$page = $_POST['page'];
$rp = $_POST['rp'];
$sortname = $_POST['sortname'];
$sortorder = $_POST['sortorder'];

if (!$sortname) $sortname = 'name';
if (!$sortorder) $sortorder = 'desc';

$sort = "ORDER BY $sortname $sortorder";

if (!$page) $page = 1;
if (!$rp) $rp = 10;

$start = (($page-1) * $rp);

$limit = "LIMIT $start, $rp";

$query = $_POST['query'];
$qtype = $_POST['qtype'];

$where = " WHERE published=1";
if ($query) $where = " WHERE $qtype LIKE '%$query%' ";
$sql = "SELECT DATE_FORMAT(m.modifyDate, '%d.%m') as rfcDate,m.vendor,m.model,m.volume,m.transmission,m.color,m.year,m.price,
				v.id AS v_id, v.title AS vendor_title,
				mdls.id AS mdls_id, mdls.title AS model_title
		FROM jos_autobb_messages AS m, jos_autobb_vendors AS v, jos_autobb_models AS mdls WHERE m.vendor=v.id and m.model=mdls.id  $sort $limit";
$result = runSQL($sql);

$total = countRec("modifyDate","jos_autobb_messages AS m, jos_autobb_vendors AS v, jos_autobb_models AS mdls WHERE m.vendor=v.id and m.model=mdls.id");

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
header("Cache-Control: no-cache, must-revalidate" );
header("Pragma: no-cache" );
header("Content-type: text/x-json");
$json = "";
$json .= "{\n";
$json .= "page: $page,\n";
$json .= "total: $total,\n";
$json .= "rows: [";
$rc = false;
while ($row = mysql_fetch_array($result))
{
	if ($rc) $json .= ",";
	$json .= "\n{";
	$json .= "id:'".$row['rfcDate']."',";
	$json .= "cell:['".$row['rfcDate']."'";
	$json .= ",'".addslashes('<img src=http://cars.ru/components/com_autobb/photos/11/im_3.jpg widht=40 height=40>')."'";
	$json .= ",'".addslashes("<a href=index.php?option=com_autobb&Itemid=11&task=show&id=11>".$row['vendor_title']." ".$row['model_title']."</a>")."'";
	$json .= ",'".addslashes($row['volume'])."'";
	$json .= ",'".addslashes($row['transmission'])."'";
	$json .= ",'".addslashes($row['color'])."'";
	$json .= ",'".addslashes($row['year'])."'";
	$json .= ",'".$row['price']."']";
	$json .= "}";
	$rc = true;
}
$json .= "]\n";
$json .= "}";
echo $json;
?>

<?php
function runSQL($rsql) 
{
	$db['default']['hostname'] = "localhost";
	$db['default']['username'] = 'root';
	$db['default']['password'] = "";
	$db['default']['database'] = "jos_cars";

	$active_group = 'default';

	$connect = mysql_connect($db[$active_group]['hostname'],$db[$active_group]['username'],$db[$active_group]['password']) or die ("Error: could not connect to database");
	$db = mysql_select_db($db[$active_group]['database']);

	$result = mysql_query($rsql) or die ($rsql);
	return $result;
	mysql_close($connect);
}

function countRec($fname,$tname) 
{
	$sql = "SELECT count($fname) FROM $tname ";
	$result = runSQL($sql);
	while ($row = mysql_fetch_array($result)) {
		return $row[0];
	}
}
$page = $_POST['page'];
$rp = $_POST['rp'];
$sortname = $_POST['sortname'];
$sortorder = $_POST['sortorder'];

if (!$sortname) $sortname = 'name';
if (!$sortorder) $sortorder = 'desc';

$sort = "ORDER BY $sortname $sortorder";

if (!$page) $page = 1;
if (!$rp) $rp = 10;

$start = (($page-1) * $rp);

$limit = "LIMIT $start, $rp";

$query = $_POST['query'];
$qtype = $_POST['qtype'];

$where = " WHERE published=1";
if ($query) $where = " WHERE $qtype LIKE '%$query%' ";

$sql = "SELECT DATE_FORMAT(m.modifyDate, '%d.%m') as rfcDate,m.vendor,m.model,m.volume,m.transmission,m.color,m.year,m.price,
				v.id AS v_id, v.title AS vendor_title,
				mdls.id AS mdls_id, mdls.title AS model_title
		FROM jos_autobb_messages AS m, jos_autobb_vendors AS v, jos_autobb_models AS mdls WHERE m.vendor=v.id and m.model=mdls.id  $sort $limit";
$result = runSQL($sql);

$total = countRec("modifyDate","jos_autobb_messages AS m, jos_autobb_vendors AS v, jos_autobb_models AS mdls WHERE m.vendor=v.id and m.model=mdls.id");

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
header("Cache-Control: no-cache, must-revalidate" );
header("Pragma: no-cache" );
header("Content-type: text/xml");
$xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
$xml .= "<rows>";
$xml .= "<page>$page</page>";
$xml .= "<total>$total</total>";
while ($row = mysql_fetch_array($result)) {
	$xml .= "<row id='".$row['rfcDate']."'>";
	$xml .= "<cell><![CDATA[".$row['rfcDate']."]]></cell>";
	$xml .= "<cell><![CDATA[".utf8_encode('<img src=http://cars.ru/components/com_autobb/photos/11/im_3.jpg widht=40 height=40>')."]]></cell>";
	$xml .= "<cell><![CDATA[".utf8_encode("<a href=index.php?option=com_autobb&Itemid=11&task=show&id=11>".$row['vendor_title']." ".$row['model_title']."</a>")."]]></cell>";
	$xml .= "<cell><![CDATA[".utf8_encode($row['volume'])."]]></cell>";
	$xml .= "<cell><![CDATA[".utf8_encode($row['transmission'])."]]></cell>";
	$xml .= "<cell><![CDATA[".utf8_encode($row['color'])."]]></cell>";
	$xml .= "<cell><![CDATA[".utf8_encode($row['year'])."]]></cell>";
	$xml .= "<cell><![CDATA[".utf8_encode(row['price'])."]]></cell>";
	$xml .= "</row>";
}

$xml .= "</rows>";
echo $xml;
?>

	global  $database,

	Загрузка списка пользователей 
	$database->setQuery("SELECT * FROM #__users");
	$list = $database->loadObjectList();
 
	foreach($list as $user)
	{
 	    echo $user->name;
	}

-- 
-- Структура таблицы `#__autobb_colors`
-- 

CREATE TABLE `jos_autobb_colors` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `cod_color` varchar(6) default NULL,
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=36 ;

-- 
-- Дамп данных таблицы `#__autobb_colors`
-- 

INSERT INTO `jos_autobb_colors` VALUES (1, 'Бежевый', 'f5f5dc', 1);
INSERT INTO `jos_autobb_colors` VALUES (2, 'Бежевый металлик', 'f5f5dc', 9);
INSERT INTO `jos_autobb_colors` VALUES (3, 'Белый', 'ffffff', 10);
INSERT INTO `jos_autobb_colors` VALUES (4, 'Белый металлик', 'ffffff', 11);
INSERT INTO `jos_autobb_colors` VALUES (5, 'Голубой', '42aaff', 12);
INSERT INTO `jos_autobb_colors` VALUES (6, 'Голубой металлик', '42aaff', 13);
INSERT INTO `jos_autobb_colors` VALUES (7, 'Желтый', 'ffff00', 14);
INSERT INTO `jos_autobb_colors` VALUES (8, 'Желтый металлик', 'ffff00', 15);
INSERT INTO `jos_autobb_colors` VALUES (9, 'Зеленый', '00ff00', 16);
INSERT INTO `jos_autobb_colors` VALUES (10, 'Зеленый металлик', '00ff00', 17);
INSERT INTO `jos_autobb_colors` VALUES (11, 'Золотой', 'ffd700', 18);
INSERT INTO `jos_autobb_colors` VALUES (12, 'Золотой металлик', 'ffd700', 19);
INSERT INTO `jos_autobb_colors` VALUES (13, 'Коричневый', '964b00', 20);
INSERT INTO `jos_autobb_colors` VALUES (14, 'Коричневый металлик', '964b00', 21);
INSERT INTO `jos_autobb_colors` VALUES (15, 'Красный', 'ff0000', 22);
INSERT INTO `jos_autobb_colors` VALUES (16, 'Красный металлик', 'ff0000', 23);
INSERT INTO `jos_autobb_colors` VALUES (17, 'Оранжевый', 'ffa500', 24);
INSERT INTO `jos_autobb_colors` VALUES (18, 'Оранжевый металлик', 'ffa500', 25);
INSERT INTO `jos_autobb_colors` VALUES (19, 'Пурпурный', 'ff00ff', 26);
INSERT INTO `jos_autobb_colors` VALUES (20, 'Пурпурный металлик', 'ff00ff', 27);
INSERT INTO `jos_autobb_colors` VALUES (21, 'Серебристый', 'c0c0c0', 28);
INSERT INTO `jos_autobb_colors` VALUES (22, 'Серебристый металлик', 'c0c0c0', 29);
INSERT INTO `jos_autobb_colors` VALUES (23, 'Серый', '808080', 30);
INSERT INTO `jos_autobb_colors` VALUES (24, 'Серый металлик', '808080', 31);
INSERT INTO `jos_autobb_colors` VALUES (25, 'Синий', '0000ff', 32);
INSERT INTO `jos_autobb_colors` VALUES (26, 'Синий металлик', '0000ff', 33);
INSERT INTO `jos_autobb_colors` VALUES (27, 'Фиолетовый', '8b00ff', 34);
INSERT INTO `jos_autobb_colors` VALUES (28, 'Фиолетовый металлик', '8b00ff', 35);
INSERT INTO `jos_autobb_colors` VALUES (29, 'Черный', '000000', 36);
INSERT INTO `jos_autobb_colors` VALUES (30, 'Черный металлик', '000000', 37);
INSERT INTO `jos_autobb_colors` VALUES (31, 'Оливковый', '808000', 8);
INSERT INTO `jos_autobb_colors` VALUES (32, 'Оливковый металлик', '808000', 7);
INSERT INTO `jos_autobb_colors` VALUES (33, 'Бордовый', '9b2d30', 6);
INSERT INTO `jos_autobb_colors` VALUES (34, 'Светло-зеленый', '00ff00', 5);
INSERT INTO `jos_autobb_colors` VALUES (35, 'Темно-синий', '000080', 4);

	$query = "SELECT a.*, a.mileage*(1 + a.mileage_unit*0.609) as metric_mileage, a.mileage*(1 - (1 - a.mileage_unit)*0.3785) as english_mileage,"
	."\n p.id as photo_id, count(p.id) as photo_count, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, c.title as colortitle,"
	."\n cur.sign as currency_sign, a.price*cur.rate as price_in_rur, DATE_FORMAT(a.modifyDate, '%a, %d %b %Y %T GMT') as rfcDate";

	$query = "SELECT a.*, a.mileage*(1 + a.mileage_unit*0.609) as metric_mileage, a.mileage*(1 - (1 - a.mileage_unit)*0.3785) as english_mileage,"
	."\n p.id as photo_id, count(p.id) as photo_count, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, c.title as colortitle, c.cod_color as cod_color,"
	."\n cur.sign as currency_sign, a.price*cur.rate as price_in_rur, DATE_FORMAT(a.modifyDate, '%a, %d %b %Y %T GMT') as rfcDate";

	<?php if( $autobbConfig->show_color ) { ?>
	<td class="color"><?php echo $row->colortitle;?></td>
	<?php } ?>

	<?php if( $autobbConfig->show_color ) { ?>
	<td class="color">
		<div style="border: 1px solid #595959; background-color: #<?php echo $row->cod_color;?>; height: 0.5em; width: 0.9em;" title="<?php echo $row->colortitle;?>"></div></td>
	<?php } ?>

$lists['colors'] = mosHTML::selectList( $colors, 'color', 'class="inputbox" size="1"', 'value', 'text', intval( $row->color ) );

<?php echo $row->cod_color;?>

<script type="text/javascript">
		$("#flex1").flexigrid(
		{
			url: '<?php echo $mosConfig_live_site?>[b]/components/com_autobb/table2.php[/b]',
			dataType: 'json',
			colModel :

<link rel="stylesheet" href="<?php echo $mosConfig_live_site?>[b]/components/com_autobb/style.css[/b]" />

$status = array( "", "<span style='color:green;font-weight:bold;'>в наличии</span>",
		 "<span style='color:orange;font-weight:bold;'>в пути</span>",
		 "<span style='color:red;font-weight:bold;'>под заказ</span>");

			if( $row->en > 0 )
			{
				if(!$td_num)
				{
					echo '<tr class="sectiontableentry'.$tr_num.'">';
				}
?>
				<td width="25%">Статус:</td>
				<td class="value" width="25%"><?php echo $status[$row->en];?></td>
<?php
				if($td_num)
				{
					echo '</tr>';
					$tr_num = 3 - $tr_num;
				}
				$td_num = 1 - $td_num;
			}

function showColors() {
	global $database, $mainframe, $mosConfig_list_limit, $mosConfig_absolute_path, $autobbConfig;
	require_once( $mosConfig_absolute_path.'/administrator/includes/pageNavigation.php' );

	$limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
	$limitstart = $mainframe->getUserStateFromRequest( "view{com_autobb}{colors}limitstart", 'limitstart', 0 );

	$query = "SELECT count(*)"
	."\n FROM #__autobb_colors"
	;
	$database->setQuery( $query );
	$total = $database->loadResult();
	$pageNav = new mosPageNav( $total, $limitstart, $limit );
	
	$query = 	"SELECT *"
	."\n FROM #__autobb_colors"
	. ($autobbConfig->color_sort ? "\n ORDER BY ordering" : "\n ORDER BY title" )
	."\n LIMIT ". $pageNav->limitstart .", ".$pageNav->limit 
	;
	$database->setQuery( $query );
	$rows = $database->loadObjectList();
langSelect ($autobbConfig);
	HTML_autobb::showColors( $rows, $pageNav);
}

function editColor($cid) {
	global $database;

	$lists = array();
	$row = new mosAutoBBColor($database);
	$row->load($cid);
	
	$database->setQuery("SELECT ordering AS value, concat(ordering,'::',title) AS text FROM #__autobb_colors ORDER BY ordering");
	$orders = $database->loadObjectList();
	$lists['ordering'] = mosHTML::selectList( $orders, 'ordering', 'class="inputbox" size="1"', 'value', 'text', $row->ordering );
	langSelect (0);
	HTML_autobb::editColor( $row, $lists);
}

function saveColor($cid) {
	global $database, $task;

	$row = new mosAutoBBColor($database);
	if (!$row->bind( $_POST )) {
		echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
		exit();
	}
	if (!$row->store()) {
		echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
		exit();
	}
	$row->checkin();
	$row->updateOrder( );
	langSelect (0);
	if( $task == 'save' ) mosRedirect( 'index2.php?option=com_autobb&act=colors', _AUTOBB_COMMON_SAVED );
	else mosRedirect( 'index2.php?option=com_autobb&act=colors&amp;task=edit&amp;hidemainmenu=1&amp;cid[]='.$row->id, _AUTOBB_COMMON_SAVED );
}

function deleteColors($cid) {
	global $database;
	
	$cids = implode( ',', $cid );

	$query = "DELETE FROM #__autobb_colors"
	."\n WHERE id IN ($cids)"
	;
	$database->setQuery( $query );
	if (!$database->query()) {
		echo "<script> alert('".$database->stderr()."');</script>\n";
		exit();
	}
	langSelect (0);
	mosRedirect( 'index2.php?option=com_autobb&act=colors', _AUTOBB_COMMON_REMOVED );
}

function orderColor($cid, $inc ) {
	global $database;

	$row = new mosAutoBBColor( $database );
	$row->load( $cid );

	$row->move( $inc );
	$row->updateOrder( );
	langSelect (0);
	mosRedirect( 'index2.php?option=com_autobb&act=colors', _AUTOBB_COMMON_ORDER_CHANGED );
}