Select * from quickbook_info where allow=1 AND data_file_name !='' AND execute_status_done=1 and user_id=18
testArray ( [0] => stdClass Object ( [id] => 62 [magicpayUsername] => KNlJyTmlgdZbnmV9ukVb6p7fpu+HRYELNXoVM6mzGA8= [magicpayPassword] => ITXPDI3vjq0E21zStPW3ug== [data_file_name] => 18.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 0 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 18 ) )
testArray ( [0] => stdClass Object ( [id] => 58 [magicpayUsername] => KNlJyTmlgdZbnmV9ukVb6tKxhOxJAoTvZKTAP47Olxs= [magicpayPassword] => mhq8kttVUZmeHZVxkC3VIw== [data_file_name] => 29.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 0 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 29 ) )
testArray ( [0] => stdClass Object ( [id] => 41 [magicpayUsername] => Gs1hrXj171woP1B2Z8bhnQ== [magicpayPassword] => NvVKV5FsxUavJ/XpXFaM+g== [data_file_name] => 15.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 0 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 15 ) )
testArray ( [0] => stdClass Object ( [id] => 54 [magicpayUsername] => SyBE6x4Ka6GvQl5HgQwJRw== [magicpayPassword] => NvVKV5FsxUavJ/XpXFaM+g== [data_file_name] => 12.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 0 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => 3 [invoice_no_from_doc] => 0 [user_id] => 12 ) )
testArray ( [0] => stdClass Object ( [id] => 61 [magicpayUsername] => Hh7Fon0TMqOYCWSI37OA8A== [magicpayPassword] => mAqSNSHLIXoEcwUa0rQ27g== [data_file_name] => 1.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 1 ) )
testArray ( [0] => stdClass Object ( [id] => 65 [magicpayUsername] => KNlJyTmlgdZbnmV9ukVb6mXBOeyeyXidn9so/xFFcQk= [magicpayPassword] => jbIWLRzt50xMvLPK/X3vtw== [data_file_name] => 30.txt [user_type] => magicpay [allow] => 1 [full_sync] => 1 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 30 ) )
testArray ( [0] => stdClass Object ( [id] => 66 [magicpayUsername] => BUWM0IaEcaNBMcrO8f13Yw== [magicpayPassword] => B8eWsU9Ylo01aawQ9Wx8ug== [data_file_name] => 28.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 0 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 28 ) )
testArray ( [0] => stdClass Object ( [id] => 68 [magicpayUsername] => QOKR70tIacK5LnffQuuQaA== [magicpayPassword] => g+57k2rXRAwaA1gAFRh4Tg== [data_file_name] => 37.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 0 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 37 ) )
testArray ( [0] => stdClass Object ( [id] => 69 [magicpayUsername] => NOjIVOdPzkUYvAS11xYysg== [magicpayPassword] => xIJXViao+eorRlbrj0M81A== [data_file_name] => 39.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 1 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 39 ) )
testArray ( [0] => stdClass Object ( [id] => 70 [magicpayUsername] => fXXZxgEvR7xsG+DJ2QNCqw== [magicpayPassword] => uhD0iRygOsIusFHoJsyPtQ== [data_file_name] => 41.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 0 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 41 ) )
testArray ( [0] => stdClass Object ( [id] => 71 [magicpayUsername] => b8NBtxSeiSViO1hNvZJfGg== [magicpayPassword] => vdIIDD2pCezsqhtHBRWVDQ== [data_file_name] => 44.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 0 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 44 ) )
testArray ( [0] => stdClass Object ( [id] => 73 [magicpayUsername] => SFsmtPeFw+vRA2sFdcwjrw== [magicpayPassword] => PI0Tct1QIOSc3bBCn5hMiVUVzWbvTMKdA+oEVQ8GFu29qpZGDVbDQGZ3SUETe1gq [data_file_name] => 47.txt [user_type] => nmi [allow] => 1 [full_sync] => 1 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 0 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 47 ) )
testArray ( [0] => stdClass Object ( [id] => 74 [magicpayUsername] => nQiVxQAO1xtsVWDVsUNO65mb+Km6XCAfqU+4h3MtgB4= [magicpayPassword] => qcRNkPZAJDipqeSe7K2ouA== [data_file_name] => 54.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 0 [execute_status_done] => 1 [deposit_to_sync] => 42 [invoice_no_from_doc] => 0 [user_id] => 54 ) )
testArray ( [0] => stdClass Object ( [id] => 75 [magicpayUsername] => H2kTX2MbmDdbKCukIvKE1A== [magicpayPassword] => jbIWLRzt50xMvLPK/X3vtw== [data_file_name] => 57.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 0 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 57 ) )
testArray ( [0] => stdClass Object ( [id] => 76 [magicpayUsername] => zF3sK2MIq1gwW+YutrloPw== [magicpayPassword] => XucSMjbbi6PxAW9Nquf1UJd4CPZQmqcBq+vCRI+jWXP9pJlF2rwDaClEIkwbr/vI [data_file_name] => 61.txt [user_type] => nmi [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 0 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 61 ) )
testArray ( [0] => stdClass Object ( [id] => 77 [magicpayUsername] => VrpfX3luUMigjHq1VMPAoA== [magicpayPassword] => eVDaTNywkNEfMLDtV44hUA== [data_file_name] => 64.txt [user_type] => magicpay [allow] => 1 [full_sync] => 0 [payment_sync] => 1 [cust_sync] => 0 [execute_status] => 0 [execute_status_done] => 1 [deposit_to_sync] => [invoice_no_from_doc] => 0 [user_id] => 64 ) )