/**
* Find object by primary key using raw SQL to go fast.
* Bypass doSelect() and the object formatter by using generated code.
*
* @param mixed $key Primary key to use for the query
* @param PropelPDO $con A connection object
*
* @return Kategori A model object, or null if the key is not found
* @throws PropelException
*/
protected function findPkSimple($key, $con)
{
$sql = 'SELECT `id`, `nama_kategori`, `keterangan` FROM `kategori` WHERE `id` = :p0';
try {
$stmt = $con->prepare($sql);
$stmt->bindValue(':p0', $key, PDO::PARAM_INT);
$stmt->execute();
} catch (Exception $e) {
Propel::log($e->getMessage(), Propel::LOG_ERR);
throw new PropelException(sprintf('Unable to execute SELECT statement [%s]', $sql), $e);
}
$obj = null;
if ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$obj = new Kategori();
$obj->hydrate($row);
KategoriPeer::addInstanceToPool($obj, (string) $key);
}
$stmt->closeCursor();
return $obj;
}
/**
* Selects a collection of Barang objects pre-filled with all related objects except Produsen.
*
* @param Criteria $criteria
* @param PropelPDO $con
* @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
* @return array Array of Barang objects.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelectJoinAllExceptProdusen(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$criteria = clone $criteria;
// Set the correct dbName if it has not been overridden
// $criteria->getDbName() will return the same object if not set to another value
// so == check is okay and faster
if ($criteria->getDbName() == Propel::getDefaultDB()) {
$criteria->setDbName(BarangPeer::DATABASE_NAME);
}
BarangPeer::addSelectColumns($criteria);
$startcol2 = BarangPeer::NUM_HYDRATE_COLUMNS;
KategoriPeer::addSelectColumns($criteria);
$startcol3 = $startcol2 + KategoriPeer::NUM_HYDRATE_COLUMNS;
KemasanPeer::addSelectColumns($criteria);
$startcol4 = $startcol3 + KemasanPeer::NUM_HYDRATE_COLUMNS;
$criteria->addJoin(BarangPeer::ID_KATEGORI, KategoriPeer::ID, $join_behavior);
$criteria->addJoin(BarangPeer::ID_KEMASAN, KemasanPeer::ID, $join_behavior);
// symfony_behaviors behavior
foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) {
call_user_func($sf_hook, 'BaseBarangPeer', $criteria, $con);
}
$stmt = BasePeer::doSelect($criteria, $con);
$results = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$key1 = BarangPeer::getPrimaryKeyHashFromRow($row, 0);
if (null !== ($obj1 = BarangPeer::getInstanceFromPool($key1))) {
// We no longer rehydrate the object, since this can cause data loss.
// See http://www.propelorm.org/ticket/509
// $obj1->hydrate($row, 0, true); // rehydrate
} else {
$cls = BarangPeer::getOMClass();
$obj1 = new $cls();
$obj1->hydrate($row);
BarangPeer::addInstanceToPool($obj1, $key1);
}
// if obj1 already loaded
// Add objects for joined Kategori rows
$key2 = KategoriPeer::getPrimaryKeyHashFromRow($row, $startcol2);
if ($key2 !== null) {
$obj2 = KategoriPeer::getInstanceFromPool($key2);
if (!$obj2) {
$cls = KategoriPeer::getOMClass();
$obj2 = new $cls();
$obj2->hydrate($row, $startcol2);
KategoriPeer::addInstanceToPool($obj2, $key2);
}
// if $obj2 already loaded
// Add the $obj1 (Barang) to the collection in $obj2 (Kategori)
$obj2->addBarang($obj1);
}
// if joined row is not null
// Add objects for joined Kemasan rows
$key3 = KemasanPeer::getPrimaryKeyHashFromRow($row, $startcol3);
if ($key3 !== null) {
$obj3 = KemasanPeer::getInstanceFromPool($key3);
if (!$obj3) {
$cls = KemasanPeer::getOMClass();
$obj3 = new $cls();
$obj3->hydrate($row, $startcol3);
KemasanPeer::addInstanceToPool($obj3, $key3);
}
// if $obj3 already loaded
// Add the $obj1 (Barang) to the collection in $obj3 (Kemasan)
$obj3->addBarang($obj1);
}
// if joined row is not null
$results[] = $obj1;
}
$stmt->closeCursor();
return $results;
}
public function executeImportfile(sfWebRequest $request)
{
$allowed = array('xlsx', 'xls');
$file = $request->getFiles('file');
$fileSize = $file['size'];
$fileType = $file['type'];
$theFileName = $file['name'];
$uploadDir = sfConfig::get("sf_upload_dir");
$import = $uploadDir . '/import';
if (!is_dir($import)) {
mkdir($import, 0777);
}
$ext = pathinfo($theFileName, PATHINFO_EXTENSION);
if (!in_array($ext, $allowed)) {
$this->msg = 'file type not allowed. File Type Must ';
$y = 0;
foreach ($allowed as $x) {
if ($y != count($allowed) - 1) {
$this->msg .= $x . " or ";
} else {
$this->msg .= $x;
}
$y++;
}
$this->setTemplate('import');
} else {
move_uploaded_file($file['tmp_name'], "{$import}/{$theFileName}");
$inputFileName = $uploadDir . '/import/' . $theFileName;
try {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$data = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
for ($x = 3; $x <= count($data); $x++) {
$c = new Criteria();
$c->add(KategoriPeer::NAMA_KATEGORI, $data[$x]['C'], Criteria::EQUAL);
$kategori = $this->getIdColumn(KategoriPeer::doSelect($c));
$k = new Criteria();
$k->add(KemasanPeer::NAMA_KEMASAN, $data[$x]['E'], Criteria::EQUAL);
$kemasan = $this->getIdColumn(KemasanPeer::doSelect($k));
$p = new Criteria();
$p->add(ProdusenPeer::NAMA_PRODUSEN, $data[$x]['F'], Criteria::EQUAL);
$produsen = $this->getIdColumn(ProdusenPeer::doSelect($p));
$barang = BarangQuery::create()->findOneById($data[$x]['A']);
if (isset($barang)) {
$barang->setNamaBarang($data[$x]['B']);
$barang->setIdKategori("" . $kategori);
$barang->setStock($data[$x]['D']);
$barang->setIdKemasan("" . $kemasan);
$barang->setIdProdusen("" . $produsen);
$barang->setDescription($data[$x]['G']);
$barang->save();
} else {
$barang = new Barang();
$barang->setNamaBarang($data[$x]['B']);
$barang->setIdKategori("" . $kategori);
$barang->setStock($data[$x]['D']);
$barang->setIdKemasan("" . $kemasan);
$barang->setIdProdusen("" . $produsen);
$barang->setDescription($data[$x]['G']);
$barang->save();
}
}
unlink($inputFileName);
$this->getUser()->setFlash('notice', $notice . ' You can add another one below.');
$this->redirect('@barang');
} catch (Exception $e) {
die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());
}
}
}
/**
* Populates the object using an array.
*
* This is particularly useful when populating an object from one of the
* request arrays (e.g. $_POST). This method goes through the column
* names, checking to see whether a matching key exists in populated
* array. If so the setByName() method is called for that column.
*
* You can specify the key type of the array by additionally passing one
* of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
* BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
* The default key type is the column's BasePeer::TYPE_PHPNAME
*
* @param array $arr An array to populate the object from.
* @param string $keyType The type of keys the array uses.
* @return void
*/
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = KategoriPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setNamaKategori($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setKeterangan($arr[$keys[2]]);
}
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @return Kategori[]
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(KategoriPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(KategoriPeer::DATABASE_NAME);
$criteria->add(KategoriPeer::ID, $pks, Criteria::IN);
$objs = KategoriPeer::doSelect($criteria, $con);
}
return $objs;
}