public function run()
{
//////////////////////////////////////////////////////////////////////////////////
// new row should be added at the bottom. do no insert in between ///////////
///////////////////////////////////////////////////////////////////////////////
DB::table('lat_long_area')->truncate();
LatLongDetails::create(array('area' => 'Sholinganallur', 'lat' => 12.894712, 'long' => 80.230402));
LatLongDetails::create(array('area' => 'Karapakam', 'lat' => 12.918059, 'long' => 80.229844));
LatLongDetails::create(array('area' => 'Navallur', 'lat' => 12.847677, 'long' => 80.224925));
LatLongDetails::create(array('area' => 'Kumaran Nagar', 'lat' => 12.876499, 'long' => 80.22698));
LatLongDetails::create(array('area' => 'Chemencherry', 'lat' => 12.858658, 'long' => 80.23048799999999));
LatLongDetails::create(array('area' => 'Ogiyyam Thoraipakkam', 'lat' => 12.945899, 'long' => 80.23936999999999));
LatLongDetails::create(array('area' => 'Mettukuppam', 'lat' => 12.939925, 'long' => 80.23596000000001));
LatLongDetails::create(array('area' => 'PTC', 'lat' => 12.933609, 'long' => 80.232879));
LatLongDetails::create(array('area' => 'Thoraipakkam', 'lat' => 12.951943, 'long' => 80.241434));
LatLongDetails::create(array('area' => 'Perungudi', 'lat' => 12.968241, 'long' => 80.241984));
LatLongDetails::create(array('area' => 'Neelankarai', 'lat' => 12.948612, 'long' => 80.254546));
LatLongDetails::create(array('area' => 'kottivakkam', 'lat' => 12.969478, 'long' => 80.258962));
LatLongDetails::create(array('area' => 'thiruvanmayur', 'lat' => 12.983187, 'long' => 80.25997599999999));
LatLongDetails::create(array('area' => 'adayar', 'lat' => 13.006565, 'long' => 80.25748299999999));
LatLongDetails::create(array('area' => 'Besant Nagar', 'lat' => 12.999359, 'long' => 80.26797999999999));
LatLongDetails::create(array('area' => 'pallavakkam', 'lat' => 12.962583, 'long' => 80.256863));
LatLongDetails::create(array('area' => 'Medavakkam', 'lat' => 12.920203, 'long' => 80.186015));
LatLongDetails::create(array('area' => 'Perumbakkam', 'lat' => 12.898582, 'long' => 80.199358));
Masterdata::create(array('name' => 'Incident', 'type' => 'Complaint', 'active' => 1));
}
public function run()
{
//////////////////////////////////////////////////////////////////////////////////
// new row should be added at the bottom. do no insert in between ///////////
///////////////////////////////////////////////////////////////////////////////
DB::table('master_data')->truncate();
Masterdata::create(array('name' => 'New Connection', 'type' => 'ticket_type', 'active' => 1));
Masterdata::create(array('name' => 'Complaint', 'type' => 'ticket_type', 'active' => 1));
Masterdata::create(array('name' => 'Open', 'type' => 'ticket_status', 'active' => 1));
Masterdata::create(array('name' => 'Closed', 'type' => 'ticket_status', 'active' => 1));
Masterdata::create(array('name' => 'Processing', 'type' => 'ticket_status', 'active' => 1));
Masterdata::create(array('name' => 'Invalid', 'type' => 'ticket_status', 'active' => 1));
Masterdata::create(array('name' => 'Trash', 'type' => 'ticket_status', 'active' => 1));
Masterdata::create(array('name' => 'Urgent', 'type' => 'ticket_priority', 'active' => 1));
Masterdata::create(array('name' => 'High', 'type' => 'ticket_priority', 'active' => 1));
Masterdata::create(array('name' => 'Medium', 'type' => 'ticket_priority', 'active' => 1));
Masterdata::create(array('name' => 'Low', 'type' => 'ticket_priority', 'active' => 1));
Masterdata::create(array('name' => 'Chennai', 'type' => 'city', 'active' => 1));
Masterdata::create(array('name' => 'OFAPL', 'type' => 'document_type', 'active' => 1));
Masterdata::create(array('name' => 'OFPHO', 'type' => 'document_type', 'active' => 1));
Masterdata::create(array('name' => 'OFPOI', 'type' => 'document_type', 'active' => 1));
Masterdata::create(array('name' => 'OFPOA', 'type' => 'document_type', 'active' => 1));
Masterdata::create(array('name' => 'fiber', 'type' => 'customer_activation_process', 'active' => 1));
Masterdata::create(array('name' => 'splicing', 'type' => 'customer_activation_process', 'active' => 1));
Masterdata::create(array('name' => 'ethernet', 'type' => 'customer_activation_process', 'active' => 1));
Masterdata::create(array('name' => 'HUT boxes', 'type' => 'customer_activation_process', 'active' => 1));
Masterdata::create(array('name' => 'configuration', 'type' => 'customer_activation_process', 'active' => 1));
Masterdata::create(array('name' => 'Sholinganaloor', 'type' => 'area', 'active' => 1));
Masterdata::create(array('name' => 'Karapakam', 'type' => 'area', 'active' => 1));
Masterdata::create(array('name' => 'Navallur', 'type' => 'area', 'active' => 1));
Masterdata::create(array('name' => 'Kumaran nager', 'type' => 'area', 'active' => 1));
Masterdata::create(array('name' => 'Chemencherry', 'type' => 'area', 'active' => 1));
Masterdata::create(array('name' => 'NewConnections Pre Request', 'type' => 'ticket_type', 'active' => 1));
Masterdata::create(array('name' => 'Technical Complaint', 'type' => 'Complaint', 'active' => 1));
Masterdata::create(array('name' => 'Billing Complaint', 'type' => 'Complaint', 'active' => 1));
}