Zechariah 12 (and 13) - 1st or 2nd Advent?

[Mellontes]

I hope many respond with their links, Scriptures, and reasons why they believe it refers to their particular advent. I also hope to give this link to a friend of mine in regards to some of our personal discussion on this passage. He is a dispensationalist.

I really want to focus in on Zechariah 12 (12:10) and chapter 13 (13:7) because of John 19:37 and Matthew 26:31 respectively...

I cannot get my dispensational friend to understand that the beloved disciple in John 19:37 sources Zechariah 12:10 as a fulfillment regarding Calvary.

Many thanks in advance!

P.S. - If you could state at the beginning of your response as to whether it refers to the 1st or 2nd advent, it would help me to understand the focus of your article right up front.