/modules/catalog/edit.materials.php
PHP | 338 lines | 308 code | 30 blank | 0 comment | 32 complexity | 8f64639f62d1f52ad59243f51bea7ef6 MD5 | raw file
- <? include "../../inc/header_m.php";?>
- <?
- if (!empty($parent_home))
- $home_parent=" and parentid='$parent_home' ";
- mysql_query("delete from {$pref}db_{$modul}_cat where status=-1 and parentid='$parent_home' ");
- if (isset($_GET['id_material'])||isset($_POST['id_material']))
- {
- if (count($_POST)>0)
- {
- $id=$_POST['id_material'];
- if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$id} $home_parent limit 1"))==0) {die();}
- $pid=$_POST['pid'];
- if (!empty($parent_home))
- mysql_query("delete from {$pref}db_{$modul}_rel where id_el={$id} and id_cat in (select id from {$pref}db_{$modul}_cat where parentid=$parent_home)");
- else
- mysql_query("delete from {$pref}db_{$modul}_rel where id_el={$id}");
- foreach ($pid as $key => $value) {
- if (!empty($value)){
- if (!empty($parent_home)){
- if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul}_cat where id=$value and parentid=$parent_home"))>0)
- mysql_query("insert into {$pref}db_{$modul}_rel set id_cat={$value},id_el={$id}");
- }
- else
- mysql_query("insert into {$pref}db_{$modul}_rel set id_cat={$value},id_el={$id}");
- }
- }
- $alias=$_POST['alias'];
- if (empty($alias))
- $alias=$id;
- mysql_query("delete from {$pref}db_structure_alias where id_type=$id_modules and id_el={$id}");
- foreach ($pid as $key => $value) {
- if (!empty($value)){
- $sql="select * from {$pref}db_structure where catalog=$value";
- $query=mysql_query($sql);
- if ($query && mysql_num_rows($query)>0)
- while ($res=mysql_fetch_array($query)) {
- if (intval(mysql_num_rows(mysql_query("select * from {$pref}db_structure_alias where href='{$res['href']}/{$alias}'")))>0)
- $mes_er="<font><b class='saveinfo'>Ошибка создания алиаса</b></font>";
- else
- mysql_query("insert into {$pref}db_structure_alias set href='{$res['href']}/{$alias}',id_page='{$res['id']}',id_type={$id_modules},id_el={$id}");
- }
- }
- }
- $price=$_POST['price'];
- $price2=$_POST['price2'];
- $discount=$_POST['discount'];
- $img=$_POST['img'];
- $title=$_POST['title'];
- $description=$_POST['description'];
- $keyword=$_POST['keyword'];
- $name=$_POST['name'];
- $anons=$_POST['anons'];
- $article=$_POST['article'];
- $text=addslashes($_POST['text']);
- $status=$_POST['status'];
- $video=$_POST['video'];
- $date1=date2sql($_POST['date1']);
- $date2=date2sql($_POST['date2']);
- $var1=$_POST['var1'];
- $var2=$_POST['var2'];
- $var3=$_POST['var3'];
- $var4=$_POST['var4'];
- $text1=$_POST['text1'];
- $file = $_FILES['file']['tmp_name'];
- if ((isset($file)) && ($file !="")) {
- if ($_FILES['file']['type'] == "image/pjpeg") {$img = "gal".$id."_b.jpg";}
- if ($_FILES['file']['type'] == "image/jpeg") {$img = "gal".$id."_b.jpg"; }
- if ($_FILES['file']['type'] == "image/gif") {$img = "gal".$id."_b.gif"; }
- move_uploaded_file ($file, $_SERVER['DOCUMENT_ROOT']."/files/images/".$img); @chmod ($_SERVER['DOCUMENT_ROOT']."/files/images/".$img, 0777);
- }
- if (isset($_POST['delf'])) $img="";
- $mes="<font color='green'><b class='saveinfo'>Сохранено</b></font>";
- mysql_query("update {$pref}db_{$modul} set price='{$price}',price2='{$price2}',discount='{$discount}',title='{$title}',alias='{$alias}',description='{$description}',keyword='{$keyword}',name='{$name}',anons='{$anons}',article='{$article}',text='{$text}',video='{$video}',date1='{$date1}',date2='{$date2}',var1='{$var1}',var2='{$var2}',var3='{$var3}',var4='{$var4}',text1='{$text1}',status='{$status}' where id='{$id}' $home_parent");
- if (isset($_POST['sf1'])) header("Location: index.php");
- }
- else
- {
- unset($mes);
- $id=$_GET['id_material'];
- }
- $query=mysql_query("select * from {$pref}db_{$modul} where id={$id} $home_parent limit 1");
- $res=mysql_fetch_array($query);
-
- $m_title="Изменить элемент";
- }
-
-
-
- else
- {
- mysql_query("insert into {$pref}db_{$modul} set sort=0,date1=NOW(),date2=NOW(), user='{$_SESSION['user_id']}',parentid='$parent_home'");
- $id=mysql_insert_id();
- $query=mysql_query("select * from {$pref}db_{$modul} where id={$id} $home_parent limit 1");
- $res=mysql_fetch_array($query);
-
- $m_title="Добавить элемент";
- }
- $body1="";
- $timestamp = time();
- $body1.="
- <fieldset class='left'>
- <label>Уменьшить размер</label>
- <input type='checkbox' class='' id='editsize2' value='' />
- <input type='hidden' class='' id='editsize' value='0' />
- <div class='clear'></div>
- <form>
- <input id='file_upload' name='file_upload' type='file' multiple='true'>
- </form>
- </fieldset>
- <script type='text/javascript'>
- $(function() {
- $('#file_upload').uploadify({
- 'fileTypeExts' : '*.jpg; *.jpeg; *.gif; *.png',
- 'formData' : {
- 'editsize' : ''+$('#editsize').val()+'',
- 'folder' : '/files/images',
- 'id_type' : '{$id_modules}',
- 'id_el' : '{$id}',
- 'timestamp' : '{$timestamp}',
- 'token' : '".md5('unique_salt' . $timestamp)."'
- },
- 'swf' : '".$pt.$cmspatch."/templates/uploadify/uploadify.swf',
- 'uploader' : '".$pt.$cmspatch."/templates/uploadify/uploadify.php',
- 'uploadLimit' : 50,
- 'onUploadSuccess' : function(file, data, response) {
- $('.picmodules').append(data);
- }
- });
- });
- $(document).ready(function(){
- $('#editsize2').change(function(){
- if ($(this).attr('checked')=='checked') $(this).next().val('1'); else $(this).next().val('0');
- $(function() {
- $('#file_upload').uploadify({
- 'formData' : {
- 'editsize' : ''+$('#editsize').val()+'',
- 'folder' : '/files/images',
- 'id_type' : '{$id_modules}',
- 'id_el' : '{$id}',
- 'timestamp' : '{$timestamp}',
- 'token' : '".md5('unique_salt' . $timestamp)."'
- },
- 'swf' : '".$pt.$cmspatch."/templates/uploadify/uploadify.swf',
- 'uploader' : '".$pt.$cmspatch."/templates/uploadify/uploadify.php',
- 'uploadLimit' : 50,
- 'onUploadSuccess' : function(file, data, response) {
- $('.picmodules').append(data);
- }
- });
- });
- });
- });
- </script>
- ";
- $body1.=get_all_pic_modules($id_modules,$id);
- ?>
- <form action='' class='userInform' method='post' enctype='multipart/form-data'>
- <? if (count($_POST)>0){?><h4 class="alert_success"><?=$mes?></h4><?}?>
- <? if (count($_POST)>0 && !empty($mes_er)){?><h4 class="alert_error"><?=$mes_er?></h4><?}?>
- <article class="module width_full">
- <header><h3 class="tabs_involved"><?=$m_title?></h3>
- <ul class="tabs">
- <li><a href="#tab1">Контент</a></li>
- <li><a href="#tab2">Дополнительно</a></li>
- <? if ($res['status']>0){?>
- <li><a href="#tab3">Изображения</a></li>
- <?}?>
- </ul>
- </header>
- <div class="module_content">
- <div id="tab1" class="tab_content">
- <fieldset>
- <label>Название*</label>
- <input type='text' class='validate[required]' name='name' id='name' value='<?=$res['name']?>' />
- </fieldset>
- <fieldset class='left'>
- <label>Алиас</label>
- <input type='text' name='alias' id='alias' value='<?=$res['alias']?>' />
- </fieldset>
- <fieldset class='right'>
- <label>Артикул</label>
- <input type='text' class='' name='article' id='article' value='<?=$res['article']?>' />
- </fieldset><div class='clear'></div>
- <fieldset>
- <label>Анонс</label>
- <textarea name='anons' rows="5" id='anons'><?=$res['anons']?></textarea><br>
- </fieldset>
- <fieldset>
- <label>Текст</label>
- <textarea name='text' id='elm1'><?=$res['text']?></textarea><br>
- </fieldset>
- <fieldset>
- <label>Заголовок</label>
- <textarea name='title' rows="5" id='title'><?=$res['title']?></textarea><br>
- </fieldset>
- <fieldset>
- <label>Описание</label>
- <textarea name='description' rows="5" id='description'><?=$res['description']?></textarea><br>
- </fieldset>
- <fieldset>
- <label>Ключевые слова</label>
- <textarea name='keyword' rows="5" id='keyword'><?=$res['keyword']?></textarea><br>
- </fieldset>
- <fieldset>
- <label>Цена</label>
- <input type="text" name="price" value="<?=$res['price']?>">
- </fieldset>
- <fieldset class='left'>
- <label>Старя цена</label>
- <input type="text" name="price2" value="<?=$res['price2']?>">
- </fieldset>
- <fieldset class='right'>
- <label>Скидка (%)</label>
- <input type="text" name="discount" value="<?=$res['discount']?>">
- </fieldset><div class='clear'></div>
- <fieldset class='left'>
- <label>Дата создания</label>
- <input type='text' name='date1' id='date1' value='<?=sql2date($res['date1'])?>'> <button type='reset' id='f_trigger_b1'>...</button><br>
- <script type='text/javascript'>
- Calendar.setup({
- inputField : 'date1',
- ifFormat : '%d.%m.%Y %H:%M',
- showsTime : true,
- button : 'f_trigger_b1',
- singleClick : false,
- step : 1
- });
- </script>
- </fieldset>
- <fieldset class='right'>
- <label>Дата изменения</label>
- <input type='text' name='date2' id='date2' value='<?=sql2date($res['date2'])?>'> <button type='reset' id='f_trigger_b2'>...</button><br>
- <script type='text/javascript'>
- Calendar.setup({
- inputField : 'date2',
- ifFormat : '%d.%m.%Y %H:%M',
- showsTime : true,
- button : 'f_trigger_b2',
- singleClick : false,
- step : 1
- });
- </script>
- </fieldset><div class='clear'></div>
- <fieldset class='left'>
- <label>Добавить в</label><br><br>
- <ul class="catdeleteinsert">
- <?
- if (!empty($parent_home))
- $sql1="select * from {$pref}db_{$modul}_rel where id_el='{$res['id']}' and id_cat in (select id from {$pref}db_{$modul}_cat where parentid=$parent_home) order by id";
- else
- $sql1="select * from {$pref}db_{$modul}_rel where id_el='{$res['id']}' order by id";
- $query1=mysql_query($sql1);
- $num=0;
- while ($res1=mysql_fetch_array($query1)) {
- $num++;
- ?>
- <li class="catdelete"><div style="background: url(<?=$pt?>/<?=$cmspatch?>/templates/img/drop.png) 10px 0px no-repeat;"><input type="hidden" name="pid[]" id='pid' value="<?=$res1['id_cat']?>"><label><?=getdb("db_{$modul}_cat",$res1['id_cat'],'name')?></label> <img class="deletecategorie" src="<?=$pt?>/<?=$cmspatch?>/templates/img/del_cat.png"></div></li>
- <?
- }
- ?>
- </ul>
- <select class='addcategorie' name='pid[]' id='pid1' ><option value=''>--</option>
- <?tree2(0,1,0,$modul.'_cat','name');?>
- </select>
- </fieldset>
- <fieldset class='right'>
- <label>Статус*</label>
- <select class='validate[required]' name='status' id='status' >
- <option value='1' <?if ($res['status']==1) echo "selected";?> >Опубликовано</option>
- <option value='2' <?if ($res['status']==2) echo "selected";?> >Не опубликованно</option>
- </select></fieldset><div class='clear'></div>
- <input type='hidden' value='<?=$id?>' name='id_material' />
- Поля, отмеченные * являются обязательными для заполнения
- </div>
- <div id="tab2" class="tab_content">
- <fieldset>
- <label>Видео</label>
- <textarea name='video'><?=$res['video']?></textarea><br>
- </fieldset>
- <fieldset class="left">
- <label>Дополнительное поле 1</label>
- <input type="text" name='var1' value="<?=$res['var1']?>" /><br>
- </fieldset>
- <fieldset class="right">
- <label>Дополнительное поле 2</label>
- <input type="text" name='var2' value="<?=$res['var2']?>" /><br>
- </fieldset><div class='clear'></div>
- <fieldset class="left">
- <label>Дополнительное поле 3</label>
- <input type="text" name='var3' value="<?=$res['var3']?>" /><br>
- </fieldset>
- <fieldset class="right">
- <label>Дополнительное поле 4</label>
- <input type="text" name='var4' value="<?=$res['var4']?>" /><br>
- </fieldset><div class='clear'></div>
- <fieldset>
- <label>Дополнительное поле 5</label>
- <textarea name='text1'><?=$res['text1']?></textarea><br>
- </fieldset>
- </div>
- <div id="tab3" class="tab_content">
- <?=$body1?>
- </div>
- </div>
- <footer>
- <div class="submit_link">
- <input type='submit' value='Сохранить' name='sf' />
- <input type='submit' value='Сохранить и закрыть' name='sf1' />
- </div>
- </footer>
- </article>
- </form>
- <? include "../../inc/footer_m.php"; ?>