Revision history [back]

Revision 4

updated 2018-09-13 10:28:53 +0200

يمكن ذلك من خلال آلية التحقق بناء على معايير.
و تقوم بوضع الاستعلام التالي في استعلام عندما و يمكن تعديله اذا تطلب الامر:

select case when {customer.limitValue} > 0 and
(COALESCE(SUM(l.debitLocalAmount-l.creditLocalAmount),0)+{money.remaining}>{customer.limitValue}) 
then 1 else 0 end       from Customer c  
left join  ledgertransline l on l.subsidiaryId = c.id and c.mainAccount_id = l.account_id and l.originId <> {id} 
where c.id = {customer.id}

و اذا اردت ان تجعل النظام يقوم بالتاكد من رصيد الحساب الرئيسي و حساب 1 معا مثلا قم باستعمال الاستعلام التالي:

select case when {customer.limitValue} > 0 and
(COALESCE(SUM(l.debitLocalAmount-l.creditLocalAmount),0)+{money.remaining}>{customer.limitValue}) 
then 1 else 0 end       from Customer c  
left join  ledgertransline l on l.subsidiaryId = c.id 
and l.account_id in (coalesce(c.mainAccount_id,0x1),coalesce(c.account1_id,0x1)) and l.originId <> 
{id} where c.id = {customer.id}

Revision 3

9.1k

Eldabbas

updated 2018-09-13 10:16:23 +0200

select case when {customer.limitValue} > 0 and (COALESCE(SUM(l.debitLocalAmount-l.creditLocalAmount),0)+{money.remaining}>{customer.limitValue}) then 1 else 0 end from Customer c left join ledgertransline l on l.subsidiaryId = c.id and c.mainAccount_id c.mainAccountid = l.account_id l.accountid and l.originId <> {id} where c.id = {customer.id}
{customer.id}

و اذا اردت ان تجعل النظام يقوم بالتاكد من رصيد الحساب الرئيسي و حساب 1 معا مثلا قم باستعمال الاستعلام التالي:

select case when {customer.limitValue} > 0 and (COALESCE(SUM(l.debitLocalAmount-l.creditLocalAmount),0)+{money.remaining}>{customer.limitValue}) then 1 else 0 end from Customer c left join ledgertransline l on l.subsidiaryId = c.id and l.account_id l.accountid in (coalesce(c.mainAccount_id,0x1),coalesce(c.account1_id,0x1)) (coalesce(c.mainAccountid,0x1),coalesce(c.account1_id,0x1)) and l.originId <> {id} where c.id = {customer.id}

Revision 2

9.1k

Eldabbas

updated 2018-09-13 10:14:51 +0200

select case when {customer.limitValue} > 0 and (COALESCE(SUM(l.debitLocalAmount-l.creditLocalAmount),0)+{money.remaining}>{customer.limitValue}) then 1 else 0 end from Customer c left join ledgertransline l on l.subsidiaryId = c.id and c.mainAccountid = l.accountid and l.originId <> {id} where c.id = {customer.id}

و اذا اردت ان تجعل النظام يقوم بالتاكد من رصيد الحساب الرئيسي و حساب 1 معا مثلا قم باستعمال الاستعلام التالي:

select case when {customer.limitValue} > 0 and (COALESCE(SUM(l.debitLocalAmount-l.creditLocalAmount),0)+{money.remaining}>{customer.limitValue}) then 1 else 0 end from Customer c left join ledgertransline l on l.subsidiaryId = c.id and l.accountid in (coalesce(c.mainAccountid,0x1),coalesce(c.account1_id,0x1)) and l.originId <> {id} where c.id = {customer.id}

Revision 1

9.1k

Eldabbas

answered 2018-09-13 10:13:35 +0200

و اذا اردت ان تجعل النظام يقوم بالتاكد من رصيد الحساب الرئيسي و حساب 1 معا مثلا قم باستعمال الاستعلام التالي:

/DIV>

select case when {customer.limitValue} > 0 and (COALESCE(SUM(l.debitLocalAmount-l.creditLocalAmount),0)+{money.remaining}>{customer.limitValue}) then 1 else 0 end from Customer c left join ledgertransline l on l.subsidiaryId = c.id and l.accountid in (coalesce(c.mainAccountid,0x1),coalesce(c.account1_id,0x1)) and l.originId <> {id} where c.id = {customer.id}