public function load(ObjectManager $manager)
{
$sql = 'select id, cuenta_id, fecha, monto from cobro order by cuenta_id';
$username = DataFixturesConstants::DBUSER;
$password = DataFixturesConstants::DBPASS;
$database = DataFixturesConstants::DBSCHEMA;
return;
$conn = new \PDO(sprintf('mysql:host=localhost;dbname=%s', $database), $username, $password, array(\PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
$stmt = $conn->prepare($sql);
$stmt->execute();
$metadata = $manager->getClassMetaData(get_class(new Cobro()));
$metadata->setIdGeneratorType(\Doctrine\ORM\Mapping\ClassMetadata::GENERATOR_TYPE_NONE);
$cuenta = null;
$cuentaId = null;
while ($row = $stmt->fetch()) {
// Adding cobro
$cobro = new Cobro();
$cobro->setId($row['id']);
$fecha = $row['fecha'];
if ($fecha) {
$cobro->setFecha(new \DateTime($fecha));
}
$cobro->setMonto($row['monto']);
if ($cuentaId != $row['cuenta_id']) {
$cuenta = $manager->getRepository('AppBundle:Cuenta')->find($row['cuenta_id']);
}
$cobro->setCuenta($cuenta);
$manager->persist($cobro);
}
$manager->flush();
}
public function addCobroToCuenta(Cuenta $cuenta, $amount, \DateTime $paymentDate)
{
$cobro = new Cobro();
$cobro->setMonto($amount);
$cobro->setFecha($paymentDate);
$cobro->setCuenta($cuenta);
$cuenta->setPago($cuenta->getPago() + $amount);
$this->em->persist($cobro);
$this->em->persist($cuenta);
$this->em->flush();
}