src/Jaxon/Idempiere/Order.php line 292

Open in your IDE?
  1. <?php
  3. namespace App\Jaxon\Idempiere;
  5. use App\Entity\Idempiere\AdUser;
  6. use App\Entity\Idempiere\CBpartner;
  7. use App\Entity\Idempiere\CBpartnerLocation;
  8. use App\Entity\Idempiere\COrder;
  9. use App\Jaxon\Base;
  10. use App\Repository\Idempiere\AdUserRepository;
  11. use Doctrine\Common\Collections\ArrayCollection;
  12. use Doctrine\Common\Collections\Criteria;
  13. use Doctrine\Common\Collections\Expr\Comparison;
  14. use Jaxon\Response\Response;
  16. // TODO: Crear metodo para cambiar tercero de la orden "changeBpartner"
  17. // TODO: Crear metodo para cambiar vendedor de la orden "changeSalesrep"
  19. class Order extends Base
  20. {
  22. /**
  23. * Crear orden con los datos del formulario
  24. *
  25. * @param array $formData
  26. *
  27. * @return \App\Entity\COrder Respuesta
  28. */
  29. // public function create(
  30. // Array $formData
  31. // )
  32. // {
  33. // $user = $this->session->get('user', null);
  34. // $organization = $this->session->get('organization', null);
  35. // $warehouse = $this->session->get('warehouse', null);
  37. // $RSequence = $this->manager->getRepository(AdSequence::class);
  38. // $ROrder = $this->manager->getRepository(COrder::class);
  39. // $Order = new COrder();
  40. // $Order->setCOrderId( $RSequence->findNextSequence($ROrder->sequence) );
  42. // $date = new \DateTime("now");
  43. // $Order
  44. // ->setAdClientId( $organization->getAdClientId() )
  45. // ->setAdOrgId( $organization->getId() )
  46. // ->setDescription( $formData['description'] )
  47. // ->setIsactive('Y')
  48. // ->setIssotrx('Y')
  49. // ->setIsapproved('N')
  50. // ->setCOrderUu( $RSequence->findNextUU() )
  51. // ->setDateordered( $date )
  52. // ->setDateacct( $date )
  53. // ->setCreated( $date )
  54. // ->setCreatedby( $user->getId() )
  55. // ->setUpdated( $date )
  56. // ->setUpdatedby( $user->getId() );
  58. // $RUser = $this->manager->getRepository(AdUserR::class );
  59. // $salesrep = $RUser->find( $formData['salesrep_id'] );
  60. // $Order->setSalesrep( $salesrep );
  62. // $RDoctype = $this->manager->getRepository(CDoctype::class);
  63. // $doctype = $RDoctype->find($formData['documenttype']);
  64. // $sequence = $RSequence->find( $doctype->getDocnosequenceId() );
  65. // $Order
  66. // ->setCDoctype( $doctype )
  67. // ->setCDoctypeId( $doctype->getId() )
  68. // ->setDocumentno( $RSequence->findNextSequence($sequence, $Order) )
  69. // ->setDocstatus('DR')
  70. // ->setDocaction('PR')
  71. // ->setProcessing('Y')
  72. // ->setProcessed('N');
  74. // $RBpartner = $this->manager->getRepository(CBpartner::class);
  75. // $partner = $RBpartner->find( !empty($formData['bpartner_id']) ? $formData['bpartner_id'] : Constant::C_BPartner_ID );
  76. // $Order->setCBpartner( $partner );
  78. // $RPartnerLocation = $this->manager->getRepository(CBpartnerLocation::class);
  79. // $location = $RPartnerLocation->find( !empty($formData['bpartner_id']) ? $formData['address'] : Constant::C_BPartner_Location_ID ) ;
  80. // $Order->setCBpartnerLocation( $location );
  82. // $RPaymentterm = $this->manager->getRepository(CPaymentterm::class);
  83. // $paymentterm = $RPaymentterm->find($formData['paymentterm']);
  84. // $Order
  85. // ->setCPaymentterm( $paymentterm )
  86. // ->setPaymentrule('P');
  88. // $RCurrency = $this->manager->getRepository(CCurrency::class);
  89. // $currency = $RCurrency->find($formData['currency']);
  90. // $Order
  91. // ->setCCurrency($currency)
  92. // ->setInvoicerule('I')
  93. // ->setDeliveryrule('A')
  94. // ->setFreightcostrule('I')
  95. // ->setDeliveryviarule('P')
  96. // ->setPriorityrule('5');
  98. // $RPricelist = $this->manager->getRepository(MPricelist::class);
  99. // $pricelist = $RPricelist->find($formData['pricelist']);
  100. // $Order
  101. // ->setMPricelist($pricelist)
  102. // ->setMWarehouseId( $formData['warehouse'] )
  103. // ->setTotallines(0)
  104. // ->setGrandtotal(0);
  106. // $manager = $this->manager->getManager();
  107. // $manager->persist($Order);
  109. // try {
  110. // $manager->flush();
  111. // $manager->clear();
  112. // } catch(Exception $e) {
  113. // throw $e;
  114. // }
  116. // $this->session->set('order', $Order);
  118. // return $Order;
  119. // }
  121. /**
  122. * Elimina el pedido de las ordenes activas
  123. *
  124. * @param int $Order_ID Identificador de la orden
  125. * @param bool $IsTemp Bandera de pedidos temporales
  126. *
  127. * @return string/bool Mensaje de error / Estado de la consulta
  128. */
  129. // public function delete(
  130. // Int $Order_ID,
  131. // Bool $IsTemp = true
  132. // )
  133. // {
  134. // $jxnr = new Response;
  135. // $order = new ModelOrder;
  137. // if( $order->delete($Order_ID, $IsTemp) )
  138. // $jxnr->redirect('/dashboard');
  139. // else
  140. // $jxnr->script( self::displayError('Oops!', 'No fue posible eliminar el pedido.') );
  142. // return $jxnr;
  143. // }
  145. /**
  146. * Obtiene todos los terceros coincidentes
  147. *
  148. * @param string $value Codigo del tercero
  149. * @param int $salesrep_id Identificador del vendedor
  150. *
  151. * @return Jaxon\Response\Response Respuesta
  152. */
  153. public function getBpartners(
  154. String $value = '',
  155. Int $salesrep_id = 0
  156. ): Response
  157. {
  158. $jxnr = new Response;
  160. $user = $salesrep_id > 0 ?
  161. $this->manager->getRepository(AdUser::class)->find($salesrep_id) : $this->session()->get('user', null);
  163. $RBpartner = new $this->manager->getRepository(CBpartner::class);
  164. $criteria_bp = [
  165. 'iscustomer' => 'Y',
  166. 'issummary' => 'N',
  167. 'ismatriz' => 'N',
  168. 'isactive' => 'Y'
  169. ];
  171. // Buscar terceros asignados
  172. if ( $user->getCBpartnerId() && $RBpartner->find($user->getCBpartnerId())->getIssalesrep() )
  173. $criteria_bp['c_bpartner_id'] = $RBpartner->findBySalesRep($user->getId());
  175. $bpartners = new ArrayCollection( $RBpartner->findBy($criteria_bp) );
  177. // Seleccionar terceros coincidentes
  178. if ( !empty($value) ) {
  179. $searchN = new Comparison('name', 'CONTAINS', $value);
  180. $searchV = new Comparison('value', 'CONTAINS', $value);
  181. $criteria = new Criteria();
  183. $criteria->where($searchN)->orWhere($searchV);
  184. $bpartners = $bpartners->matching($criteria);
  185. }
  187. $html = '<table id="bpartnerTable" class="table"><thead><tr><th>Nombre</th><th>C&oacute;digo</th></tr></thead><tbody>';
  188. if( count($bpartners) > 0 ) {
  189. foreach ($bpartners as $bpartner) {
  190. $html .=
  191. '<tr class="btn-close" style="cursor: pointer;" onclick="App.Jaxon.Idempiere.Order.setBpartner(\''. $bpartner->getValue() .'\', $(\'#salesrep_id\').val() )">
  192. <td>'. $bpartner->getName() .'</td>
  193. <td>'. $bpartner->getValue() .'</td>
  194. </tr>';
  195. }
  196. } else {
  197. $html .= '<tr><td colspan="2">NO SE HA ENCONTRADO NINGUN CLIENTE</td></tr>';
  198. }
  199. $html .= '</tbody></table>';
  200. $jxnr
  201. ->assign('bpartners', 'innerHTML', $html)
  202. ->script('$("#bpartnerTable").dataTable({ columnDefs: [{ orderable: true, targets: 0 }], order: [[1, "asc" ]], responsive: true, lengthChange: false, autoWidth: false, dom: \'<"row"<"col-sm-12 col-md-12"f>><"row"<"col-sm-12"rt>><"row"<"col-sm-12 col-md-5"i><"col-sm-12 col-md-7"p>>\', buttons: ["copy", "csv", "excel", "pdf", "print", "colvis"] })');
  204. return $jxnr;
  205. }
  207. /**
  208. * Obtiene todos los vendedores coincidentes
  209. *
  210. * @param string $name Nombre del vendedor
  211. * @param int $ad_user_id Identificador del usuario
  212. *
  213. * @return Jaxon\Response\Response Respuesta
  214. */
  215. public function getSalesreps(
  216. String $name = '',
  217. Int $ad_user_id = 0
  218. ): Response
  219. {
  220. /** @var AdUserRepository AdUser Repository */
  221. $RUser = $this->manager->getRepository(AdUser::class);
  223. $salesreps = [];
  224. $user = $this->session->get('user', null);
  225. if ( $user->getCBpartnerId() > 0 )
  226. {
  227. $RBpartner = $this->manager->getRepository(CBpartner::class);
  228. $partner = $RBpartner->find( $user->getCBpartnerId() );
  229. if ( $partner->getIssalesrep() )
  230. {
  231. $smSalesreps = $partner->getSmSalesReps();
  232. foreach ($smSalesreps as $ss) {
  233. array_push($salesreps, $RUser->find($ss->getSalesrepId()));
  234. }
  235. }
  236. } else {
  237. $salesreps = $RUser->findSalesrep($name);
  238. }
  240. $html = '<table id="salesrepTable" class="table"><thead><tr><th>Nombre</th><th>Descripci&oacute;n</th><th>Correo</th></tr></thead><tbody>';
  241. if( count($salesreps) > 0 ) {
  242. foreach ($salesreps as $salesrep) {
  243. $html .=
  244. '<tr class="btn-close" style="cursor: pointer;" onclick="App.Jaxon.Idempiere.Order.setSalesrep(\''. $salesrep->getName() .'\')">
  245. <td>'. $salesrep->getName() .'</td>
  246. <td>'. $salesrep->getDescription() .'</td>
  247. <td>'. $salesrep->getEmail() .'</td>
  248. </tr>';
  249. }
  250. } else {
  251. $html .= '<tr><td colspan="2">NO SE HA ENCONTRADO NINGUN VENDEDOR</td></tr>';
  252. }
  253. $html .= '</tbody></table>';
  255. $jxnr = new Response;
  256. $jxnr
  257. ->assign('salesreps', 'innerHTML', $html)
  258. ->script('$("#salesrepTable").dataTable({ columnDefs: [{ orderable: true, targets: 0 }], order: [[1, "asc" ]], responsive: true, lengthChange: false, autoWidth: false })');
  260. return $jxnr;
  261. }
  263. /**
  264. * Obtiene el numero de la localizacion
  265. *
  266. * @param int $c_bpartner_location_id Identificador de la localizacion
  267. *
  268. * @return Jaxon\Response\Response Respuesta
  269. */
  270. public function getPhone(
  271. Int $c_bpartner_location_id
  272. ): Response
  273. {
  274. $partnerLocation = $this->manager->getRepository(CBpartnerLocation::class)->find($c_bpartner_location_id);
  276. $jxnr = new Response;
  277. if ($partnerLocation->getId() > 0)
  278. $jxnr->assign('phone', 'value', $partnerLocation->getPhone());
  279. else
  280. $jxnr->alert('No olvides seleccionar una direcion!');
  282. return $jxnr;
  283. }
  285. /**
  286. * Instanciar funciones jaxon en la orden
  287. *
  288. * @param int $c_order_id
  289. *
  290. * @return Jaxon Jaxon Response
  291. */
  292. public function init( Int $c_order_id = null ): Response
  293. {
  294. if ( isset($c_order_id) ) {
  295. $ROrder = new $this->manager->getRepository(COrder::class);
  296. $order = $ROrder->find( $c_order_id );
  297. $this->session->set('order', $order);
  298. }
  300. $jxnr = new Response;
  301. if( is_null($c_order_id) || $order->getDocstatus() == 'DR' ) {
  302. $jxnr
  303. ->setEvent('organization', 'onchange', rq('App.Jaxon.Idempiere.Organization')->call('getPricelist', pm()->select('organization')))
  304. // Cliente
  305. ->setEvent('address', 'onchange', rq('App.Jaxon.Idempiere.Order')->call('getPhone', pm()->select('address')))
  306. ->setEvent('getBpartners', 'onclick', rq('App.Jaxon.Idempiere.Order')->call('getBpartners', pm()->input('bpartner_value'), pm()->input('salesrep_id')))
  307. ->setEvent('setBpartner', 'onclick', rq('App.Jaxon.Idempiere.Order')->call('setBpartner', pm()->input('bpartner'), pm()->input('salesrep_id')))
  308. ->setEvent('bpartner_id', 'onchange', rq('App.Jaxon.Idempiere.Order')->call('changeBpartner', pm()->input('bpartner_id')))
  309. // Vendedor
  310. //->setEvent('getSalesreps', 'onclick', rq('App.Jaxon.Idempiere.Order')->call('getSalesreps', pm()->input('salesrep_value')))
  311. //->setEvent('setSalesrep', 'onclick', rq('App.Jaxon.Idempiere.Order')->call('setSalesrep', pm()->input('salesrep')))
  312. //->setEvent('salesrep_id', 'onchange', rq('App.Jaxon.Idempiere.Order')->call('changeSalesrep', pm()->input('salesrep_id')))
  313. // Productos
  314. ->setEvent('getProducts', 'onclick', rq('App.Jaxon.Idempiere.Orderline')->call('getProducts', pm()->input('product_value'), pm()->form('order')));
  315. }
  317. if( !is_null($c_order_id) )
  318. $jxnr->setEvent('process', 'onclick', rq('App.Jaxon.Idempiere.Order')->call('process', $c_order_id));
  320. return $jxnr;
  321. }
  323. /**
  324. * Asigna el tercero a la orden
  325. *
  326. * @param string $value Codigo del tercero
  327. * @param int $salesrep_id Identificador del vendedor
  328. *
  329. * @return Jaxon\Response\Response Respuesta
  330. */
  331. # TODO: Buscar coincidencias solo entre los clientes del vendedor
  332. public function setBpartner(
  333. String $value = '',
  334. Int $salesrep_id = 0
  335. ): Response
  336. {
  337. $jxnr = new Response;
  339. if(empty($value))
  340. return $jxnr->script('Swal.fire("Oops!", "El campo no puede estar vacio!", "warning")');
  342. $RBpartner = $this->manager->getRepository(CBpartner::class);
  343. $partner = $RBpartner->findOneBy(['value' => $value]);
  344. $bpLocation = $partner->getCBpartnerLocation();
  345. $address = '';
  346. $i = 0;
  347. foreach ($bpLocation as $location) {
  348. $checked = '';
  349. if($i == 0) {
  350. $phone = $location->getPhone();
  351. $checked = 'checked="true"';
  352. }
  354. $address .= '<option value="'. $location->getId() .'" '. $checked .'>'. $location->getCLocation()->getAddress1() .'</option>';
  355. $i++;
  356. }
  358. $user = $salesrep_id > 0 ?
  359. $this->manager->getRepository(AdUser::class)->find($salesrep_id) : $this->session()->get('user', null);
  360. $description = 'Pedido Web: ' . $user->getName() . ' - ' . $partner->getName();
  361. $jxnr
  362. ->assign('bpartner_id', 'value', $partner->getId())
  363. ->assign('bpartner', 'value', $partner->getValue())
  364. ->assign('description', 'value', $description)
  365. ->assign('address', 'innerHTML', $address)
  366. ->assign('phone', 'value', $phone)
  367. ->assign('address', 'disabled', false)
  368. ->script('$("#bpartnerModal").modal("hide")');
  370. return $jxnr;
  371. }
  373. /**
  374. * Asigna el vendedor a la orden
  375. *
  376. * @param string $name Nombre del vendedor
  377. * @param int $ad_user_id Identificador del usuario
  378. *
  379. * @return Jaxon\Response\Response Respuesta
  380. */
  381. # TODO: Busca que el vendedor sea de los asignados o el mismo
  382. public function setSalesrep(
  383. String $name = '',
  384. Int $ad_user_id = 0
  385. ): Response
  386. {
  387. $jxnr = new Response;
  389. if(empty($name))
  390. return $jxnr->script('Swal.fire("Oops!", "El campo no puede estar vacio!", "warning")');
  392. $RUser = $this->manager->getRepository(AdUser::class);
  393. $user = $RUser->findOneBy(['name' => $name]);
  394. $jxnr
  395. ->assign('salesrep_id', 'value', $user->getId())
  396. ->assign('salesrep', 'value', $user->getName())
  397. ->clear('bpartner_value', 'value')
  398. ->clear('address', 'value')
  399. ->clear('phone', 'value')
  400. ->clear('bpartner', 'value')
  401. ->clear('bpartner_id', 'value')
  402. ->clear('bpartners')
  403. ->clear('description', 'value')
  404. ->script('$("#salesrepModal").modal("hide")');
  406. return $jxnr;
  407. }
  408. }
  410. ?>