<?php
class Saman_info extends Controller{
function index(){ $obj_saman_info = Load::model("Saman_info_m"); #print($obj_saman_info->name); $this->view->set('URL',$this->view->siteURL); #$newpost=Load::model("newposts"); #$vars = get_object_vars(Saman_info_m); #print_r ( $vars );exit; $var=$obj_saman_info->get_vars(); $cm=$obj_saman_info->Comment_Data(); #$cm=mysql_fetch_array($cm); for($i=0;$fetch_record=mysql_fetch_array($cm,MYSQL _ASSOC);$i++) $rows[$i]=$fetch_record; $this->view->set("tbl_schema",$rows); #print_r($rows);exit; $arrvalue=array(); foreach($var as $key=>$value) { array_push($arrvalue, array("$key"=>$value)); #$arrvalue->value=$value; } #print_r($arrvalue); //vars = get_class_vars("Saman_info_m"); #foreach($vars as $key=>$value) #print($key." ____ "); #print($key."\n"); #$rows=$newpost->GetFromTable("*","cat='news' AND del=0 order by `id` desc limit 5"); #for($i=0;$news=mysql_fetch_array($rows);$i++) # $row[$i]=$news; #print_r($row);exit; $this->view->set("news",$row); #$this->view->set('galleryURL',$this->view->siteURL."app/view/images/gallery/"); #$this->view->render('header'); $this->view->render('import'); $this->view->render('menu'); $this->view->render('calendar_input'); $this->view->render('sidebar'); $this->view->render('forms_members'); $this->view->render('footer'); #$this->view->render('footer'); } function add() { //$this->view->render('header'); $obj_saman_info = Load::model("Saman_info_m"); #print_r($_POST);exit; if(isset($_POST) && count($_POST)>0) $obj_saman_info->AddDataInTable($_POST); $last=$obj_saman_info->executeQuery("SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLESWHERE TABLE_SCHEMA = 'hegza_saman' AND TABLE_NAME = 'hegza_saman_info' LIMIT 1"); $last=mysql_fetch_row($last);$last=$last['0']-1; #print_r($last);exit; #header('Location: http://localhost/smn/saman_info/read_all'); echo "<meta HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=http://localhost/smn/saman_members&id=".$last."\">";
} function deleteall() { $pi = $_POST['data']; $obj_edarekol_personalinfo = Load::model("Saman_info_m"); for($i=0;$i<count($pi);$i++) { $obj_edarekol_personalinfo->deleteFromTable(" id_saman=".$pi[$i].""); } } function update() { if(isset($_GET['id']) && $_GET['id']!="") { //$this->view->render('header'); $id=$_GET['id']; $obj_saman_info = Load::model("Saman_info_m"); #print_r($_POST);exit; $obj_saman_info->updateTable($_POST," id_saman=".$id); } #header("Location: http://localhost/smn/saman_info/read_all"); echo "<meta HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=http://localhost/smn/saman_info/read_all\">"; } function edit() { if(isset($_GET['upd']) && $_GET['upd']!="") { $id=mysql_real_escape_string($_GET['upd']); //$this->view->render('header'); $obj_saman_info = Load::model("Saman_info_m"); #print_r($_POST);exit; $rows=$obj_saman_info->AllData("id_saman=".$id); $row=mysql_fetch_array($rows,MYSQL_ASSOC); $this->view->set("datatable",$row); #print($row);exit; $this->view->set("id",$_GET['upd']); $this->view->render('import'); $this->view->render('menu'); $this->view->render('calendar_input'); $this->view->render('sidebar'); $this->view->render('edit_saman_info'); $this->view->render('footer'); } #header("Location: http://localhost/smn/saman_info/read_all"); else { echo "<meta HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=http://localhost/smn/saman_info/read_all\">"; } } function read_all() { $obj_saman_info = Load::model("Saman_info_m"); if(isset($_GET['del']) && $_GET['del']!="") { $obj_saman_info->deleteFromTable(" id_saman=".$_GET['del']); } $rows = $obj_saman_info->AllData("1 order by id_saman desc"); for($i=0;$fetch_record=mysql_fetch_array($rows,MYS QL_ASSOC);$i++) $row[$i]=$fetch_record; $this->view->set("datatable",$row); #$this->view->render('header'); $this->view->render('import'); $this->view->render('menu'); $this->view->render('sidebar'); $this->view->render('table_head'); $this->view->render('tables'); #print_r($row); #print_r($_POST); } function profile() { $id=$_GET['id']; $this->view->set("id",$id); $obj_saman_info = Load::model("Saman_info_m"); $rows = $obj_saman_info->AllData("id_saman=".$id); $row=mysql_fetch_array($rows,MYSQL_ASSOC); $this->view->set("datatable",$row); #---------- read jalasat --------# $obj_saman_jalasat = Load::model("jalasat_m"); $obj_saman_j_preslist=Load::model("jalasat_present ationlist_m"); $rows2 = $obj_saman_j_preslist->executeQuery("SELECT *FROM hegza_jalasat_presentationlistINNER JOIN hegza_jalasat ON hegza_jalasat.id_jalase = hegza_jalasat_presentationlist.id_jalaseWHERE hegza_jalasat_presentationlist.id_saman =".$id." GROUP BY hegza_jalasat.id_jalase"); for($i=0;$fetch_record=mysql_fetch_array($rows2);$ i++) $row2[$i]=$fetch_record; $this->view->set("datatable_j",$row2); #---------- read neshast ------------# $obj_saman_neshast = Load::model("neshast_info_m"); $obj_saman_n_preslist=Load::model("neshast_present ationlist_m"); $rows3 = $obj_saman_neshast->executeQuery("SELECT * FROM hegza_neshast_info, hegza_neshast_presentationlist, hegza_neshast_presentationlist_samanWHERE hegza_neshast_info.id_neshast = hegza_neshast_presentationlist.id_neshastAND hegza_neshast_presentationlist.id = hegza_neshast_presentationlist_saman.idAND hegza_neshast_presentationlist_saman.id_saman =".$id." GROUP BY hegza_neshast_info.id_neshast"); for($i=0;$fetch_record=mysql_fetch_array($rows3);$ i++) $row3[$i]=$fetch_record; $this->view->set("datatable_n",$row3); #---------- read bank account --------# $obj_saman_j_preslist=Load::model("saman_bankaccou nt_m"); $rows4 = $obj_saman_j_preslist->AllData(" id_saman=".$id); for($i=0;$fetch_record=mysql_fetch_array($rows4);$ i++) $row4[$i]=$fetch_record; $this->view->set("datatable_bnk",$row4); #---------- read addresses --------# #$rows2=0;$row2=0; $obj_saman_j_preslist=Load::model("saman_addresses _m"); $rows5 = $obj_saman_j_preslist->AllData(" id_saman=".$id); for($i=0;$fetch_record=mysql_fetch_array($rows5);$ i++) $row5[$i]=$fetch_record; $this->view->set("datatable_add",$row5); #---------- read heyat moases --------# #$rows2=0;$row2=0; $obj_saman_j_preslist=Load::model("saman_members_m "); $rows6 = $obj_saman_j_preslist->AllData(" id_saman=".$id." and heyat=1"); for($i=0;$fetch_record=mysql_fetch_array($rows6);$ i++) $row6[$i]=$fetch_record; $this->view->set("datatable_hmo",$row6); #---------- read shora --------# #$rows2=0;$row2=0; #$obj_saman_j_preslist=Load::model("saman_members_ m"); $rows7 = $obj_saman_j_preslist->AllData(" id_saman=".$id." and shora=1"); for($i=0;$fetch_record=mysql_fetch_array($rows7);$ i++) $row7[$i]=$fetch_record; $this->view->set("datatable_sho",$row7); #---------- read members --------# #$rows2=0;$row2=0; #$obj_saman_j_preslist=Load::model("saman_members_ m"); $rows8 = $obj_saman_j_preslist->AllData(" id_saman=".$id); for($i=0;$fetch_record=mysql_fetch_array($rows8);$ i++) $row8[$i]=$fetch_record; $this->view->set("datatable_mem",$row8); #---------- read mojavez --------# #$rows2=0;$row2=0; $obj_saman_j_preslist=Load::model("saman_mojavez_m "); $rows9 = $obj_saman_j_preslist->AllData("id_saman=".$id); for($i=0;$fetch_record=mysql_fetch_array($rows9);$ i++) $row9[$i]=$fetch_record; $this->view->set("datatable_moj",$row9); #---------- read verfication doc --------# #$rows2=0;$row2=0; $obj_saman_j_preslist=Load::model("Saman_verificat ion_docs_m"); $rows10 = $obj_saman_j_preslist->AllData(" id_saman=".$id); for($i=0;$fetch_record=mysql_fetch_array($rows10); $i++) $row10[$i]=$fetch_record; $this->view->set("datatable_let",$row10); #print_r($row10);exit; $this->view->set("id",$id); #exit; $this->view->render('import'); $this->view->render('menu'); $this->view->render('sidebar'); $this->view->render('profile_saman');
} function upload_file() { //print_r($_FILES);exit; $formats = array("jpg", "png", "gif", "bmp", "jpeg", "PNG", "JPG", "JPEG", "GIF", "BMP","zip","rar","pdf","doc","docx"); if(isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST"){ $name = $_FILES['file']['name']; $size = $_FILES['file']['size']; $tmp = $_FILES['file']['tmp_name']; if(strlen($name)){ $i=strrpos($name,"."); if(!$i) { $ext=""; } $l=strlen($name)-$i; $ext=substr($name,$i+1,$l); if(in_array($ext,$formats)) { if($size<(2048*2048)) { $imgn = time().".".$ext; if(move_uploaded_file($tmp, "upload/uploads/".$imgn)){ echo "<br/>File Location : /Image_upload/uploads/".$imgn;#www.hegzaco.com/app/view/uploads/".$imgn echo "<br/>Image : <img style='margin-left:10px;' src='uploads/".$imgn."'>"; } else{ echo "آپلود با مشکل مواجه شد.لطفاً بعدا مجدد تلاش نمایید."; } } else{ echo "حجم فایل بیشتر از 5مگابایت است"; } } else{ echo "فرمت فایل نامعتبر است."; } } else{ echo "فرمت انتخاب شده پشتیبانی نمیشود."; exit; } } } function rep() { $id=mysql_escape_string($_GET['id']); $this->view->set("id",$id); $obj_saman_jalasat = Load::model("Saman_info_m");
$rows = $obj_saman_jalasat->AllData("id_Saman=".$id); $fetch_record=mysql_fetch_array($rows); $row=$fetch_record; #print_r($row);exit; $this->view->set("datatable",$row); $this->view->render('import_rep'); $this->view->render('rep_Saman'); } function rep_all() { $obj_saman_jalasat = Load::model("Saman_info_m");
$rows = $obj_saman_jalasat->AllData(); for($i=0;$fetch_record=mysql_fetch_array($rows);$i ++) $row[$i]=$fetch_record; #print_r($row);exit; $this->view->set("datatable",$row); $this->view->render('import_rep'); $this->view->render('rep_all_Saman'); } function rep_a() { $obj_saman_info = Load::model("Saman_info_m"); $obj_saman_bank = Load::model("Saman_bankaccount_m"); $obj_saman_mjvz = Load::model("Saman_mojavez_m"); $obj_saman_mmbr = Load::model("Saman_members_m"); $obj_saman_adds = Load::model("Saman_addresses_m"); /*$rows3 = $obj_saman_info->executeQuery("SELECT * FROM hegza_Saman_info, hegza_Saman_bankaccount, hegza_Saman_mojavez, hegza_saman_members,hegza_Saman_addressesWHERE hegza_Saman_bankaccount.id_saman = hegza_saman_info.id_samanAND hegza_Saman_mojavez.id_saman = hegza_saman_info.id_saman AND hegza_Saman_members.id_saman = hegza_saman_info.id_saman AND hegza_Saman_addresses.id_saman = hegza_saman_info.id_saman GROUP BY hegza_saman_info.id_saman");*/ $rows = $obj_saman_info->AllData(); for($i=0;$fetch_record=mysql_fetch_array($rows);$i ++) { $row[$i]=$fetch_record; $row1=$obj_saman_bank->AllData("id_saman=".$fetch_record["id_saman"]); $bank[$i]=mysql_fetch_array($row1);print_r($mjvz[$i]);echo "<br>"; $row2=$obj_saman_mjvz->AllData(" id_saman=".$fetch_record["id_saman"]); $mjvz[$i]=mysql_fetch_array($row2);echo "<br>"; #array_merge($row[$i],mysql_fetch_array($row2)); $row3=$obj_saman_mmbr->AllData(" id_saman=".$fetch_record["id_saman"]." "); $mmbr[$i]=mysql_fetch_array($row3);echo "<br>"; #array_merge($row[$i],mysql_fetch_array($row3)); $row4=$obj_saman_adds->AllData(" id_saman=".$fetch_record["id_saman"]); $adds[$i]=mysql_fetch_array($row4);echo "<br>"; #$a=array("a"=>"a","b"=>"b","c"=>"c"); #$b=array("d"=>"d","e"=>"e","c"=>"f"); #print_r(array_merge($a,$b)); #echo "<br><br><br>"; #print_r( array_merge($a1,$a2,$a3,$a4)); } $this->view->set("datatable",$row); $this->view->set("bank",$bank); $this->view->set("mjvz",$mjvz); $this->view->set("mmbr",$mmbr); $this->view->set("adds",$adds); $this->view->render('import_rep'); $this->view->render('report_saman_all'); }}?>
ممنون