Gecko [ 122.154.134.11 ]

Name	Size	Permission
asset.php	89.73 KB	-rw-r--r--
asset_budget_type.php	6.99 KB	-rw-r--r--
asset_building.php	7.37 KB	-rw-r--r--
asset_code_model.php	7.75 KB	-rw-r--r--
asset_company.php	9.95 KB	-rw-r--r--
asset_form_upload.php	4.74 KB	-rw-r--r--
asset_list.php	12.23 KB	-rw-r--r--
asset_method.php	6.91 KB	-rw-r--r--
asset_notification.php	38.37 KB	-rw-r--r--
asset_permission.php	13.12 KB	-rw-r--r--
asset_print.php	9.88 KB	-rw-r--r--
asset_print1.php	8.43 KB	-rw-r--r--
asset_print_lend.php	3.49 KB	-rw-r--r--
asset_print_lend1.php	9.59 KB	-rw-r--r--
asset_print_lend2.php	8.85 KB	-rw-r--r--
asset_print_lendAll.php	3.27 KB	-rw-r--r--
asset_print_lendAll1.php	9.84 KB	-rw-r--r--
asset_print_qrcode.php	10.28 KB	-rw-r--r--
asset_print_qrcode1.php	1.45 KB	-rw-r--r--
asset_report1.php	20 KB	-rw-r--r--
asset_report23.php	20.09 KB	-rw-r--r--
asset_report4.php	19.76 KB	-rw-r--r--
asset_report_to_excell.php	6.54 KB	-rw-r--r--
asset_set.php	8.43 KB	-rw-r--r--
asset_status3.php	85.25 KB	-rw-r--r--
asset_status40.php	85.27 KB	-rw-r--r--
asset_type.php	9.5 KB	-rw-r--r--
index.php	5.76 KB	-rw-r--r--
livesearch.php	2.11 KB	-rw-r--r--
livesearch_notification.php	954 B	-rw-r--r--
manual.php	1.38 KB	-rw-r--r--

Code Editor : asset_form_upload.php

<?php
function  file_upload($id){
	$uploaddir = 'modules/asset/upload_files/';      //ที่เก็บไไฟล์
	$uploadfile = $uploaddir.basename($_FILES['userfile']['name']);
	$basename = basename($_FILES['userfile']['name']);
	if (move_uploaded_file($_FILES['userfile']['tmp_name'],  $uploadfile)){
		$txt ="asset-".$id;
		$before_name  = $uploaddir . $basename;
		$array_lastname = explode("." ,$basename) ;
		$c =count ($array_lastname) - 1 ;
		$lastname = strtolower ($array_lastname[$c]) ;
		$changed_name = $uploaddir.$txt.".".$lastname;
		rename("$before_name" , "$changed_name");
		return  $changed_name;
	}else{
		$changed_name="";
		return  $changed_name;
	}
}

//ส่วนฟอร์มรับข้อมูล
if ( ($index==1) and ($result_permission['p1']==1) ){
	if ($qrcode!=''){
		$qrcode_name='include/php_qrcode/temp/asset/asset-'.$id.'-qrcode.png';
		$sql =  "UPDATE asset_main SET photo_qrcode='$qrcode_name' WHERE id='$id' ";
		$dbquery = mysqli_query($connect,$sql);
	}
	$sql = "SELECT * FROM asset_main WHERE id='$id' ";
	$dbquery = mysqli_query($connect,$sql);
	$result = mysqli_fetch_array($dbquery);
	$photo= $result['photo'];
	$photo_qrcode= $result['photo_qrcode'];
	$servername=$_SERVER['SERVER_NAME'];
	//$url=$servername."/smss412/rss/report_e-asset_detail.php?id=".$id;
	$SCHEME = $_SERVER['REQUEST_SCHEME'];
	$HTTP_HOST = $_SERVER['HTTP_HOST'];
	// กรณีใช้ IP มี Subfolder 
	//$url= $SCHEME."://".$HTTP_HOST."/".$APP_PATH."rss/report_e-asset_detail.php?id=".$id;
	$url= $SCHEME."http://".$HTTP_HOST."/".$APP_PATH."/rss/report_e-asset_detail.php?id=".$id;
	echo "<Br>";
	echo "<center>";
	echo "<form Enctype=multipart/form-data id='frm1' name='frm1'>";
	echo "<table align ='center' border='0' width='50%'>";
	echo "<tr>";
	echo "<td></td>";
	echo "<td><strong><font color='#003366' size='4'>Upload Files</font></strong><br><br></td>";
	echo "<td></td>";
	echo "</tr>";
	echo "<tr bgcolor='#ffe4ca'><th>รูปภาพ(เดิม)</th><th>รายการ</th><th>เลือก</th></tr>";
	echo "<tr bgcolor='#eaffea'>";
	echo "<td><img src='$photo_qrcode' border='0' width='100'></td>";
	echo "<td valign='top'>รูปภาพ QR-CODE &nbsp;&nbsp;</td>";
	echo "<td valign='top'><a href='include/php_qrcode/index_asset.php?data=$url'>สร้างคิวอาร์โค้ด PHP QR-Code</a></td>";
	echo "</tr>";
	echo "<tr bgcolor='#fff4ea'>";
	echo "<td><img src='$photo' border='0' width='100'></td>";
	echo "<td valign='top'>รูปภาพทรัพย์สิน &nbsp;&nbsp;</td>";
	echo "<td valign='top'><INPUT TYPE='file'  name='userfile'  id='file'></td>";
	echo "</tr>";
	echo "<tr><td></td><td>
		<INPUT TYPE='hidden' name='max_file_size' value='2000000'>
		<INPUT TYPE='hidden' name='id' value=$_GET[id]>
		<INPUT TYPE='hidden' name='page' value=$_GET[page]>
		<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)'>&nbsp;
		<INPUT TYPE='button' name='back' value='กลับหน้าหลัก' onclick='goto_url(0)'>
		</td><td></td></tr>";
	echo "</table>";
	echo "</center>";
	echo "</form>";
}

//ส่วนบันทึกข้อมูล
if ($index==4) {
	$id	=$_REQUEST['id'];
	$page	=$_REQUEST['page'];
	if($_FILES['userfile']['name']==""){
		echo "<meta http-equiv=refresh content=0;URL='?option=asset&task=main/asset&id=$id&page=$page'>";
		exit();
	}

$sql = "SELECT * FROM asset_main WHERE id='$id' ";
	$dbquery = mysqli_query($connect,$sql);
	$result = mysqli_fetch_array($dbquery);
	$file= $result['photo'];
	unlink($file);
	if (isset($_FILES['userfile']))	{
		$changed_name = file_upload($id);
	}
	$sql =  "UPDATE asset_main SET photo='$changed_name' WHERE id='$id' ";
	if ($dbquery  = mysqli_query($connect,$sql) and $changed_name!=""){
		echo "<br><center><B><font color='#0066CC' Size='3'>บันทึกเรียบร้อยแล้ว กรุณารอสักครู่</font></B></center>";
		echo "<meta http-equiv=refresh content=0;URL='?option=asset&task=main/asset_form_upload&index=1&id=$id&page=$page'>";
	}else{
		echo "<br><center><B><font color='#00669C' Size='3'>เกิดปัญหาบางอย่าง ไม่สามารถบันทึกได้ค่ะ</font></B></center>";
		echo "<a href=\"javascript:history.back(-1)\">ค ลิ ก เ พื่ อ ย้ อ น ก ลั บ</a>";
//		exit();
	}
}

?> 
<script language="javascript">
function goto_url(val){
	if(val==0){
		callfrm("?option=asset&task=main/asset");   // page ย้อนกลับหน้าหลัก 
	}else if(val==1){
		callfrm("?option=asset&task=main/asset_form_upload&index=4");   //page ประมวลผล
	}
}
</script>

${this.title}

Code Editor : asset_form_upload.php