| Server IP : 27.254.152.13 / Your IP : 216.73.217.38 Web Server : Apache/2 System : Linux ns1-252017.dragonhispeed.com 5.2.0 #1 SMP Fri Mar 29 22:50:14 MSK 2024 x86_64 User : coloflew ( 1072) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/coloflew/domains/fulltion.com/private_html/administrator/modules/manu_master/ |
Upload File : |
<?php
$linkUrl = "index.php?name=manu_master&file=province";
if(@$_GET['act']=="add"){
@$arrData = array();
@$idarr = @$db->getOne("province","MAX(PROVINCE_ID) as PROVINCE_ID","","");
//echo "<pre>";print_r(@$idarr);
@$id = @$idarr['PROVINCE_ID'];
@$autoid = @$id+1;
@$lang = @$db->getAll("language","*","","","");
if(@$lang){
foreach(@$lang as $key => $value ){
@$arrData['PROVINCE_ID'] = @$autoid;
@$arrData['PROVINCE_CODE'] = @$_POST['PROVINCE_CODE'];
@$arrData['PROVINCE_NAME'] = @$_POST['PROVINCE_NAME'];
@$arrData['PROVINCE_NAME_EN'] = @$_POST['PROVINCE_NAME_EN'];
@$arrData['GEO_ID'] = @$_POST['GEO_ID'];
@$arrData['status'] = @$_POST['status'];
@$arrData['lang_code'] = @$value['lang_code'];
foreach(@$arrData as $k => $v ){
@$arrData[@$k] = str_replace("'", "\'", @$v);
}
//echo "<pre>"; print_r(@$arrData);
//exit;
@$db->insertData("province",@$arrData);
}
}
//exit;
@$msg = "Save Data complete.";
@$res = true;
}elseif(@$_GET['act']=="editdata"){
@$arrData = array();
@$arrData['PROVINCE_CODE'] = @$_POST['PROVINCE_CODE'];
@$arrData['PROVINCE_NAME'] = @$_POST['PROVINCE_NAME'];
@$arrData['PROVINCE_NAME_EN'] = @$_POST['PROVINCE_NAME_EN'];
@$arrData['GEO_ID'] = @$_POST['GEO_ID'];
@$arrData['status'] = @$_POST['status'];
foreach(@$arrData as $k =>$v ){
@$arrData[@$k] = str_replace("'", "\'", @$v);
}
@$db->updateData("province",@$arrData," PROVINCE_ID='".@$_POST['PROVINCE_ID']."' and lang_code='".@$lang_code."'");
@$msg = "Edit Data complete.";
@$res = true;
}elseif(@$_GET['act']=="edit"){
@$arrRes = @$db->getOne("province","*"," PROVINCE_ID='".@$_GET['PROVINCE_ID']."' and lang_code='".@$lang_code."'");
}elseif(@$_GET['act']=="deletedata"){
@$db->deleteData("province"," PROVINCE_ID='".@$_GET['PROVINCE_ID']."'");
@$msg = "Delete Data complete.";
@$res = true;
}elseif(@$_GET['act']=="deleteAll"){
//echo "<pre>"; print_r(@$_POST);
if(count(@$_POST['pagedel']) > 0){
foreach(@$_POST['pagedel'] as $key => $val){
@$db->deleteData("province"," PROVINCE_ID='".@$val."'");
}
}
@$msg = "Delete Data complete.";
@$res = true;
}
@$where_f = "lang_code='".@$lang_code."'";
@$where_lang = "lang_code='".@$lang_code."'";
@$search = @$_POST['keyword'] ? @$_POST['keyword'] : @$_GET['keyword'];
if(@$search){
@$searchnew= str_replace("'", "\'", @$search);
if(@$where_f){
@$where_f .= " and (PROVINCE_ID like '%".@$searchnew."%' or PROVINCE_CODE like '%".@$searchnew."%' or PROVINCE_NAME like '%".@$searchnew."%')";
}else{
@$where_f = " (PROVINCE_ID like '%".@$searchnew."%' or PROVINCE_CODE like '%".@$searchnew."%' or PROVINCE_NAME like '%".@$searchnew."%')";
}
}
@$page = @$_GET['page'] ? @$_GET['page'] : 1;
@$arrpageP = @$db->getAll("province", "*",@$where_f,"" );
@$arrPage = @$objMaster->viewPages(@$page, @$arrpageP, "15");
@$getPage = @$db->getAll("province","*",@$where_f,"",@$arrPage["offset"]);
@$getGeo = @$db->getAll( "geo", "*",@$where_lang." and status = '1'","" );
//echo "<pre>"; print_r(@$getPage);
?>
<!-- Start Content Box -->
<div class="content-box">
<!-- Start Content Box Header-->
<div class="content-box-header">
<h3><?php echo @$lang_set['Province']; ?></h3>
<ul class="content-box-tabs">
<li><a href="#list" <?php echo (@$_GET['act']=="" ? 'class="default-tab"' : '');?>><?php echo @$lang_set['list_province']; ?></a></li> <!-- href must be unique and match the id of target div -->
<li><a href="#add" <?php echo (@$_GET['act']=="edit" ? 'class="default-tab"' : '');?>><?php echo @$lang_set['add_province']; ?></a></li>
</ul>
<div class="clear"></div>
</div>
<!-- End Content Box Header-->
<!-- Start Content Box Content-->
<div class="content-box-content">
<?php if(@$res){?>
<div class="notification success png_bg">
<a href="#" class="close"><img src="resources/images/icons/cross_grey_small.png" title="Close this notification" alt="close" /></a>
<div>
<?php echo @$msg;?>
</div>
</div>
<meta http-equiv="refresh" content="1;URL=<?php echo $linkUrl;?>">
<?php }?>
<!-- Start Tab Content id="list"-->
<div class="tab-content <?php echo (@$_GET['act']=="" ? 'default-tab' : '');?>" id="list">
<form action="<?php echo $linkUrl;?>" method="post" name="form_search">
<?php echo @$lang_set['input_search'];?> :
<input type="text" class="text" value="<?PHP echo @$search;?>" name="keyword" />
<input type="submit" class="button" value="ค้นหา"/>
</form>
<form action="<?php echo $linkUrl;?>&act=deleteAll" method="post" onsubmit="return confirmDelete(this);">
<table cellpadding="0" cellspacing="0" width="100%">
<thead>
<tr>
<th><input type="checkbox" class="check_all" /></th>
<th><?php echo @$lang_set['PROVINCE_CODE']; ?></th>
<th><?php echo @$lang_set['PROVINCE_NAME']; ?></th>
<th><?php echo @$lang_set['PROVINCE_NAME_EN']; ?></th>
<th><?php echo @$lang_set['geo_name']; ?></th>
<th><?php echo @$lang_set['province_status']; ?></th>
<th style="text-align:right;"><?php echo @$lang_set['action']; ?></th>
</tr>
</thead>
<?php
if(@$getPage){
foreach(@$getPage as $key => $val){
@$getgeo = @$db->getOne("geo","*"," GEO_ID='".@$val['GEO_ID']."' and lang_code='".@$lang_code."'");
?>
<tr>
<th><input type="checkbox" name="pagedel[]" value="<?php echo @$val['PROVINCE_ID'];?>"/></th>
<th><?php echo @$val['PROVINCE_CODE'];?></th>
<th><?php echo @$val['PROVINCE_NAME'];?></th>
<th><?php echo @$val['PROVINCE_NAME_EN'];?></th>
<th><?php echo @$getgeo['GEO_NAME'];?></th>
<th>
<select name="ProvinceStatus" onchange="AJAX_Update_status('province','Status',this.options[this.selectedIndex].value,'<?php echo @$val['PROVINCE_ID']?>','PROVINCE_ID');">
<option value="1" <?php echo (@$val['status']=="1" ? "selected" : "");?>><?php echo @$lang_set['show']; ?></option>
<option value="0" <?php echo (@$val['status']=="0" ? "selected" : "");?>><?php echo @$lang_set['hide']; ?></option>
</select>
</th>
<th style="text-align:right;">
<a href="<?php echo $linkUrl;?>&act=edit&PROVINCE_ID=<?php echo @$val['PROVINCE_ID']?>#add" title="Edit"><img src="resources/images/icons/pencil.png" alt="Edit" /></a> |
<a href="javascript:void();" title="Delete" onclick="chkConfirm('<?php echo $linkUrl;?>&act=deletedata&PROVINCE_ID=<?php echo @$val['PROVINCE_ID']?>','ยืนยันการลบข้อมูล');"><img src="resources/images/icons/cross.png" alt="Delete" /></a>
</th>
</tr>
<?php
}
}else{
?>
<tr>
<th colspan="11" style="text-align:center"><?php echo @$lang_set['not_data']; ?></th>
</tr>
<?php
}
?>
<tfoot>
<tr>
<td colspan="11">
<div class="bulk-actions align-left">
<select name="actdel">
<option value="del"><?php echo @$lang_set['delete']; ?></option>
</select>
<input class="button" type="submit" value="<?php echo @$lang_set['selected']; ?>" />
</div>
<!-- Start .pagination -->
<div class="pagination">
<?php if($arrPage['allpage']>1){?>
<a href="<?php echo $linkUrl;?>&page=1&keyword=<?PHP echo @$search;?>" title="หน้าแรก">« หน้าแรก</a><a href="<?php echo $linkUrl;?>&page=<?php echo (1==$page ? $page : @$page-1);?>&keyword=<?PHP echo @$search;?>" title="ก่อนหน้า">« ก่อนหน้า</a>
<?php if( @$arrPage["startPage"]!="" && @$arrPage["endPage"] !="" ){?>
<?php
for($i = @$arrPage["startPage"]; $i <= @$arrPage["endPage"]; ++$i) {
echo'<a href="'. $linkUrl.'&keyword='.@$search.'&page='.@$i.'" '.(@$page == @$i ? 'class="number current"' : '').'>'.(@$i).'</a>';
}?>
<?php }?>
<a href="<?php echo $linkUrl;?>&page=<?php echo ($page==$arrPage["allpage"] ? $page : $page+1);?>&keyword=<?PHP echo @$search;?>" title="ถัดไป">ถัดไป »</a><a href="<?php echo $linkUrl;?>&page=<?php echo @$arrPage["allpage"];?>&keyword=<?PHP echo @$search;?>" title="หน้าสุดท้าย">หน้าสุดท้าย »</a>
<?php }?>
</div>
<!-- End .pagination -->
<div class="clear"></div>
</td>
</tr>
</tfoot>
</table>
</form>
</div>
<!-- End Tab Content id="list"-->
<!-- Start Tab Content id="add"-->
<div class="tab-content <?php echo (@$_GET['act']=="edit" ? 'default-tab' : '');?>" id="add">
<form action="<?php echo $linkUrl;?>&act=<?php echo (@$_GET['act']=="edit" ? "editdata" : "add");?>#add" method="post" enctype="multipart/form-data" onsubmit="return checkpageprovince();"><!--onsubmit="return checkdelivery();"-->
<fieldset>
<input type="hidden" name="PROVINCE_ID" value="<?php echo @$_GET['PROVINCE_ID'];?>">
<p>
<label><?php echo @$lang_set['geo_name']; ?>:</label>
<select name="GEO_ID">
<?php
if(@$getGeo){foreach(@$getGeo as $key => $val){
?>
<option value="<?php echo @$val['GEO_ID'];?>" <?php echo (@$val['GEO_ID']=='' || @$val['GEO_ID']==@$arrRes['GEO_ID'] ? "selected" : "")?>><?php echo @$val['GEO_NAME'];?></option>
<?php }
}
?>
</select>
</p>
<p>
<label><?php echo @$lang_set['PROVINCE_CODE']; ?>:</label>
<input type="text" class="text-input smail-input" name="PROVINCE_CODE" id="PROVINCE_CODE" value="<?php echo @$arrRes['PROVINCE_CODE'];?>" />
<!--<span class="input-notification error png_bg" id="span_name"></span>--></p>
<p>
<label><?php echo @$lang_set['PROVINCE_NAME']; ?>:</label>
<input type="text" class="text-input medium-input" name="PROVINCE_NAME" id="PROVINCE_NAME" value="<?php echo @$arrRes['PROVINCE_NAME'];?>" />
<!--<span class="input-notification error png_bg" id="span_value"></span>--></p>
<p>
<p>
<label><?php echo @$lang_set['PROVINCE_NAME_EN']; ?>:</label>
<input type="text" class="text-input medium-input" name="PROVINCE_NAME_EN" id="PROVINCE_NAME_EN" value="<?php echo @$arrRes['PROVINCE_NAME_EN'];?>" />
<!--<span class="input-notification error png_bg" id="span_value"></span>--></p>
<p>
<input type="radio" name="status" value="1" <?php echo (@$arrRes['status']=="1" ? "checked" : "" ); ?> /> <?php echo @$lang_set['show']; ?>
<input type="radio" name="status" value="0" <?php echo ( !@$arrRes['status'] || @$arrRes['status']=="0" ? "checked" : "" ); ?>/><?php echo @$lang_set['hide']; ?>
</p>
<p>
<input type="submit" class="button" value="<?php echo @$lang_set['submit']; ?>" />
</p>
</fieldset>
</form>
</div>
<!-- End Tab Content id="add"-->
</div>