/** * @static * @param GitCommand $gitCommand * @param Branch $branch * @param string $lastBranchSynchronizationCommit * @return int 0 if succeed */ public static function synchronize(GitCommand $gitCommand, Branch $branch, $lastBranchSynchronizationCommit = null) { $filesGit = $gitCommand->getDiffFilesFromBranch($branch->getRepository()->getGitDir(), $branch->getCommitReference(), $branch->getLastCommit()); if (count($filesGit) > sfConfig::get('app_max_number_of_files_to_review', 4096)) { return count($filesGit); } $filesModel = FileQuery::create()->filterByBranchId($branch->getId())->find(); if (count($filesModel) > 0) { $diffFilesFromLastSynch = $gitCommand->getDiffFilesFromBranch($branch->getRepository()->getGitDir(), !is_null($lastBranchSynchronizationCommit) ? $lastBranchSynchronizationCommit : $branch->getCommitReference(), $branch->getLastCommit(), false); } foreach ($filesModel as $fileModel) { /** @var $fileModel File */ if (!array_key_exists($fileModel->getFilename(), $filesGit)) { $fileModel->delete(); } else { $lastChangeCommit = $gitCommand->getLastModificationCommit($branch->getRepository()->getGitDir(), $branch->getName(), $fileModel->getFilename()); if (isset($diffFilesFromLastSynch[$fileModel->getFilename()])) { $fileModel->setReviewRequest(true)->setStatus(BranchPeer::A_TRAITER)->setCommitStatusChanged($lastChangeCommit); } else { $fileModel->setReviewRequest(false); } if ($filesGit[$fileModel->getFilename()]['is-binary']) { $fileModel->setIsBinary(true)->setNbAddedLines(0)->setNbDeletedLines(0); } else { $fileModel->setIsBinary(false)->setNbAddedLines($filesGit[$fileModel->getFilename()]['added-lines'])->setNbDeletedLines($filesGit[$fileModel->getFilename()]['deleted-lines']); } $fileModel->setState($filesGit[$fileModel->getFilename()]['state'])->setLastChangeCommit($lastChangeCommit)->setCommitInfos($gitCommand->getCommitInfos($branch->getRepository()->getGitDir(), $lastChangeCommit, "%ce %s"))->setCommitReference($branch->getCommitReference())->save(); } unset($filesGit[$fileModel->getFilename()]); } foreach ($filesGit as $fileGit) { $lastChangeCommit = $gitCommand->getLastModificationCommit($branch->getRepository()->getGitDir(), $branch->getName(), $fileGit['filename']); $file = new File(); if ($fileGit['is-binary']) { $file->setIsBinary(true)->setNbAddedLines(0)->setNbDeletedLines(0); } else { $file->setIsBinary(false)->setNbAddedLines($fileGit['added-lines'])->setNbDeletedLines($fileGit['deleted-lines']); } $file->setFilename($fileGit['filename'])->setStatus(BranchPeer::A_TRAITER)->setState($fileGit['state'])->setBranchId($branch->getId())->setLastChangeCommit($lastChangeCommit)->setCommitInfos($gitCommand->getCommitInfos($branch->getRepository()->getGitDir(), $lastChangeCommit, "%ce %s"))->setCommitReference($branch->getCommitReference())->setReviewRequest(true)->save(); } return 0; }
} } else { if ($_POST['type'] == "delete") { try { $branch = new Branch($_POST['key']); $branch->delete(); } catch (fExpectedException $e) { echo $e->printMessage(); } } else { if ($_POST['type'] == "add") { try { $branch = new Branch(); $branch->populate(); $branch->store(); $theId = $branch->getId(); $ids = Inv_item::findIdUB($db); foreach ($ids as $id) { $stock = new Inv_stock(); $stock->setBranchId($theId); $stock->setItemId($id); $stock->setQuantity(0); $stock->store(); } } catch (fExpectedException $e) { echo $e->printMessage(); } } else { if ($_POST['type'] == "name") { $branch = new Branch($_POST['key']); echo $branch->prepareName();
/** * Filter the query by a related Branch object * * @param Branch|PropelCollection $branch The related object(s) to use as filter * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL * * @return CommentQuery The current query, for fluid interface */ public function filterByBranch($branch, $comparison = null) { if ($branch instanceof Branch) { return $this->addUsingAlias(CommentPeer::BRANCH_ID, $branch->getId(), $comparison); } elseif ($branch instanceof PropelCollection) { if (null === $comparison) { $comparison = Criteria::IN; } return $this->addUsingAlias(CommentPeer::BRANCH_ID, $branch->toKeyValue('PrimaryKey', 'Id'), $comparison); } else { throw new PropelException('filterByBranch() only accepts arguments of type Branch or PropelCollection'); } }
public function executeBulkupload() { if ($this->getRequest()->getFileName('csvfile')) { $fileName = md5($this->getRequest()->getFileName('csvfile') . time() . rand(0, 99999)); $ext = $this->getRequest()->getFileExtension('csvfile'); $this->getRequest()->moveFile('csvfile', sfConfig::get('sf_upload_dir') . "//csvfiles//" . $fileName . ".csv"); $fullname = $fileName . ".csv"; //$fullpath = '/uploads/csvfiles/'.$fullname; $fp = sfConfig::get('sf_upload_dir') . "//csvfiles//" . $fileName . ".csv"; $reader = new sfCsvReader($fp, ',', '"'); $reader->open(); $i = 1; $exist; $ignore; $log; $ignoreflag = 0; $success = 0; while ($data = $reader->read()) { $name[] = array(); $name = explode(' ', $data[0]); $roll = $data[1]; $enrol = $data[2]; $branch = $data[3]; $degree = $data[4]; $year = $data[5]; $c = new Criteria(); $c->add(UserPeer::ENROLMENT, $enrol); $user = UserPeer::doSelectOne($c); if (!$user) { $c = new Criteria(); $c->add(BranchPeer::CODE, $branch); $br = BranchPeer::doSelectOne($c); if (!$br) { $br = new Branch(); $br->setName($branch); $br->setCode($branch); $br->save(); } $c = new Criteria(); $c->add(DegreePeer::NAME, $degree); $dg = DegreePeer::doSelectOne($c); if (!$dg) { $dg = new Degree(); $dg->setName($degree); $dg->save(); } $user = new User(); if ($roll) { $user->setRoll($roll); $user->setRollflag(sfConfig::get('app_defaultprivacy_roll')); } if ($enrol) { $user->setEnrolment($enrol); $user->setEnrolflag(sfConfig::get('app_defaultprivacy_enrol')); } else { $ignoreflag = 1; } if ($year) { $user->setGraduationyear($year); $user->setGraduationyearflag(sfConfig::get('app_defaultprivacy_year')); } $user->setBranchId($br->getId()); $user->setBranchflag(sfConfig::get('app_defaultprivacy_branch')); $user->setDegreeId($dg->getId()); $user->setDegreeflag(sfConfig::get('app_defaultprivacy_degree')); $user->setIslocked(sfConfig::get('app_islocked_unclaimed')); $user->setUsertype(sfConfig::get('app_usertypecode_Alumni')); $lastname = ''; $personal = new Personal(); $name[0] = str_replace('.', '', $name[0]); $personal->setFirstname($name[0]); if ($name[3]) { $name[1] = str_replace('.', '', $name[1]); $name[2] = str_replace('.', '', $name[2]); $name[3] = str_replace('.', '', $name[3]); $midname = $name[1] . " " . $name[2]; $personal->setMiddlename($midname); $personal->setLastname($name[3]); $lastname = $name[3]; } elseif ($name[2]) { $name[1] = str_replace('.', '', $name[1]); $name[2] = str_replace('.', '', $name[2]); $personal->setMiddlename($name[1]); $personal->setLastname($name[2]); $lastname = $name[2]; } elseif ($name[1]) { $name[1] = str_replace('.', '', $name[1]); $personal->setLastname($name[1]); $lastname = $name[1]; } $uname_suffix = $branch . substr($year, -2); if ($lastname) { $username = $name[0] . '.' . $lastname . '@'; } else { $username = $name[0] . '@'; } $temp = 1; $tempusername = $username; while ($this->uniqueuser($tempusername . $uname_suffix)) { $tempusername = $username . $temp; $temp++; } $tempusername = $tempusername . $uname_suffix; $user->setUsername($tempusername); if ($ignoreflag == 0) { $e = $user->save(); $personal->setUserId($user->getId()); $personal->save(); $success++; $log[$i][0] = $e == 1 ? "{$i}) Uploaded Successfully" : $e; $log[$i][1] = $data[0]; } else { $ignore[] = $i; $ignoreflag = 0; $log[$i][0] = "{$i}) NO enrolment number"; $log[$i][1] = $data[0]; } } else { $exist[] = $i; $log[$i][0] = "{$i}) In Database as " . $user->getFullname() . ", " . $user->getBranchname() . " " . $user->getGraduationyear(); $log[$i][1] = $data[0]; } $i++; } // while ($data = $reader->read()) ends here $reader->close(); $this->log = $log; $this->success = $success; $this->ignored = $ignore; $this->exists = $exist; } }
<label for="branch_id">From Branch </label> <?php $fromBranch = new Branch($mattrans->getBranchFrom()); echo $fromBranch->prepareName(); ?> <label for="branch_id"> To Branch </label> <?php $toBranch = new Branch($mattrans->getBranchTo()); echo $toBranch->prepareName(); ?> <br /> <table id="formContent"> <thead> <tr><th>No</th> <th>Item Code</th><th width="300px">Description</th><th>Quantity</th><th>UOM</th><th>Remarks</th><th>In <?php echo $fromBranch->getId(); ?> </th><th width="75px">Receiver</th></tr> </thead> <tbody> <?php $counter = 1; foreach ($mattrans_details as $mattrans_detail) { echo "<tr class=\"jsonRow\"><td>" . $counter . "</td><td class=\"itemCode\">" . $mattrans_detail->prepareItemId() . "<input class=\"itemId\" type=\"hidden\" value=\"" . $mattrans_detail->getId() . "\"></input></td>"; $item = new Inv_item($mattrans_detail->getItemId()); echo "<td>" . $item->prepareDescription() . "</td><td class=\"itemQuan\">" . $mattrans_detail->prepareQuantity() . "</td>\n\t\t\t\t\t\t\t \t<td>" . $item->prepareUnitOfMeasure() . "</td><td>" . $mattrans_detail->prepareRemark() . "</td>"; $tempRecords = Inv_stock::findStockByBranch($mattrans_detail->getItemId(), $mattrans->getBranchFrom()); $quanRow = 0; foreach ($tempRecords as $tempRecord) { $quanRow = $tempRecord->getQuantity(); }
/** * Exclude object from result * * @param Branch $branch Object to remove from the list of results * * @return BranchQuery The current query, for fluid interface */ public function prune($branch = null) { if ($branch) { $this->addUsingAlias(BranchPeer::ID, $branch->getId(), Criteria::NOT_EQUAL); } return $this; }
/** * Declares an association between this object and a Branch object. * * @param Branch $v * @return File The current object (for fluent API support) * @throws PropelException */ public function setBranch(Branch $v = null) { if ($v === null) { $this->setBranchId(NULL); } else { $this->setBranchId($v->getId()); } $this->aBranch = $v; // Add binding for other direction of this n:n relationship. // If this object has already been added to the Branch object, it will not be re-added. if ($v !== null) { $v->addFile($this); } return $this; }