97
Список литературы
1. Автоматизированные информационные технологии в экономике. /Под
ред. Титаренко. М., 2008.
2. Автоматизированные информационные технологии в экономике:
Учебник / М.И. Семенов, И.Т. Трубилин, В.М. Лойко, Т.П. Барановская; Под
общей ред. И.Т. Трубилина. — М.: Финансы и статистика, 2008.
3. Аглицкий И.С. Информационное поле предприятия // Финансовая
газета. 2001, № 45.
4. Баград М. В. О некоторых методологических вопросах классификации
документации. – М.: Инфра-М, 2006.
5. Бобылева М. Этапы внедрения системы автоматизации
документооборота. // Финансовая газета, N 34, август 2005
6. Васильева И. Н. Основы делопроизводства и персональный
менеджмент: Учебное пособие для вузов / ВЗФЭИ. – М.: ЗАО
«Финстатинформ», 2003.
7. Голбан Е. Системы электронного документооборота: управление
отношениями с клиентами. // Финансовая газета. Региональный выпуск, 2008,
№40
8. Громов В. Системы оперативного управления в сфере электронного
документооборота. // Финансовая газета, № 48, ноябрь 2005
9. Замлинский В. А., Дмитриенко М. Ф., Балабушевич Т. А. и др.
Документоведение. Специальные исторические дисциплины: Учеб. Пособие. -
К., 2002.
10. Информационные системы и технологии в экономике: Учебник / под
редакцией профессора В.И. Лойко – М.: Финансы и статистика, 2005
11. Кудряев В.А. Организация работы с документами. - М.:ИНФРА-М,
2008.
12. Миротина Л.Б., Сергеев В.И. Основы логистики. – М.: Инфра-М 2008.
13. Морозова Е.В. Организация систем защиты информации. Принципы,
компоненты, аспекты. М.: Школа охраны «Баярд», 2003.
14. Перелетова И.В. Электронный документооборот. // Ваш консультант, N
12, июнь 2007.
98
15. Теория экономических информационных систем: Учеб. Пособие /
Мишенин А.И. — М.: Финансы и статистика, 2002.
99
Приложение
<?php
require__DIR__.'/../vendor/autoload.php';
$app=require_once__DIR__.'/../bootstrap/app.php';
$kernel=$app->make(Illuminate\Contracts\Http\Kernel::class);
$response=$kernel->handle(
$request=Illuminate\Http\Request::capture()
);
$response->send();
$kernel->terminate($request,$response);
<?php
namespaceApp\Http;
useIlluminate\Foundation\Http\KernelasHttpKernel;
classKernelextendsHttpKernel
{
/**
* The application's global HTTP middleware stack.
*
* These middleware are run during every request to your application.
*
* @var array
*/
protected$middleware=[
\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode::class,
\Illuminate\Foundation\Http\Middleware\ValidatePostSize::class,
\App\Http\Middleware\TrimStrings::class,
\Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull::class,
\App\Http\Middleware\TrustProxies::class,
];
/**
* The application's route middleware groups.
*
* @var array
*/
protected$middlewareGroups=[
'web'=>[
\App\Http\Middleware\EncryptCookies::class,
\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
\Illuminate\Session\Middleware\StartSession::class,
// \Illuminate\Session\Middleware\AuthenticateSession::class,
\Illuminate\View\Middleware\ShareErrorsFromSession::class,
\App\Http\Middleware\VerifyCsrfToken::class,
\Illuminate\Routing\Middleware\SubstituteBindings::class,
],
'api'=>[
'throttle:60,1',
'bindings',
],
];
/**
* The application's route middleware.
*
* These middleware may be assigned to groups or used individually.
*
* @var array
*/
protected$routeMiddleware=[
'auth'=>\Illuminate\Auth\Middleware\Authenticate::class,
'auth.basic'=>\Illuminate\Auth\Middleware\AuthenticateWithBasicAuth::class,
'bindings'=>\Illuminate\Routing\Middleware\SubstituteBindings::class,
'cache.headers'=>\Illuminate\Http\Middleware\SetCacheHeaders::class,
'can'=>\Illuminate\Auth\Middleware\Authorize::class,
'guest'=>\App\Http\Middleware\RedirectIfAuthenticated::class,
'signed'=>\Illuminate\Routing\Middleware\ValidateSignature::class,
100
'throttle'=>\Illuminate\Routing\Middleware\ThrottleRequests::class,
];
}
<?php
namespaceApp\Http\Controllers;
useApp\Building;
useApp\BuildingType;
useIlluminate\Http\Request;
useApp\Http\Requests\BuildingRequest;
useApp\Operation;
useIlluminate\Support\Facades\Auth;
classBuildingControllerextendsController
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
publicfunctionindex()
{
returnview('building.index',['backToFront'=>[
'operations'=>Operation::all(),
'types'=>BuildingType::all()
]]);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
publicfunctioncreate()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
publicfunctionstore(BuildingRequest$request)
{
$toFill=$request->all();
$building=Building::create($toFill);
returnjson_encode(['success'=>true,'added'=>$building]);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
publicfunctionshow($id)
{
//
}
/**
* Обновлениеспецифичноймодели
*
101
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
publicfunctionupdate(BuildingRequest$request,$id)
{
$building=Building::findOrFail($id);
$toFill=$request->all();
$building->fill($toFill);
$building->save();
returnjson_encode(['success'=>true,'updated'=>$building]);
}
/**
* Удаление специфичной модели
*
* @param int $id
* @return \Illuminate\Http\Response
*/
publicfunctiondestroy($id)
{
$building=Building::findOrFail($id);
$building->delete();
returnjson_encode(['success'=>true,'deleted'=>$id]);
}
publicfunctionsearch(Request$request){
$addressField=$request->address_field;
$operationField=$request->operation_field;
$createdAtField=$request->created_at_field;
$typeField=$request->type_field;
$clientField=$request->client_field;
$priceMin=$request->price_min_field;
$priceMax=$request->price_max_field;
$countRoom=$request->count_room_field;
$sqMin=$request->sq_min;
$sqMax=$request->sq_max;
returnBuilding::with('type','operation','client')
->when($addressField,function($query)use($addressField){
return$query->where('address','like','%'.$addressField.'%');
})
->when($operationField,function($query)use($operationField){
return$query->where('operation_id',$operationField);
})
->when($typeField,function($query)use($typeField){
return$query->where('building_type_id',$typeField);
})
->when($createdAtField,function($query)use($createdAtField){
$explodedCreated=explode(',',$createdAtField);
102
switch(count($explodedCreated)){
case2:
return$query->whereBetween('created_at',[$explodedCreated[0],$explodedCreated[1]]);
case1:
return$query->where('created_at','>=',$explodedCreated[0]);
default:
returnfalse;
}
})
->when($clientField,function($query)use($clientField){
$queryTwo="clients.id like '%".$clientField."%' OR "
."clients.f_name like '%".$clientField."%' OR "
."clients.l_name like '%".$clientField."%' OR"
."clients.m_name like '%".$clientField."%'"
."";
return$query->whereExists(function($query)use($queryTwo){
$query->select(DB::raw('id, f_name, l_name, m_name'))
->from('clients')
->whereRaw($queryTwo);
});
})
->when(($sqMin&&$sqMax),function($query)use($sqMin,$sqMax){
return$query
->where(function($query)use($sqMin,$sqMax){
$query->where('sq','<=',$sqMax)
->where('sq','>=',$sqMin);
});
})
->when(($sqMin),function($query)use($sqMin){
return$query->where('sq','>=',$sqMin);
})
->when(($sqMax),function($query)use($sqMax){
return$query->where('sq','<=',$sqMax);
})
->when(($priceMin&&$priceMax),function($query)use($priceMin,$priceMax){
return$query
->where(function($query)use($priceMin,$priceMax){
$query->where('price','<=',$priceMax)
->where('price','>=',$priceMin);
});
})
->when(($priceMin),function($query)use($priceMin){
return$query->where('price','>=',$priceMin);
})
->when(($priceMax),function($query)use($priceMax){
return$query->where('price','<=',$priceMax);
})
->when(($countRoom),function($query)use($countRoom){
return$query->whereIn('count_room',$countRoom);
})
->limit(15)
->paginate(15);
}
}
<?php
namespaceApp\Http\Controllers;
useApp\Http\Requests\ClientRequest;
useIlluminate\Http\Request;
useApp\Client;
useIlluminate\Support\Facades\Validator;
103
classClientControllerextendsController
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
publicfunctionindex()
{
returnview('client.index');
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
publicfunctioncreate()
{
//return view('client.create');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
publicfunctionstore(ClientRequest$request)
{
$client=Client::create($request->all());
returnjson_encode(['success'=>true,'added'=>$client]);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
publicfunctionshow($id)
{
//
}
/**
* Обновлениеспецифичноймодели
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
publicfunctionupdate(ClientRequest$request,$id)
{
$client=Client::findOrFail($id);
$client->fill($request->all());
$client->save();
returnjson_encode(['success'=>true,'updated'=>$client]);
}
/**
* Удаление специфичной модели
*
* @param int $id
* @return \Illuminate\Http\Response
104
*/
publicfunctiondestroy($id)
{
$client=Client::findOrFail($id);
$client->delete();
returnjson_encode(['success'=>true,'deleted'=>$id]);
}
publicfunctionsearch(Request$request){
$searchField=$request->search_field;
$createdAtField=$request->created_at_field;
$fcField=$request->fc_field;
returnClient::
when($fcField,function($query)use($fcField){
return$query->where('fc',$fcField);
})
->when($createdAtField,function($query)use($createdAtField){
$explodedCreated=explode(',',$createdAtField);
switch(count($explodedCreated)){
case2:
return$query->whereBetween('created_at',[$explodedCreated[0],$explodedCreated[1]]);
case1:
return$query->where('created_at','>=',$explodedCreated[0]);
default:
returnfalse;
}
})
->when($searchField,function($query)use($searchField){
return$query
->where(function($query)use($searchField){
$query->where('f_name','like','%'.$searchField.'%')
->orWhere('m_name','like','%'.$searchField.'%')
->orWhere('l_name','like','%'.$searchField.'%')
->orWhere('id','like','%'.$searchField.'%')
->orWhere('address','like','%'.$searchField.'%')
->orWhere('phone','like','%'.$searchField.'%');
});
})
->limit(15)
->paginate(15);
}
}
<?php
namespaceApp\Http\Controllers;
useApp\Http\Requests\OrderRequest;
useApp\Order;
useApp\OrderStatus;
useIlluminate\Http\Request;
useApp\Operation;
useIlluminate\Support\Facades\Auth;
classOrderControllerextendsController
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
publicfunctionindex()
{
returnview('order.index',['backToFront'=>[
105
'operations'=>Operation::all(),
'statuses'=>OrderStatus::all()
]]);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
publicfunctioncreate()
{
//
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
publicfunctionstore(OrderRequest$request)
{
$toFill=$request->all();
$toFill['agent_id']=$request->user()->id;
$order=Order::create($toFill);
returnjson_encode(['success'=>true,'added'=>$order]);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
publicfunctionshow($id)
{
//
}
/**
* Обновлениеспецифичноймодели
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
publicfunctionupdate(OrderRequest$request,$id)
{
$order=Order::findOrFail($id);
$toFill=$request->all();
$toFill['agent_id']=$request->user()->id;
$order->fill($toFill);
$order->save();
returnjson_encode(['success'=>true,'updated'=>$order]);
}
/**
* Удаление специфичной модели
*
* @param int $id
106
* @return \Illuminate\Http\Response
*/
publicfunctiondestroy($id)
{
$client=Order::findOrFail($id);
$client->delete();
returnjson_encode(['success'=>true,'deleted'=>$id]);
}
publicfunctionsearch(Request$request){
$searchField=$request->client_field;
$createdAtField=$request->created_at_field;
$operationField=$request->operation_field;
$statusField=$request->status_field;
$agentField=$request->agent_field;
$onlyMy=$request->only_my;
returnOrder::with('status','operation','agent','client')
->when($operationField,function($query)use($operationField){
return$query->where('operation_id',$operationField);
})
->when($statusField,function($query)use($statusField){
return$query->where('order_status_id',$statusField);
})
->when($createdAtField,function($query)use($createdAtField){
$explodedCreated=explode(',',$createdAtField);
switch(count($explodedCreated)){
case2:
return$query->whereBetween('created_at',[$explodedCreated[0],$explodedCreated[1]]);
case1:
return$query->where('created_at','>=',$explodedCreated[0]);
default:
returnfalse;
}
})
->when($searchField,function($query)use($searchField){
return$query
->where(function($query)use($searchField){
$query->where('f_name','like','%'.$searchField.'%')
->orWhere('m_name','like','%'.$searchField.'%')
->orWhere('l_name','like','%'.$searchField.'%')
->orWhere('id','like','%'.$searchField.'%');
});
})
->when($agentField,function($query)use($agentField){
$queryTwo="clients.id like '%".$agentField."%' OR "
."clients.f_name like '%".$agentField."%' OR "
."clients.l_name like '%".$agentField."%' OR"
."clients.m_name like '%".$agentField."%'"
."";
return$query->whereExists(function($query)use($queryTwo){
$query->select(DB::raw('id, f_name, l_name, m_name'))
->from('clients')
->whereRaw($queryTwo);
});
})