Список товаров

"; //Generate main list of software if (($_GET['pt']=="" and $_GET['vs']=="" and GET_RIGHTS("ADD_PRODUCT")!=1) or (empty($_GET['pt']) and empty($_GET['vs']) and empty($_POST['editlist']) and $dopusk>60)) { $stmt = oci_parse($db_conn, "SELECT pt.idpt, pt.NAME pname, pt.name_long FROM ".$GLOBALS["curusr"].".product pt where en=1 ORDER by pt.NAME"); oci_execute($stmt); $nrows = oci_fetch_all($stmt, $results); if ($nrows > 0) { echo"

"; for ($i = 0; $i < $nrows; $i++) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo "

	".$results["PNAME"][$i]."	".$results["NAME_LONG"][$i]."	Подробнее

"; if (GET_RIGHTS("ADD_PRODUCT")==1) { echo" \n"; echo "

"; } else {echo "";} } } //Generate main list of software for admin if ($_GET['pt']=="" and $_GET['vs']=="" and GET_RIGHTS("ADD_PRODUCT")==1 and isset($_POST['editlist'])) { $stmt = oci_parse($db_conn, "SELECT pt.idsa, pt.idpt, pt.NAME pname, pt.name_long FROM ".$GLOBALS["curusr"].".product pt ORDER by pt.idpt"); oci_execute($stmt); $nrows = oci_fetch_all($stmt, $results); //MAKE IDSA LIST $sql1="SELECT idsa, NAME as name FROM ".$GLOBALS["curusr"].".soft_autors order by idsa"; // $sql1 = "select pr.idsa, sa.name as name from ".$GLOBALS["curusr"].".soft_autors sa, ".$GLOBALS["curusr"].".product pr (where sa.idsa = pr.idsa) order by idsa" ; $parsed1 = ociparse($db_conn,$sql1); ociexecute($parsed1); $ndis= ocifetchstatement($parsed1,$mdis); //Форма добавления товаров echo "

"; echo ""; echo" \n"; echo "

"; $oFCKeditor = new FCKeditor('PRNAME_LONG') ; $oFCKeditor->BasePath = '/modules/fckeditor/' ; $oFCKeditor->Value = "Тут должно быть краткое описание продукта - мини обзор" ; $oFCKeditor->Create() ; echo "

\n"; echo ""; $oFCKeditor = new FCKeditor('DESCRIPTION1') ; $oFCKeditor->BasePath = '/modules/fckeditor/' ; $oFCKeditor->Value = "Тут должно быть подробное описание продукта, с картинками и т.п. Ќастолько подробно, что дальше некуда!" ; $oFCKeditor->Create() ; echo "\n"; echo ""; echo "\n"; //echo ""; echo "

	Љраткое название	автор
"; echo "	\n"; echo "		\n"; echo "

\n"; //DRAW EDIT FORM if ($nrows > 0) { echo" "; for ($i = 0; $i < $nrows; $i++) { echo "\n"; echo ""; echo "\n"; echo "\n"; } echo "

\n"; echo "

\n"; // echo "

\n"; echo "

"; // echo ""; if (GET_RIGHTS("EDIT_PRODUCT")==1) { echo ""; } else {echo " ";} echo "

Подробнее о продукте

"; } } //Создаем страничку с описанием товара и списком версий if ((isset($_GET['pt']) and GET_RIGHTS("EDIT_PRODUCT")!=1) or (isset($_GET['pt']) and empty($_POST['editpt']) and GET_RIGHTS("EDIT_PRODUCT")==1)) { $prod_number=$_GET['pt']; $stmt = oci_parse($db_conn, "SELECT pt.idpt, vers.idvs as vs, pt.NAME pname, pt.name_long, vers.name, vers.memo FROM ".$GLOBALS["curusr"].".product pt, ".$GLOBALS["curusr"].".product_ver vers WHERE ((pt.idpt = vers.idpt and pt.idpt = :product) and (vers.data_begin <= sysdate and vers.data_end >= sysdate)) ORDER by pt.NAME"); OCIBindByName($stmt, ":product", $prod_number); oci_execute($stmt); $nrows = oci_fetch_all($stmt, $results); //выгрузим блобы с описанием товара $blb = oci_parse($db_conn, "SELECT pt.description FROM ".$GLOBALS["curusr"].".product pt, ".$GLOBALS["curusr"].".product_ver vers WHERE (pt.idpt = vers.idpt and pt.idpt = :product) ORDER by vers.idvs"); OCIBindByName($blb, ":product", $prod_number); oci_execute($blb); $row = oci_fetch_array($blb, OCI_ASSOC+OCI_RETURN_LOBS); $desc=$row['DESCRIPTION']; if ($nrows > 0) { echo ""; echo ""; echo "\n"; echo "\n"; echo "\n"; // echo ""; echo ""; echo "

".$results["PNAME"]['0']."

".$results["NAME_LONG"]['0']."

‚ерсии

"; for ($i = 0; $i < $nrows; $i++) { echo "\n"; echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; echo "\n"; echo "\n"; //if ($dopusk > 3) { ////} //elseif ($dopusk < 4) { // echo "\n"; //} echo "\n"; } echo "

".$results["NAME"][$i]."

".$results["IDPT"][$i]."

".$results["PNAME"][$i]."

".$results["NAME_LONG"][$i]."

".$results["MEMO"][$i]."

активируйте карту

$\"‚$

Зарегистрируйтесь для активации карты

"; echo ""; echo "

"; if (GET_RIGHTS("EDIT_PRODUCT")==1) { echo "

"; } else {echo "

";} echo "".$desc."

"; } } //Generate list of versions based on IPDT for admin if (isset($_GET['pt']) and GET_RIGHTS("EDIT_PRODUCT")==1 and isset($_POST['editpt'])) { //получим текущую дату $data1 = oci_parse($db_conn, "SELECT to_date(sysdate) as date1 from dual "); oci_execute($data1); ocifetch($data1); $today=ociresult($data1,1); //получим дату через 3 года $data2 = oci_parse($db_conn, "SELECT to_date(sysdate+1095) as date2 from dual "); oci_execute($data2); ocifetch($data2); $future=ociresult($data2,1); //получим количество версий + 1 длЯ определенного продукта $qty = oci_parse($db_conn, "SELECT (count(vers.idvs)+1) from ".$GLOBALS["curusr"].".product_ver vers where vers.idpt = :productid "); OCIBindByName($qty,":productid",$_GET['pt']); oci_execute($qty); ocifetch($qty); $quantity=ociresult($qty,1); //основнаЯ часть $prod_number=$_GET['pt']; $stmt = oci_parse($db_conn, "SELECT vers.idpt as prodid,vers.idvs as vs, vers.name ,vers.data_begin as begin, vers.data_end as end, pt.NAME pname, pt.name_long, vers.memo FROM ".$GLOBALS["curusr"].".product pt, ".$GLOBALS["curusr"].".product_ver vers WHERE (pt.idpt = vers.idpt and pt.idpt = :product) ORDER by vers.idvs"); OCIBindByName($stmt, ":product", $prod_number); oci_execute($stmt); $nrows = oci_fetch_all($stmt, $results); //выгрузим блобы с описанием товара $blb = oci_parse($db_conn, "SELECT pt.description FROM ".$GLOBALS["curusr"].".product pt, ".$GLOBALS["curusr"].".product_ver vers WHERE (pt.idpt = vers.idpt and pt.idpt = :product) ORDER by vers.idvs"); OCIBindByName($blb, ":product", $prod_number); oci_execute($blb); $row = oci_fetch_array($blb, OCI_ASSOC+OCI_RETURN_LOBS); $desc=$row['DESCRIPTION']; //Форма добавления версий товаров echo "

"; echo ""; echo" \n"; if (GET_RIGHTS("ADD_VERSION")==1) { echo "

"; $oFCKeditor = new FCKeditor('MEMO1') ; $oFCKeditor->BasePath = '/modules/fckeditor/' ; $oFCKeditor->Value = "Тут должно быть описание версии (подтипа) продукта" ; $oFCKeditor->Create() ; //

\n"; echo ""; echo "\n"; echo ""; } else { echo "";} echo "

	ID продукта	ID версии	Название версии	Начать показ с	Закончить показ с
"; echo "	\n"; echo "	\n"; echo "	\n"; echo "	\n"; echo "

"; echo ""; echo "

"; $oFCKeditor = new FCKeditor('DESCRIPTIONPT') ; $oFCKeditor->BasePath = '/modules/fckeditor/' ; $oFCKeditor->Value = "$desc" ; $oFCKeditor->Create() ; //

\n"; echo "\n"; //список товаров if ($nrows > 0) { echo" "; echo ""; for ($i = 0; $i < $nrows; $i++) { echo ""; echo "\n"; echo ""; echo "\n"; // echo "\n"; //if ($dopusk > 3) { ////} //elseif ($dopusk < 4) { // echo "\n"; //} echo "\n"; } echo "

	Название продукта	ID продукта	ID версии	Название версии	Краткое писание	Начать показ с	Закончить показ с	Редактор
\n"; echo "	".$results["PNAME"][$i]."	\n"; echo "	\n"; echo "	\n"; echo "	\n"; echo "	\n"; echo "	\n"; echo "	"; echo ""; // echo ""; echo ""; echo "	Подробнее от продукте	Зарегистрируйтесь для активации карты

"; } } echo niz_menu($GLOBALS["niz_menu_left"],$GLOBALS["niz_menu_right"]); ?>