/**
* Export the sample data
*/
public function dataexportAction()
{
$dsn = Shineisp_Main::getDSN();
$conn = Doctrine_Manager::connection($dsn, 'doctrine');
$conn->execute('SHOW TABLES');
# Lazy loading of the connection. If I execute a simple command the connection to the database starts.
$conn->setAttribute(Doctrine::ATTR_USE_NATIVE_ENUM, true);
$conn->setCharset('UTF8');
// clean up the fixture directory
Shineisp_Commons_Utilities::delTree(APPLICATION_PATH . "/configs/data/fixtures/");
@mkdir(APPLICATION_PATH . "/configs/data/fixtures/");
// Set the current connection
$manager = Doctrine_Manager::getInstance()->setCurrentConnection('doctrine');
if ($conn->isConnected()) {
#Doctrine_Core::dumpData(APPLICATION_PATH . "/configs/data/fixtures/", false);
$export = new Doctrine_Data_Export(APPLICATION_PATH . "/configs/data/fixtures/");
$export->setFormat('yml');
$export->setModels(array());
$export->exportIndividualFiles(true);
$export->doExport();
}
die('done');
}
/**
* deleteAction
* Delete a record previously selected by the service
* @return unknown_type
*/
public function deleteAction()
{
$files = new Files();
$id = $this->getRequest()->getParam('id');
if (is_numeric($id)) {
if (file_exists(PUBLIC_PATH . "/documents/{$id}")) {
Shineisp_Commons_Utilities::delTree(PUBLIC_PATH . "/documents/{$id}");
}
$this->services->find($id)->delete();
}
return $this->_helper->redirector('index', 'services');
}
/**
* massdelete
* delete the customer selected
* @param array
* @return Boolean
*/
public static function bulk_delete($customers)
{
$retval = Doctrine_Query::create()->delete()->from('Customers c')->whereIn('c.customer_id', $customers)->addWhere("c.isp_id = ?", Isp::getCurrentId())->execute();
foreach ($customers as $customerid) {
CustomersDomainsRegistrars::del($customerid);
Orders::DeleteByCustomerID($customerid);
Shineisp_Commons_Utilities::delTree(PUBLIC_PATH . "/documents/orders/{$customerid}");
// Delete the orders files
}
return $retval;
}
/**
* deleteAction
* Delete a record previously selected by the order
* @return unknown_type
*/
public function deleteAction()
{
$files = new Files();
$id = $this->getRequest()->getParam('id');
try {
if (is_numeric($id)) {
// Delete all the files attached
Shineisp_Commons_Utilities::delTree(PUBLIC_PATH . "/documents/orders/{$id}/");
Orders::DeleteByID($id);
}
} catch (Exception $e) {
die($e->getMessage() . " " . $e->getTraceAsString());
}
return $this->_helper->redirector('index', 'orders');
}
