import.php | searchcode

/application/controllers/import.php

https://bitbucket.org/remobius/crm
PHP | 421 lines | 286 code | 43 blank | 92 comment | 36 complexity | 1d7a171da68c473fc4e15b417ecca63b MD5 | raw file
Possible License(s): GPL-2.0, MIT, LGPL-3.0, LGPL-2.1, GPL-3.0

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class import extends CI_Controller {
	
	function __construct(){
		parent::__construct();
		#$this->load->library('image_lib');		
	}
	
	function test(){
		$fields = $this->db->list_fields('produk_sn');
		foreach( $fields as $field ){
		   echo $field . "<br/>";
		}
		exit;
		
		$agama= "KATHOLIK";
		if( $agama == "katholik" ){
			echo "yes";
		}
		exit;
		echo $this->Gmodel->getLastId("02001");
		exit;
		
		$this->db->select('IdKota');
		$query=$this->db->get_where('m_kota', array('NamaKota'=>"Jakarta"))->row_array();
		print_r($query);
		exit;
		$keys= array('foo', 5, 10, 'bar');
		$a= array_fill_keys($keys, 'banana');
		print_r($a);
	}
	
	function snset(){
		$link= fopen("D:/SN.csv", "r");
		$buffer= fgets($link);
		$buffer= explode(";", trim($buffer));
		
		# Get Keys
		$keys= array();
		foreach( $buffer as $value ){
			$keys[]= trim($value);
		}
	
		# Combine key dengan data
		$getdata= array();
		if( $link ){
			while( !feof($link) ){
				$buffer= fgets($link);
				if( !empty($buffer) ){
					$buffer= trim($buffer);
					$buffer= explode(";", $buffer);
					if( count($keys) === count($buffer) ){
						$getdata[]= array_combine($keys, $buffer);
					}
				}
			}
			fclose($link);
		}
		unset($getdata[0]);

		$unsetkey= array("Description","In","Out","Bal");
		foreach( $unsetkey as $key=>$value ){
			unset($getdata[$value]);
		}
		
		foreach( $getdata as $key=>$value ){
			print_r($getdata);
			echo "<br/>";
		}
		exit;
		
		'IdProduk','NoSerial','IdKlinik','Status','AddUser','AddDate';
		
		$setfields= array("Category"=>"IdCategory", "Description"=>"Model", "Item_Number"=>"IdProduk", 
						  "Price"=>"Harga");
		$ct= 0;
		foreach( $getdata as $key=>$value ){
			foreach( $value as $subkey=>$subvalue ){
				$partdata= array();
				if( array_key_exists($subkey, $setfields) ){
					$idkey= $setfields[$subkey];
					if( ! empty($subvalue) ){
						$fixdata[$key][$idkey]= $subvalue;
					}
				}
			}
		}
		/*
		print_r($fixdata);
		echo "<br/>";
		echo count($fixdata);
		exit;
		*/
		
		$AddUser= "admin";
		$AddDate= date("Y-m-d");
		foreach( $fixdata as $key=>$value ){
			foreach( $value as $subkey=>$subvalue ){
				if( $subkey == "Harga" ){
					$subvalue= str_replace(array(".", ",","(",")"), array("", ".", "", ""), $subvalue);
				}
				$produk_ins[$key][$subkey]= $subvalue;
				$produk_harga_ins[$key][$subkey]= $subvalue;
			}
			
			$toproduk= array("Garansi"=>0, "Type"=>"P", "AddUser"=>$AddUser, "AddDate"=>$AddDate);
			foreach( $toproduk as $field=>$field_value ){
				$produk_ins[$key][$field]= $field_value;
			}
			
			$toproduk_harga= array("IdMataUang"=>"IDR", "AddUser"=>$AddUser, "AddDate"=>$AddDate);
			foreach( $toproduk_harga as $field=>$field_value ){
				$produk_harga_ins[$key][$field]= $field_value;
			}
			
			unset($produk_ins[$key]['Harga']);
			$unsetharga= array("IdCategory", "Model", "Garansi", "Type");
			foreach( $unsetharga as $value ){
				unset($produk_harga_ins[$key][$value]);
			}
		}
		
		foreach( $produk_ins as $value ){
			$this->db->insert('produk', $value);
		}
		
		foreach( $produk_harga_ins as $value ){
			$this->db->insert('produk_harga', $value);
		}
		
		#print_r($produk_harga_ins);
		#print_r($produk_ins);
		exit;
	}
	
	function produkset(){	
		$link= fopen("D:/format_produk.csv", "r");
		$buffer= fgets($link);
		$buffer= explode(";", trim($buffer));
		
		# Get Keys
		$keys= array();
		foreach( $buffer as $value ){
			$keys[]= trim($value);
		}
		
		# Combine key dengan data
		$getdata= array();
		if( $link ){
			while( !feof($link) ){
				$buffer= fgets($link);
				if( !empty($buffer) ){
					$buffer= trim($buffer);
					$buffer= explode(";", $buffer);
					if( count($keys) === count($buffer) ){
						$getdata[]= array_combine($keys, $buffer);
					}
				}
			}
			fclose($link);
		}		
		unset($getdata[0]);
		
		$setfields= array("Category"=>"IdCategory", "Description"=>"Model", "Item_Number"=>"IdProduk", 
						  "Price"=>"Harga");
		$ct= 0;
		foreach( $getdata as $key=>$value ){
			foreach( $value as $subkey=>$subvalue ){
				$partdata= array();
				if( array_key_exists($subkey, $setfields) ){
					$idkey= $setfields[$subkey];
					if( ! empty($subvalue) ){
						$fixdata[$key][$idkey]= $subvalue;
					}
				}
			}
		}
		/*
		print_r($fixdata);
		echo "<br/>";
		echo count($fixdata);
		exit;
		*/
		
		$AddUser= "admin";
		$AddDate= date("Y-m-d");
		foreach( $fixdata as $key=>$value ){
			foreach( $value as $subkey=>$subvalue ){
				if( $subkey == "Harga" ){
					$subvalue= str_replace(array(".", ",","(",")"), array("", ".", "", ""), $subvalue);
				}
				$produk_ins[$key][$subkey]= $subvalue;
				$produk_harga_ins[$key][$subkey]= $subvalue;
			}
			
			$toproduk= array("Garansi"=>0, "Type"=>"P", "AddUser"=>$AddUser, "AddDate"=>$AddDate);
			foreach( $toproduk as $field=>$field_value ){
				$produk_ins[$key][$field]= $field_value;
			}
			
			$toproduk_harga= array("IdMataUang"=>"IDR", "AddUser"=>$AddUser, "AddDate"=>$AddDate);
			foreach( $toproduk_harga as $field=>$field_value ){
				$produk_harga_ins[$key][$field]= $field_value;
			}
			
			unset($produk_ins[$key]['Harga']);
			$unsetharga= array("IdCategory", "Model", "Garansi", "Type");
			foreach( $unsetharga as $value ){
				unset($produk_harga_ins[$key][$value]);
			}
		}
		
		foreach( $produk_ins as $value ){
			$this->db->insert('produk', $value);
		}
		
		foreach( $produk_harga_ins as $value ){
			$this->db->insert('produk_harga', $value);
		}
		
		#print_r($produk_harga_ins);
		#print_r($produk_ins);
		exit;
	}

	function index(){
		$link= fopen("D:/format_produk.csv", "r");
		$buffer= fgets($link);
		$buffer= explode(";", trim($buffer));
		
		# Get Keys
		$keys= array();
		foreach( $buffer as $value ){
			$keys[]= trim($value);
			#echo $value . "<br/>";
			#echo $buffer . "<br/><br/>";
		}
		#echo count($keys) . "<br/>";
		
		# Combine key dengan data
		$getdata= array();
		if( $link ){
			while( !feof($link) ){
				$buffer= fgets($link);
				if( !empty($buffer) ){
					$buffer= trim($buffer);
					$buffer= explode(";", $buffer);
					#echo count($buffer) . "<br/>";
					if( count($keys) === count($buffer) ){
						$getdata[]= array_combine($keys, $buffer);
					}
				}
				
					/*
					foreach( $buffer as $value ){
						echo $value . "<br/>";
						array_combine($a, $b);
					}
					$keys= array('foo', 5, 10, 'bar');
					$a= array_fill_keys($keys, 'banana');
					*/
					#echo $buffer . "<br/><br/>";
		}
		fclose($link);
		}		
		unset($getdata[0]);
		/*
		$fields= $this->db->list_fields('konsumen');
		foreach( $fields as $field ){			
		   echo $field . "<br/>";
		} 
		*/
		#"propinsi"=>"IdRegion", 
		// Change key
		$setfields= array("Category"=>"IdCategory", "Description"=>"Model", "Item_Number"=>"IdProduk", 
						  "Price"=>"Harga");
		#$fixdata= array();
		$ct= 0;
		foreach( $getdata as $key=>$value ){
			foreach( $value as $subkey=>$subvalue ){
				$partdata= array();
				if( array_key_exists($subkey, $setfields) ){
					#echo $subkey . ",";
					$idkey= $setfields[$subkey];
					if( ! empty($subvalue) ){
						$fixdata[$key][$idkey]= $subvalue;
					}
					#$fixdata[$ct][$idkey]= $subvalue;
					#echo $idkey . ", ";
				}
			}
			#echo "<br/>";
			/*
			$ct++;
			$fixdata[$key]['KonsumenStatus']= 0;
			$fixdata[$key]['IdNegara']= "ID";
			*/
			#$comm_data= array_combine($keydata, $valdata);
			#$fixdata[]= $comm_data;
			#print_r($comm_data);
			#$fixdata[]= $comm_data;
			#array_co
			#echo "<br/>";
		}
		#print_r($getdata);
		/*
		print_r($fixdata);
		echo "<br/>";
		echo count($fixdata);
		exit;
		*/
		/*
		print_r($fixdata);
		exit;
		*/
		
		foreach( $fixdata as $key=>$value ){
			foreach( $value as $subkey=>$subvalue ){
				$beginval= array("P","L");
				$endval= array("0","1");
				$subvalue= ($subkey == "JenisKelamin") ? str_replace($beginval, $endval, $subvalue) : $subvalue;
				$insertdt[$key][$subkey]= $subvalue;
				#echo $subvalue . ",";
			}
			
			$insertdt[$key]['IdSapaan']= ( $insertdt[$key]['JenisKelamin'] == "1" ) ? "Mr" : "Mrs";
			$bulan= ( !empty($value['TanggalLahir2']) ) ? sprintf("%02s", $value['TanggalLahir2']) : $value['TanggalLahir2'];
			$insertdt[$key]['TanggalLahir']= $value['TanggalLahir3'] . "-" . $bulan . "-" . $value['TanggalLahir'];
						
			if( preg_match("#^0.+$#", $value['TelponRumah']) ){
				$value['TelponRumah']= substr($value['TelponRumah'], 1);
				$insertdt[$key]['TelponRumah']= "+62" . $value['TelponRumah'];
			}else{
				$insertdt[$key]['TelponRumah']= "+62" . $value['TelponRumah'];
			}
			
			if( preg_match("#^0.+$#", $value['NoHP']) ){
				$value['NoHP']= substr($value['NoHP'], 1);
				$insertdt[$key]['NoHP']= "+62" . $value['NoHP'];
			}else{
				$insertdt[$key]['NoHP']= "+62" . $value['NoHP'];
			}
			
			if( !empty($value['Agama']) ){
				$value['Agama']= strtolower($value['Agama']);
				if( preg_match("#^(islam|muslim)$#", $value['Agama']) ){
					$value['Agama']= "moslem";
				}
				if( $value['Agama'] == "kristen" ){
					$value['Agama']= "christian";
				}
				if( $value['Agama'] == "katholik" ){
					$value['Agama']= "catholic";
				}
				$this->db->select('IdAgama');
				$row=$this->db->get_where('m_agama', array('Agama'=>$value['Agama']))->row_array();
				$insertdt[$key]['IdAgama']= ( isset($row['IdAgama']) ) ? $row['IdAgama'] : "";				
			}
			
			if( !empty($value['IdKota']) ){
				$this->db->select('IdKota');
				$row=$this->db->get_where('m_kota', array('NamaKota'=>$value['IdKota']))->row_array();
				$insertdt[$key]['IdKota']= ( isset($row['IdKota']) ) ? $row['IdKota'] : "";
			}
			
			if( !empty($value['Cabang']) ){
				$sql= "SELECT IdKlinik FROM klinik a 
				INNER JOIN m_kota b ON a.IdKota= b.IdKota
				WHERE b.NamaKota='" . $value['Cabang'] . "'";
				$row= $this->db->query($sql)->row_array();
				#print_r($row);
				$insertdt[$key]['IdKlinik']= ( isset($row['IdKlinik']) ) ? $row['IdKlinik'] : "02001";
			}
			/*			
			print_r($insertdt[$key]);
			echo "<br/><br/>";
			*/
			#$query=$this->db->get_where('m_kota', array('IdKota'=>$value['IdKota']));
		}
		/*
		print_r($insertdt);
		exit;
		*/
		foreach( $insertdt as $key=>$value ){
			if( ! empty($value['IdKlinik']) ){
				$value['IdKonsumen']= $this->Gmodel->getLastId($value['IdKlinik']);
				$insertdt[$key]['IdKonsumen']= $value['IdKonsumen'];
			}
			unset($value['Cabang'], $value['TanggalLahir2'], $value['TanggalLahir3'], $value['Agama'], $value['IdKlinik']);

			#if( ! empty($value['NamaAwal']) ){
			if( ! empty($value['IdKonsumen']) ){
				/*
				print_r($value);
				echo "<br/><br/>";*/
				$this->db->insert('konsumen2', $value);
			}

			print_r($value);
			echo "<br/><br/>";
			foreach( $value as $subkey=>$data ){
			}
			/*
			foreach( $value as $subkey=>$data ){
				#$subvalue
				$this->db->insert('konsumen2', $value);
			}
			*/
		}
		exit;
	}
	
	function listfield(){
		$fields = $this->db->list_fields('konsumen');
		foreach ($fields as $field)
		{
		   echo $field . "<br/>";;
		} 
	}
}
?>