edit.materials.php | searchcode

/modules/materials/edit.materials.php

https://bitbucket.org/ssimpledecision/simpledecision
PHP | 296 lines | 264 code | 32 blank | 0 comment | 33 complexity | 251f9e0c5d1ea4d6f80432f3d8ea4303 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 materials=$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'];
		$discount=$_POST['discount'];
		$img=$_POST['img'];
		$name=$_POST['name'];
		$typ=$_POST['typ'];
		$title=$_POST['title'];
		$description=$_POST['description'];
		$keyword=$_POST['keyword'];
		$anons=$_POST['anons'];
		$date1=date2sql($_POST['date1']);
		$date2=date2sql($_POST['date2']);
		$text=addslashes($_POST['text']);
		$status=$_POST['status'];
		$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 name='{$name}',`type`='{$typ}',alias='{$alias}',title='{$title}',description='{$description}',keyword='{$keyword}',
				anons='{$anons}',text='{$text}',date1='{$date1}',date2='{$date2}',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>
   			<? if ($res['status']>0){?>
   			<li><a href="#tab2">Изображения</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>
	<select name='typ' >
	<?foreach($materials_type as $key=>$val){echo "<option "; if ($res['type']==$key)echo "selected"; echo " value='{$key}'>{$val}</option>";}?>
	</select></fieldset>
	<fieldset class="right">
	<label>Алиас</label>
	<input type='text' name='alias' id='alias' value='<?=$res['alias']?>' />
	</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 class='left'>
	<label>Дата создания</label>
	<input type='text' name='date1' id='date1' value='<?=sql2date($res['date1'])?>'>&nbsp;<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'])?>'>&nbsp;<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>&nbsp;&nbsp;<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">
				<?=$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"; ?>