private function getDatabase()
{
$conn = new ConnectionFactory($this->app);
$manager = new DatabaseManager($this->app, $conn);
$manager->setDefaultConnection('sqlite');
return array($conn, $manager);
}
/**
* updates Activity Document Link
* @param array $documentLink
* @param ActivityDocumentLink $activityDocumentLink
* @return bool
*/
public function update(array $documentLink, ActivityDocumentLink $activityDocumentLink)
{
try {
$this->database->beginTransaction();
$documentLinkExists = $activityDocumentLink->exists;
$activityId = $activityDocumentLink->activity_id;
$documentManager = app(DocumentManager::class);
if ($documentLinkExists) {
$url = $activityDocumentLink->document_link['url'];
$document = $documentManager->getDocument(session('org_id'), $url);
$activities = (array) $document->activities;
unset($activities[$activityId]);
$document->activities = $activities;
$documentManager->update($document);
}
$url = $documentLink[0]['url'];
$document = $documentManager->getDocument(session('org_id'), $url);
$activities = (array) $document->activities;
$identifier = $activityDocumentLink->activity->identifier['activity_identifier'];
$activities[$activityId] = $identifier;
$document->activities = $activities;
$documentManager->update($document);
$this->DocumentLinkRepo->update($documentLink, $activityDocumentLink);
$this->database->commit();
$this->logger->info(sprintf('Activity Document Link %s!', $documentLinkExists ? 'updated' : 'saved'), ['for' => $documentLink]);
$this->dbLogger->activity(sprintf("activity.document_link_%s", $documentLinkExists ? 'updated' : 'saved'), ['activity_id' => $activityDocumentLink->activity_id, 'document_link_id' => $activityDocumentLink->id, 'organization' => $this->auth->user()->organization->name, 'organization_id' => $this->auth->user()->organization->id]);
return true;
} catch (\Exception $exception) {
$this->database->rollback();
$this->logger->error($exception, ['documentLink' => $documentLink]);
}
return false;
}
public function testCreateSecondaryIndex()
{
$cluster = new \CouchbaseCluster('127.0.0.1');
$clusterManager = $cluster->manager('Administrator', 'Administrator');
$clusterManager->createBucket($this->bucket, ['bucketType' => 'couchbase', 'saslPassword' => '', 'flushEnabled' => true]);
sleep(5);
/** @var \Ytake\LaravelCouchbase\Database\CouchbaseConnection $connection */
$connection = $this->databaseManager->connection('couchbase');
$bucket = $connection->openBucket($this->bucket);
$bucket->manager()->createN1qlPrimaryIndex();
sleep(4);
$output = new \Symfony\Component\Console\Output\BufferedOutput();
$this->command->run(new \Symfony\Component\Console\Input\ArrayInput(['bucket' => $this->bucket, 'name' => 'testing_gsi', 'fields' => ['params1', 'params2']]), $output);
$fetch = $output->fetch();
$this->assertSame("created SECONDARY INDEX [testing_gsi] fields [params1,params2], for [index_testing] bucket.", trim($fetch));
/** @var \Ytake\LaravelCouchbase\Database\CouchbaseConnection $connection */
$connection = $this->databaseManager->connection('couchbase');
$bucket = $connection->openBucket($this->bucket);
$indexes = $bucket->manager()->listN1qlIndexes();
foreach ($indexes as $index) {
if (!$index->isPrimary && $index->keyspace === 'keyspace') {
$this->assertSame("testing_gsi", $index->name);
$this->assertInstanceOf('CouchbaseN1qlIndex', $index);
}
}
$bucket->manager()->dropN1qlPrimaryIndex();
$bucket->manager()->dropN1qlIndex('testing_gsi');
$clusterManager->removeBucket($this->bucket);
}
public function __construct(UserRepositoryInterface $users, DatabaseManager $db, Encrypter $encrypter)
{
$this->users = $users;
$this->encrypter = $encrypter;
$this->table = Config::get('authentify::auth_tokens.table');
parent::__construct($db->connection());
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$series = $this->argument('series');
$data = json_decode($this->filesystem->get(base_path('resources/assets/json/' . $series . '_full.json')));
$series = $this->series->create((array) $data);
$this->db->table('cards')->whereNull('series_id')->update(['series_id' => $series->id]);
}
/**
* Register the service provider.
*
* @return void
*/
public function register()
{
$this->init();
$this->app->singleton('Larapress\\Services\\Helpers', function () {
return new Helpers($this->app['config'], $this->app['translator'], $this->app['view'], $this->app['Larapress\\Interfaces\\MockablyInterface'], $this->app->make('log')->getMonolog(), $this->app['request'], $this->app['session.store'], $this->db->connection($this->defaultDbConnection), $this->app['redirect'], $this->app['Illuminate\\Support\\Facades\\Response'], $this->app['app'], $this->app['Carbon\\Carbon']);
});
}
/**
* upload activity form csv
* @param $activityCsv
* @param $organization
* @param $defaultFieldValues
* @return bool
*/
public function save($activityCsv, $organization, $defaultFieldValues)
{
try {
$excel = $this->version->getExcel();
$activitiesRows = $excel->load($activityCsv)->get();
$activityDetails = [];
foreach ($activitiesRows as $activityRow) {
$activityDetails[] = $this->uploadActivityRepo->formatFromExcelRow($activityRow, $organization->id);
}
$identifiers = $this->uploadActivityRepo->getIdentifiers($organization->id);
$this->database->beginTransaction();
$data = [];
foreach ($activityDetails as $activityDetail) {
$activityIdentifier = $activityDetail['identifier']['activity_identifier'];
isset($identifiers[$activityIdentifier]) ? $data[$identifiers[$activityIdentifier]] = $activityDetail : $this->uploadActivityRepo->upload($activityDetail, $organization, $defaultFieldValues);
$this->database->commit();
}
if (count($data) > 0) {
return view('Activity.confirmUpdate')->withData($data);
}
$this->logger->info("Activities Uploaded for organization with id:" . $organization->id);
$this->dbLogger->activity("activity.activity_uploaded", ['organization_id' => $organization->id]);
return true;
} catch (Exception $exception) {
$this->database->rollback();
$this->logger->error($exception, ['activity' => $activityDetails]);
}
return false;
}
/**
* Builder constructor.
* @param DatabaseManager $databaseManager
* @param AppConfig $appConfig
*/
public function __construct(DatabaseManager $databaseManager, AppConfig $appConfig)
{
$this->manager = $databaseManager->connection()->getDoctrineSchemaManager();
$this->appConfig = $appConfig;
$this->tablePrefix = $databaseManager->connection() - getTablePrefix();
$this->registerUserTypes();
}
/**
* @param MethodInvocation $invocation
*
* @return object
* @throws \Exception
*/
public function invoke(MethodInvocation $invocation)
{
/** @var \Illuminate\Database\ConnectionInterface $database */
$annotation = $invocation->getMethod()->getAnnotation($this->annotation);
$connection = $annotation->value;
$database = self::$databaseManager->connection($connection);
$database->beginTransaction();
try {
$result = $invocation->proceed();
$database->commit();
} catch (\Exception $exception) {
// for default Exception
if ($exception instanceof QueryException) {
$database->rollBack();
throw $exception;
}
if ($exception instanceof $annotation->expect) {
$database->rollBack();
throw $exception;
}
$database->rollBack();
throw $exception;
}
return $result;
}
public function delete()
{
$data = $this->request->get('data');
$id_string = $data['id_string'];
$this->db->table("widgets")->where("id_string", $id_string)->delete();
$this->db->table("sidebar_widget")->where("id_string", $id_string)->delete();
}
/**
* Execute the console command
*/
public function fire()
{
/** @var \Illuminate\Database\Connection|CouchbaseConnection $connection */
$connection = $this->databaseManager->connection($this->option('database'));
if ($connection instanceof CouchbaseConnection) {
$bucket = $connection->openBucket($this->argument('bucket'));
$primary = self::PRIMARY_KEY;
try {
$bucket->manager()->createN1qlPrimaryIndex($primary, $this->option('ignore'), $this->option('defer'));
$this->info("created PRIMARY INDEX [{$primary}] for [{$this->argument('bucket')}] bucket.");
} catch (\Exception $e) {
$this->error($e->getMessage());
}
foreach ($this->secondaryIndexes as $name => $fields) {
try {
$bucket->manager()->createN1qlIndex($name, $fields, '', $this->option('ignore'), $this->option('defer'));
$field = implode(",", $fields);
$this->info("created SECONDARY INDEX [{$name}] fields [{$field}], for [{$this->argument('bucket')}] bucket.");
} catch (\Exception $e) {
$this->error($e->getMessage());
}
}
}
return;
}
/**
* @inheritdoc
*/
public function process(EloquentModel $model, Config $config)
{
$schemaManager = $this->databaseManager->connection()->getDoctrineSchemaManager();
$prefix = $this->databaseManager->connection()->getTablePrefix();
if (!$schemaManager->tablesExist($prefix . $model->getTableName())) {
throw new GeneratorException(sprintf('Table %s does not exist', $prefix . $model->getTableName()));
}
}
public function __construct(Factory $event_snapshot_factory, Builder $stream_builder, DatabaseManager $manager, $table, $stream_table)
{
$this->event_snapshot_factory = $event_snapshot_factory;
$this->stream_builder = $stream_builder;
$this->connection = $manager->connection();
$this->table = $table;
$this->stream_table = $stream_table;
}
public function __construct(DatabaseManager $DB, AuthenticationManagementInterface $AuthenticationManager, Translator $Lang)
{
// $this->DB = $DB;
// $this->DB->connection()->enableQueryLog();
$this->Database = $DB->connection($AuthenticationManager->getCurrentUserOrganizationConnection())->table('ACCT_Period AS p')->join('ACCT_Fiscal_Year AS f', 'f.id', '=', 'p.fiscal_year_id')->where('p.organization_id', '=', $AuthenticationManager->getCurrentUserOrganizationId())->whereNull('p.deleted_at');
$this->visibleColumns = array('p.id AS acct_pm_id', 'p.month as acct_pm_month', 'p.start_date as acct_pm_start_date', 'p.end_date as acct_pm_end_date', 'p.is_closed as acct_pm_is_closed', 'f.year as acct_pm_year');
$this->orderBy = array(array('acct_pm_year', 'desc'), array('acct_pm_month', 'asc'));
}
public function __construct(DatabaseManager $DB, AuthenticationManagementInterface $AuthenticationManager)
{
// $this->DB = $DB;
// $this->DB->connection()->enableQueryLog();
$this->Database = $DB->connection($AuthenticationManager->getCurrentUserOrganizationConnection())->table('ACCT_Fiscal_Year AS f')->where('f.organization_id', '=', $AuthenticationManager->getCurrentUserOrganizationId())->whereNull('f.deleted_at');
$this->visibleColumns = array('f.id AS acct_cfy_id', 'f.year AS acct_cfy_year', 'f.start_date AS acct_cfy_start_date', 'f.end_date AS acct_cfy_end_date');
$this->orderBy = array(array('acct_cfy_id', 'asc'));
}
/**
* @param $year
* @param $month
* @return \Illuminate\View\View
*/
public function archive($year, $month)
{
$data = $this->getOverviewData();
$posts = $this->post->forPublic()->where($this->db->raw('MONTHNAME(publish_date)'), '=', $month)->where($this->db->raw('YEAR(publish_date)'), '=', $year)->orderBy('publish_date', 'DESC')->paginate($this->config->items_per_page);
$data['posts'] = $this->dateFormat($posts);
$data['headings'] = "All posts from <strong>" . $month . " " . $year . "</strong>";
return view('blogify.index', $data);
}
/**
* Return information about a scope
*
* @param string $scope
* @param string $grantType
* @param string $clientId
* @return ScopeEntity
*/
public function get($scope, $grantType = null, $clientId = null)
{
$result = $this->db->table('oauth_scopes')->where('id', $scope)->get();
if (count($result) === 0) {
return;
}
return (new ScopeEntity($this->server))->hydrate(['id' => $result->id, 'description' => $result->description]);
}
public function __construct(DatabaseManager $DB, AuthenticationManagementInterface $AuthenticationManager, AccountManagementInterface $AccountManager, Translator $Lang, Carbon $Carbon)
{
$this->DB = $DB;
$this->AccountManager = $AccountManager;
$this->AuthenticationManager = $AuthenticationManager;
$this->Carbon = $Carbon;
$this->Database = $DB->connection($AuthenticationManager->getCurrentUserOrganizationConnection())->table('ACCT_Journal_Entry AS je')->join('ACCT_Account AS c', 'je.account_id', '=', 'c.id')->join('ACCT_Journal_Voucher AS jv', 'jv.id', '=', 'je.journal_voucher_id')->leftJoin('PURCH_Document_Type AS dt', 'dt.id', '=', 'jv.document_type_id')->leftJoin('PURCH_Supplier AS ps', 'ps.id', '=', 'jv.supplier_id')->leftJoin('SALE_Client AS cl', 'cl.id', '=', 'jv.client_id')->leftJoin('HR_Employee AS e', 'e.id', '=', 'jv.employee_id')->join('ACCT_Voucher_Type AS vt', 'vt.id', '=', 'jv.voucher_type_id')->where('jv.organization_id', '=', $AuthenticationManager->getCurrentUserOrganizationId())->where('c.is_group', '=', 0)->where('jv.status', '=', 'B')->whereNull('je.deleted_at')->whereNull('jv.deleted_at')->select(array('jv.date', 'jv.number', 'jv.remark', 'jv.manual_reference', 'vt.name AS voucher_type_name', 'jv.document_date', 'jv.document_number', 'jv.document_amount', 'dt.name AS document_type_name', $DB->raw('CONCAT(e.names, \' \', e.surnames) AS employee_name'), 'e.tax_id as employee_tax_id', 'e.single_identity_document_number as employee_single_identity_document_number', 'ps.name as supplier_name', 'ps.registration_number AS supplier_registration_number', 'ps.tax_id as supplier_tax_id', 'ps.single_identity_document_number as supplier_single_identity_document_number', 'cl.name as client_name', 'cl.registration_number AS client_registration_number', 'cl.tax_id as client_tax_id', 'cl.single_identity_document_number as client_single_identity_document_number', 'c.key AS account_key', 'c.name AS account_name', 'je.debit', 'je.credit'));
$this->orderBy = array(array('jv.document_date', 'asc'));
}
/**
* fire.
*
* @method fire
*/
public function fire()
{
$connection = $this->databaseManager->connection();
$connection->setFetchMode(PDO::FETCH_ASSOC);
$query = $this->option('command');
$rows = $connection->select($query);
$headers = array_keys(Arr::get($rows, 0, []));
$this->table($headers, $rows);
}
/**
* {@inheritdoc}
*/
public function validate()
{
$check = $this->database->table('captcha')->where('imagehash', '=', $this->request->get('imagehash'))->where('imagestring', '=', $this->request->get('imagestring'));
if ($check->count() != 1) {
$this->database->table('captcha')->where('imagehash', '=', $this->request->get('imagehash'))->delete();
return false;
}
return true;
}
/**
* @param DatabaseManager $databaseManager
*/
function __construct(DatabaseManager $databaseManager)
{
$db_versions = $databaseManager->table('versions')->get();
$versions = [];
foreach ($db_versions as $ver) {
$versions[$ver->version] = $ver->version;
}
$this->versions = $versions;
}
public function run()
{
if ($this->truncate) {
$this->db->connection()->table($this->getTableName())->truncate();
}
foreach ($this->seeds as $seed) {
$this->getModelInstance()->create($seed);
}
}
/**
* Return a description for each table.
*
* @return \Generator
*/
public function tables()
{
$schema = $this->db->connection()->getDoctrineConnection()->getSchemaManager();
$tables = $schema->listTableNames();
foreach ($tables as $table) {
$columns = $this->describer->describe($table);
(yield compact('table', 'columns'));
}
}
public function __construct(DatabaseManager $DB, AuthenticationManagementInterface $AuthenticationManager, Translator $Lang)
{
// $this->DB = $DB;
// $this->DB->connection()->enableQueryLog();
$this->Database = $DB->connection($AuthenticationManager->getCurrentUserOrganizationConnection())->table('ACCT_Cost_Center AS c')->leftJoin('ACCT_Cost_Center AS cp', 'cp.id', '=', 'c.parent_cc_id')->where('c.organization_id', '=', $AuthenticationManager->getCurrentUserOrganizationId())->whereNull('c.deleted_at');
$this->visibleColumns = array('c.id AS acct_ccm_id', 'c.key as acct_ccm_key', 'c.name as acct_ccm_name', 'c.is_group as acct_ccm_is_group', 'cp.id as acct_ccm_parent_cc_id', 'cp.key as acct_ccm_parent_key', 'cp.name as acct_ccm_parent_cc', $DB->raw('CASE c.is_group WHEN 1 THEN 0 ELSE 1 END AS acct_ccm_is_leaf'));
$this->orderBy = array(array('acct_ccm_key', 'asc'));
$this->treeGrid = true;
$this->parentColumn = 'cp.id';
$this->leafColumn = 'acct_ccm_is_leaf';
}
/**
* Execute the console command
*/
public function fire()
{
/** @var \Illuminate\Database\Connection|CouchbaseConnection $connection */
$connection = $this->databaseManager->connection($this->option('database'));
if ($connection instanceof CouchbaseConnection) {
$bucket = $connection->openBucket($this->argument('bucket'));
$bucket->manager()->dropN1qlPrimaryIndex($this->option('name'), $this->option('ignore'));
$this->info("dropped PRIMARY INDEX [{$this->option('name')}] for [{$this->argument('bucket')}] bucket.");
}
return;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$connection = $this->argument('connection');
$name = $this->database->connection($connection)->getDatabaseName();
try {
$this->database->connection($connection)->reconnect();
} catch (\Exception $e) {
return $this->error($e->getMessage());
}
$this->info(sprintf('Connected with database "%s" through connection "%s"', $name, $connection));
}
public function __construct(DatabaseManager $DB, AuthenticationManagementInterface $AuthenticationManager, Translator $Lang)
{
// $this->DB = $DB;
// $this->DB->connection()->enableQueryLog();
$this->Database = $DB->connection($AuthenticationManager->getCurrentUserOrganizationConnection())->table('ACCT_Account AS a')->leftJoin('ACCT_Account AS ap', 'ap.id', '=', 'a.parent_account_id')->join('ACCT_Account_Type AS at', 'at.id', '=', 'a.account_type_id')->where('a.organization_id', '=', $AuthenticationManager->getCurrentUserOrganizationId())->whereNull('a.deleted_at');
$this->visibleColumns = array('a.id AS acct_am_id', 'a.key as acct_am_key', 'a.name as acct_am_name', 'a.balance_type as acct_am_balance_type', 'a.is_group as acct_am_is_group', 'a.account_type_id as acct_am_account_type_id', 'at.name as acct_am_account_type', 'ap.id as acct_am_parent_account_id', 'ap.key as acct_am_parent_key', 'ap.name as acct_am_parent_account', $DB->raw('CASE a.balance_type WHEN "D" THEN "' . $Lang->get('decima-accounting::account-management.D') . '" ELSE "' . $Lang->get('decima-accounting::account-management.A') . '" END AS acct_am_balance_type_name'), $DB->raw('CASE a.is_group WHEN 1 THEN 0 ELSE 1 END AS acct_am_is_leaf'));
$this->orderBy = array(array('acct_am_key', 'asc'));
$this->treeGrid = true;
$this->parentColumn = 'ap.id';
$this->leafColumn = 'acct_am_is_leaf';
}
/**
* Check if given participants are
* in a conversation
*
* @param $participants
* @return mixed
*/
public function inConversation($participants)
{
list($num_user_in_conversation, $valuesEscaped) = $this->getEscapedValues($participants);
// prepare question marks for the query
$questionmarks = str_repeat("?,", $num_user_in_conversation - 1) . "?";
$query = $this->db->select($this->db->raw('select cu.conversation_id, cu.deleted_at
from conversation_joined cu
group by cu.conversation_id, cu.deleted_at
having SUM(cu.participant_id in ( ' . $questionmarks . ' )) = ? and
SUM(cu.participant_id not in ( ' . $questionmarks . ' )) = 0
'), $valuesEscaped);
return $query;
}
/**
* updates username
* @param $userId
* @param UsernameRequest $usernameRequest
* @param DatabaseManager $database
* @return mixed
*/
public function updateUsername($userId, UsernameRequest $usernameRequest, DatabaseManager $database)
{
$input = $usernameRequest->all();
$user = $this->user->findOrFail($userId);
$organization = $this->organization->findOrFail($this->orgId);
$database->beginTransaction();
$organization->user_identifier = $input['organization_user_identifier'];
$user->username = $input['username'];
$user->save();
$organization->save();
$database->commit();
$response = $user->save() && $organization->save() ? ['type' => 'success', 'code' => ['updated', ['name' => 'Username']]] : ['type' => 'danger', 'code' => ['update_failed', ['name' => 'Username']]];
return redirect('user/profile')->withResponse($response);
}
/**
* @param $tables
*/
private function truncateTables($tables)
{
$this->truncatedCount = 0;
foreach ($tables as $table) {
if (!in_array($table, $this->exclude)) {
$this->truncatedCount++;
$this->db->statement('SET FOREIGN_KEY_CHECKS=0;');
$this->db->statement("TRUNCATE TABLE {$table}");
$this->db->statement('SET FOREIGN_KEY_CHECKS=1;');
$this->info("Table {$table} successfully truncated.");
}
}
$this->info("Total table(s) truncated: {$this->truncatedCount}");
}
