/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aDonor !== null) {
if ($this->aDonor->isModified() || $this->aDonor->isNew()) {
$affectedRows += $this->aDonor->save($con);
}
$this->setDonor($this->aDonor);
}
if ($this->aGiftTypeRelatedByGiftType !== null) {
if ($this->aGiftTypeRelatedByGiftType->isModified() || $this->aGiftTypeRelatedByGiftType->isNew()) {
$affectedRows += $this->aGiftTypeRelatedByGiftType->save($con);
}
$this->setGiftTypeRelatedByGiftType($this->aGiftTypeRelatedByGiftType);
}
if ($this->aCampaign !== null) {
if ($this->aCampaign->isModified() || $this->aCampaign->isNew()) {
$affectedRows += $this->aCampaign->save($con);
}
$this->setCampaign($this->aCampaign);
}
if ($this->aFund !== null) {
if ($this->aFund->isModified() || $this->aFund->isNew()) {
$affectedRows += $this->aFund->save($con);
}
$this->setFund($this->aFund);
}
if ($this->isNew()) {
$this->modifiedColumns[] = DonationPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = DonationPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += DonationPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
if ($error) {
print "<p>" . _("Error: ") . $error . "</p>";
} else {
// Let's analyze this file
if (($handle = fopen($uploadfile, "r")) !== FALSE) {
$row = 0;
while (($data = fgetcsv($handle)) !== FALSE) {
$Fund = new Fund();
$funds = $Fund->allAsArray();
// Convert to UTF-8
$data = array_map(function ($row) {
return mb_convert_encoding($row, 'UTF-8');
}, $data);
$Fund->fundCode = array_values($data)['0'];
$Fund->shortName = array_values($data)['1'];
$Fund->save();
$row++;
}
print "<h2>" . _("Results") . "</h2>";
print "<p> {$row} " . _("rows have been processed.") . "</p>";
}
}
} else {
?>
<form enctype="multipart/form-data" action="importFunds.php" method="post" id="importForm">
<div id='div_updateForm'>
<div class='formTitle' style='width:245px;'><b>Import Funds</b></div><br/>
<label for="uploadFile">Select File</label>
<input type="file" name="uploadFile" id="uploadFile"/><br/><br/>
<input type="submit" name="submit" value='<?php
echo _("import");
<?php
$fundID = $_POST['fundID'];
$fundCode = $_POST['fundCode'];
$shortName = $_POST['shortName'];
$archived = $_POST['archived'];
if ($fundID != '') {
$instance = new Fund(new NamedArguments(array('primaryKey' => $fundID)));
} else {
$instance = new Fund();
}
$instance->fundCode = $fundCode;
$instance->shortName = $shortName;
if ($archived == 'true') {
$archived = 1;
} else {
$archived = 0;
}
$instance->archived = $archived;
try {
$instance->save();
} catch (Exception $e) {
echo $e->getMessage();
}