[Spce-user] call list for subscriber does'nt show costs in CE mr4.1.2

Sergio Serrano sergio.serrano at avanzada7.com
Tue Sep 13 06:16:41 EDT 2016


Hi all,

	I have a little problem with show costs in web portal for subscriber. If I exec mysql query

mysql> select * from cdr where id = 51\G;                                                                                                                                                                                                   
*************************** 1. row ***************************                                                                                                                                                                               
                                  id: 51                                                                                                                                                                                                     
                         update_time: 2016-09-13 11:55:02                                                                                                                                                                                    
                      source_user_id: c293f477-722c-449d-97ed-7abc9b76bcd6                                                                                                                                                                   
                  source_provider_id: 4                                                                                                                                                                                                      
       source_external_subscriber_id:                                                                                                                                                                                                        
         source_external_contract_id:                                                                                                                                                                                                        
                   source_account_id: 3                                                                                                                                                                                                      
                         source_user: ------------------------hidden------------------------
                       source_domain: ------------------------hidden------------------------
                          source_cli: ------------------------hidden------------------------
                         source_clir: 0                                                                                                                                                                                                      
                           source_ip: ------------------------hidden------------------------
                         source_gpp0: NULL                                                                                                                                                                                                   
                         source_gpp1: NULL                                                                                                                                                                                                   
                         source_gpp2: NULL                                                                                                                                                                                                   
                         source_gpp3: NULL                                                                                                                                                                                                   
                         source_gpp4: NULL                                                                                                                                                                                                   
                         source_gpp5: NULL                                                                                                                                                                                                   
                         source_gpp6: NULL                                                                                                                                                                                                   
                         source_gpp7: NULL                                                                                                                                                                                                   
                         source_gpp8: NULL                                                                                                                                                                                                   
                         source_gpp9: NULL                                                                                                                                                                                                   
                 destination_user_id: 0
             destination_provider_id: 2
  destination_external_subscriber_id: 
    destination_external_contract_id: 
              destination_account_id: 0
                    destination_user: ------------------------hidden------------------------
                  destination_domain: ------------------------hidden------------------------
             destination_user_dialed: ------------------------hidden------------------------
                 destination_user_in: ------------------------hidden------------------------
               destination_domain_in: ------------------------hidden------------------------
                    destination_gpp0: NULL
                    destination_gpp1: NULL
                    destination_gpp2: NULL
                    destination_gpp3: NULL
                    destination_gpp4: NULL
                    destination_gpp5: NULL
                    destination_gpp6: NULL
                    destination_gpp7: NULL
                    destination_gpp8: NULL
                    destination_gpp9: NULL
                      peer_auth_user: 
                     peer_auth_realm: 
                           call_type: call
                         call_status: ok
                           call_code: 200
                           init_time: 1473760078.233
                          start_time: 1473760089.247
                            duration: 60.585
                             call_id: 8_3074806706 at 10.0.69.2
                 source_carrier_cost: 0.012810
                source_reseller_cost: 0.035380
                source_customer_cost: 0.035380
            source_carrier_free_time: 0
           source_reseller_free_time: 0
           source_customer_free_time: 0
       source_carrier_billing_fee_id: 65587
      source_reseller_billing_fee_id: 41294
      source_customer_billing_fee_id: 41294
      source_carrier_billing_zone_id: 2986
     source_reseller_billing_zone_id: 842
     source_customer_billing_zone_id: 842
            destination_carrier_cost: 0.000000
           destination_reseller_cost: 0.000000
           destination_customer_cost: 0.000000
       destination_carrier_free_time: 0
      destination_reseller_free_time: 0
      destination_customer_free_time: 0
  destination_carrier_billing_fee_id: NULL
 destination_reseller_billing_fee_id: NULL
 destination_customer_billing_fee_id: NULL
 destination_carrier_billing_zone_id: NULL
destination_reseller_billing_zone_id: NULL
destination_customer_billing_zone_id: NULL
                 frag_carrier_onpeak: NULL
                frag_reseller_onpeak: NULL
                frag_customer_onpeak: NULL
                       is_fragmented: NULL
                               split: 0
                            rated_at: 2016-09-13 11:49:11
                       rating_status: ok
                         exported_at: 2016-09-13 11:55:02
                       export_status: ok

You can see as source cost is setup in bbdd, but in web portal I see

#	originador	Destino	Billing zone	Estado	Hora de Inicio	Duración		Call-ID						Cost
51	hidden		hidden	ESP-MOBA	ok		2016-09-13 11:48:09.247  8_3074806706 at 10.0.69.2 		0.00


How is this possible? A bug?



Best Regards,

Sergio




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20160913/49708205/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20160913/49708205/attachment.asc>


More information about the Spce-user mailing list