目前,我有一个在事件日历中添加订单的工作代码,但我不打算添加订单的到期日期(在订单发送30天后)。
//Include db configuration file
include 'connect.php';
$currentDate = date("Y-m-d H:i:s");
//Insert the event data into database
$insert = $conn->query("INSERT INTO events (title,date,created,modified,tht) V
嗨,我正在寻找一个查询,它可以给我一个从订购日期起30天后发出的销售订单通知,并显示通知4天后消失。
例如,如果我在2016-01-19上下了销售订单,在添加30天后,我的开始日期将是2016-02-18,将4天添加到当前日期,我的结束日期将是2016-02-23‘
我尝试使用下面的查询来完成这个任务,但是它没有给出所需的输出,这是2016-02-18和2016-02-23之间的记录。
从下面获得的输出查询为空
select * from [dbo].[Orders] where [OrderDate] between Dateadd(d, 30, OrderDate) and Dateadd
我添加了一个按钮,只有当它处于特定的订单状态时才会出现。因为它不是在商务中设置的按钮,所以我必须在下订单七天后隐藏该按钮。你能帮我一下吗? 最好的 // Add button when order status is 'completed'
add_filter( 'woocommerce_my_account_my_orders_actions', 'add_my_account_my_orders_custom_action', 10, 2 );
function add_my_account_my_orders_custom_act
我有下面的INSTEAD OF DELETE触发器,它在回滚任何删除尝试时发送一封电子邮件。
ALTER TRIGGER tr_OnDel_Orders
ON ORDERS
INSTEAD OF DELETE
AS
BEGIN
SET NOCOUNT ON;
declare @b varchar(5000)
Declare @OrderID BIGINT,
SELECT @OrderID = OrderID
FROM deleted d
set @b = 'Someone attempted to delete the following order:' + C
当我删除父表时,我需要删除表的子表。常见的订单/详细信息示例。
我使用这个代替触发器:
CREATE TRIGGER trg_OderDelete
ON Oders
INSTEAD OF DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
Delete fro