private function load() { $this->firstDate = str_replace("/", "-", $this->getFirstDate()); if (strlen($this->firstDate) == 8) { // fecha con year en formato corto list($mm, $dd, $yy) = split("-", $this->firstDate); $this->firstDate = "{$dd}-{$mm}-20{$yy}"; $time = strtotime($this->firstDate); $this->firstDate = date("d/m/Y", $time); } $this->lastDate = str_replace("/", "-", $this->getLastDate()); if (strlen($this->lastDate) == 8) { // fecha con year en formato corto list($mm, $dd, $yy) = split("-", $this->lastDate); $this->lastDate = "{$dd}-{$mm}-20{$yy}"; $time = strtotime($this->lastDate); $this->lastDate = date("d/m/Y", $time); $mmCotizacion = $mm; $yyCotizacion = "20" . $yy; } $this->totalAmount = number_format($this->getTotalSales() * bob2usd(PRECIO, $mmCotizacion, $yyCotizacion), 2); $this->totalDetails = $this->getTotalDetails(); $this->dateReport = str_replace("/", "-", $this->getDateReport()); $time = strtotime($this->dateReport); $this->dateReport = date("d/m/Y", $time); // list ($dd,$mm,$yyyy) = split("/", $this->dateReport); $this->update(); }
private function load() { $this->firstDate = str_replace("/", "-", $this->getFirstDate()); if (strlen($this->firstDate) == 8) { // fecha con year en formato corto list($mm, $dd, $yy) = split("-", $this->firstDate); $this->firstDate = "{$dd}-{$mm}-20{$yy}"; $time = strtotime($this->firstDate); $this->firstDate = date("d/m/Y", $time); } $this->lastDate = str_replace("/", "-", $this->getLastDate()); if (strlen($this->lastDate) == 8) { // fecha con year en formato corto list($mm, $dd, $yy) = split("-", $this->lastDate); $this->lastDate = "{$dd}-{$mm}-20{$yy}"; $time = strtotime($this->lastDate); $this->lastDate = date("d/m/Y", $time); $mmCotizacion = $mm; $yyCotizacion = "20" . $yy; } $this->totalDetails = $this->getTotalDetails(); $this->dateReport = str_replace("/", "-", $this->getDateReport()); $time = strtotime($this->dateReport); $this->dateReport = date("d/m/Y", $time); list($dd, $mm, $yyyy) = split("/", $this->dateReport); $sql = "SELECT id,idWarner,nombre,autor,comprar,regalar,descargar FROM admins.warner_detail_tones WHERE reportId='{$this->reportId}' "; $rs = mysql_query($sql, $this->dbc->db); if (!$rs) { // error querying db echo "error db ({$sql}):" . mysql_error($this->dbc) . ""; } while ($obj = mysql_fetch_object($rs)) { $this->operationType = $this->getOperationType(); $this->saleType = $this->getSaleType(); $this->distributionChannel = $this->getDistributionChannel(); $this->originalProductCode = ""; $this->artist = $obj->autor; $this->title = $obj->nombre; $this->productCode = $this->getGridCode(); if ($this->productCode == "") { $this->productCode = getGrid($this->title); } // if ($this->productCode == "") echo "$this->title\n"; $this->totalSoldUnits = $obj->comprar; $precio_sin_impuestos = PRECIO - PRECIO * 0.18; $this->priceClient = number_format(bob2usd($precio_sin_impuestos, $mmCotizacion, $yyCotizacion), 4); $precio_warner_sin_impuestos = $precio_sin_impuestos * 0.5; $this->priceDSPMSP = number_format(bob2usd($precio_warner_sin_impuestos, $mmCotizacion, $yyCotizacion), 4); $this->aditionalIncome = 0; $this->revenue = 0; // warner revenue, 50% $this->chargingEntity = $this->DSPMSP; $this->DSPMSPName = "Wazzup"; $this->DSPMSPCountry = "UY"; $this->clientCountry = "BO"; $this->priceLevel = "STD"; $this->currencyCode = "USD"; $this->save(); $string = $this->DSPMSP . "\t" . $this->dateReport . "\t" . $this->firstDate . "\t" . $this->lastDate . "\t" . $this->operationType . "\t" . $this->saleType . "\t" . $this->distributionChannel . "\t" . $this->originalProductCode . "\t" . $this->productCode . "\t" . $this->artist . "\t" . $this->title . "\t" . $this->totalSoldUnits . "\t" . $this->priceClient . "\t" . $this->priceDSPMSP . "\t" . $this->aditionalIncome . "\t" . $this->revenue . "\t" . $this->chargingEntity . "\t" . $this->DSPMSPName . "\t" . $this->DSPMSPCountry . "\t" . $this->clientCountry . "\t" . $this->priceLevel . "\t" . $this->currencyCode . "\n"; $this->detailDIP .= $string; } }